MySQL Forums
Forum List  »  MySQL Workbench

Re: Synch via Script
Posted by: Michael G. Zinner
Date: April 25, 2008 03:02AM

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.


Michael Zinner, Team Lead, Developer Tools

Are you MySQL certified?

Options: ReplyQuote

Written By
April 24, 2008 06:32PM
Re: Synch via Script
April 25, 2008 03:02AM
April 25, 2008 02:21PM
April 25, 2008 05:01PM
April 25, 2008 06:22PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.