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.

Mike

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

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

Options: ReplyQuote


Subject
Views
Written By
Posted
5767
April 24, 2008 06:32PM
Re: Synch via Script
3755
April 25, 2008 03:02AM
3712
April 25, 2008 02:21PM
3681
April 25, 2008 05:01PM
3867
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.