Can SVN replicate/copy/synchronize a database like it does code?
A:
No.
What it can do is manage create SQL scripts or ER models which are based on files.
Frank
2010-08-18 21:50:23
+4
A:
This is not the right tool for the job. Version control systems are useful for code. You can define this as content that developers make deliberate, related, commits to in response to particular requirements (e.g. bug reports or feature requests).
Database content is different, because the application changes it directly as users interact with it.
It is appropriate to store the schema (e.g. CREATE TABLE/VIEW statements) in SVN. However, the actual database should rather be backed up (e.g. with mysqldump) and replicated (e.g. with the built-in replication) as needed.
Matthew Flaschen
2010-08-18 21:51:01
+1 backups backups backups!
Michael Robinson
2010-08-18 21:56:24