Re: Synch via Script

[Michael G. Zinner]

Please look at File -> Export -> Forward Engineer SQL ALTER Script...

This feature allows you to specify your original SQL CREATE script and Workbench will generate the ALTER TABLE statements for all your changes you made in comparison to that original script.

This is the same code that is used for the Database -> Synchronize... feature, only that this feature generates the SQL CREATE script on the fly from the live database.

To simulate the exact same procedure, use mysqldump or MySQL Administrator to create the SQL CREATE script right before you want to synchronize, use that for the Forward Engineer SQL ALTER Script... feature and then execute the resulting SQL ALTER script with the mysql client tool or MySQL Query Browser.

Mike

Michael Zinner, Team Lead, Developer Tools
MySQL AB, www.mysql.com

Are you MySQL certified? www.mysql.com/certification