Bug #50251 Synchronize model should auto-expand databases that have table differences
Submitted: 11 Jan 2010 19:52 Modified: 7 Feb 2014 7:53
Reporter: David Peace Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench Severity:S4 (Feature request)
Version:5.2.11 OS:Windows
Assigned to: CPU Architecture:Any
Tags: changes, database, expand, folders, synchronize

[11 Jan 2010 19:52] David Peace
Description:
When running a database model synchronize, it would be nice to automatically expand all databases that have differences.  

Currently, if you have several databases on a server, when you run a synchronize, it would cause you to have to go through each database folder, expand it, and see if it had any changes.

What I would propose is that if there are any differences between the model and the server, it should expand that database folder, and show the tables that have differences without you having to click through the list.

How to repeat:
1) Database -> Synchronize Model.
2) Enter DB server info, click "Next"
3) When Fetch is finished, click "Next"
4) Select the appropriate databases to synchronize, and click "Next"
5) When Retrieval is finished, click "Next"
6) Viewing the "Model and Database Differences" screen, (in my case I have ~30 relevant databases on the server), and I will have to click through and expand each database folder to see if there are any difference.

Suggested fix:
It would be beneficial to either automatically expand all the databases with tables that have differences, OR have a button to expand & show all tables that have differences.

This would allow for easy viewing of differences, and prevent more clicks than necessary.
[11 Jan 2010 19:54] David Peace
Updated to a more accurate bug synopsis.
[7 Feb 2014 7:53] Philip Olson
Fixed as of the upcoming MySQL Workbench 6.1.2 release, and here's the changelog entry:

When executing "Database", "Synchronize Model", the "Model and Database
Differences" step now expands the folder of each database that contains
differences.

Thank you for the bug report.