SchemaSync is a command line based and open source tool which helps developers generate the SQL necessary to migrate the schema of a source database to a target database (patch script), as well as a the SQL necessary to undo the changes after you apply them (revert script).
All dependencies for the SchemaSync too are listed in the included README file and detailed installation instructions are available here.
Requirements:
· Python
· MySQL
· MySQL-Python
Limitations:
· Schema Sync does not yet recognize Tables or Columns that have been renamed. A rename will result in the old table or column being dropped and the new one added.
· All ADD|MODIFY COLUMN statements have the AFTER (or FIRST) SQL syntax even if no move is required.
· COMMENTS and AUTO_INCREMENT values are not by synced by default. See help (-h) for details.
· Partitions (MySQL 5.1+) are not yet supported.
What`s New in This Release: [ read full changelog ]
· Added MANIFEST.in so ez_setup.py is included for users without setuptools