Bug #62346 Synchronize With Any Source fails when using a source=script and dest=model
Submitted: 4 Sep 2011 21:31 Modified: 6 Sep 2011 19:34
Reporter: Lee Nelson Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Workbench: Modeling Severity:S1 (Critical)
Version:5.2.34.7780 CE OS:Windows (Windows 7 64 bit)
Assigned to: CPU Architecture:Any
Tags: workbench synchronize

[4 Sep 2011 21:31] Lee Nelson
Description:
I would like to update my SQL script by hand and have the changes reflected in the Workbench tool.  I am using workbench only as a diagramming tool.

When I try to use the "Synchronize With Any Source" feature, it fails to generate any output when using a Script File as the Source and the Model Schemata as the Destination.  

The "Send Updates To" field is set to a script file, "alter.sql"

When I click next, I get a page showing that the only task executed is "Retrieve database objects from file".

When I click "next" again, the "back", "next" and "cancel" buttons all become disabled.  The program uses no CPU at this time so I know it isn't busy.

The only way out of this state is to press the "show logs" button, which then re-enables the "back", "next" and "cancel" buttons, allowing me to exit the dialog box.

How to repeat:
Create a script file schema and import it into the program.  

Generate a diagram.

Add a field to the script file schema.

Open the "Synchronize With Any Source" dialog box, and press "next" to skip the intro text.

Set the "Source" to your changed script file.

Set the "Destination" to "Model Schemata"

Set "Send Updates To" to "ALTER Script File:" and "alter.sql"

Press "next"

Note that one task executed ("Retrieve database objects from file")

Press "next"

"Back", "Next" and "Cancel" Buttons all become disabled and no output is ever generated.

Press "Show Logs" to re-enabled the three buttons (This is also a bug I think).

Press "cancel" to exit the dialog box.
[4 Sep 2011 21:34] Lee Nelson
Intial schema

Attachment: test1.sql (application/octet-stream, text), 196 bytes.

[4 Sep 2011 21:35] Lee Nelson
alter file to use as synchronization source

Attachment: test2.sql (application/octet-stream, text), 237 bytes.

[4 Sep 2011 21:39] Lee Nelson
To be clear, it doesn't update the model OR generate any textual output.
[6 Sep 2011 19:34] Rafael Antonio Bedoy Torres
Verified
[12 Feb 2012 16:39] Tomas Putnoky
anything new on this one? sync feature would be really useful. it still doesnt work(5.2.37.8576)