Bug #39480 Sync Script issues
Submitted: 16 Sep 2008 14:29 Modified: 20 Oct 2009 11:14
Reporter: Roland Bouman Email Updates:
Status: Won't fix Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:5.0.25 OS:Any
Assigned to: CPU Architecture:Any
Tags: CHECKED

[16 Sep 2008 14:29] Roland Bouman 
Description:
Schema diff sync script not shown in code font, but some proportional font. Syntax highlighting would be nice too.

Also, line ends are gone for the ALTER TABLE statements.

Also, if an error occurs during live db sync, then the "Advanced" log shows the error message, but not the statement that caused it. his makes it impossible to troubleshoot.

Also, would be nice to have a rollback in case an error does occur.

How to repeat:
Do schema synchronization, watch the SQL Sync Script step

Suggested fix:
Please use code highlighting and fixed width font for code.
[16 Sep 2008 14:40] Roland Bouman 
Also, I think the schema sync script should *not* generate CREATE statements with IF NOT EXISTS clauses; I want the script to fail if someone has added a table between generating the statement and me executing it.
[17 Sep 2008 17:40] MySQL Verification Team 
Thank you for the bug report.
[5 Mar 2009 13:21] Susanne Ebrecht 
This are more feature requests in one report.

We will look what we will implement.
[19 Oct 2009 12:14] Susanne Ebrecht 
Roland,

same here. More then one wish in a single bug report. We will discuss this features and will split them if necessary.
[20 Oct 2009 11:14] Susanne Ebrecht 
Many thanks for writing a feature request.

After long discussion we decided that we won't change this behaviour in foreseeable future.

Thank you for your interests in MySQL Workbench.

P.S.: Some of your wishes are already implemented.