I have a in-production-db and a development db, residing on two different servers. I am looking for a way to easily synchronize these to, one-way (that is i never want to commit any changes from the dev-db to the production-db).
It is easy to make two dumps and have the linux diff-program generate a patch-file in unified diff-format.
Now I am wondering if anyone know if there is some script or software out there capable of transforming unified diff-files generated from sql-dumpfiles into a .sql-file, that when executed on the dev-db would make the dev-db mirror the production db at the time of the dump.
Of course, being able to select which tables to synchronize would be awfully helpful!
Any help and tips appreciated!
