MySQL Forums
Forum List  »  MySQL Workbench

Synchronization Fails to Properly Support Comments
Posted by: Jason Franklin
Date: May 01, 2017 06:27AM

I'm very impressed with the possibility offered by the Workbench
synchronization tool. From what I can tell, any of three representations of a
database (live db, model, or create script) can be synchronized with any of the
others. However, when the purpose of synchronization is to port comments to a
DB, the tool fails in some cases.

My Problem:

I'm trying to synchronize from a model to a create script for the purpose of
moving comments to a live DB that was used to generate the create script. The
synchronization tool will automatically truncate comments in this scenario
(current versions of MySQL support 1K comments on columns and 2K comments on

Note that this problem only seems to occur when generating an alter script for
synchronizing from a model to a create script. Synchronizing from a model directly
to a live database doesn't cause this problem (comments are left untouched).

Suggested Solution:

An option (with a checkbox) should be made available for indicating whether
comments should be truncated or not.

Options: ReplyQuote

Written By
Synchronization Fails to Properly Support Comments
May 01, 2017 06:27AM

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.