Bug #48444 Database Synchronization Not Working

• Submitted: 30 Oct 19:39
• Modified: 10 Nov 18:16
• Reporter: Joshua Ostrom
• Status: Need Feedback
• Category: MySQL Workbench
• Severity: S2 (Serious)
• Version: 5.1,5.2.6 Alpha
• OS: Microsoft Windows
• Tags: Database Synchronization

[30 Oct 19:39] Joshua Ostrom

Description:
The database synchronization does not work.

The sync will populate an empty database, but will not detect any changes made to the
model thereafter.

The sync also has problems with views and stored procedures, the SQL generated in invalid
MySQL SQL.

If you run a catalog diff, you do see changes so that logic is working.

How to repeat:
Create an empty database.  Sync the model down to the empty database.  Add a new column
to a table in the databaes.

Suggested fix:
No known work around.

The logic for the catalog diff feature *does* detect the changes so maybe a code rewrite
is in order leveraging that logic?

[10 Nov 18:16] Miguel Solorzano

Thank you for the bug report. Sorry but I couldn't repeat with 5.2.6 could you please
provide step by step instructions if possible with screen-shot. Thanks in advance.