Bug #65636 Synchronise with any source
Submitted: 15 Jun 2012 22:39 Modified: 28 Jun 2012 3:01
Reporter: Dalibor Sojic Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Workbench: Modeling Severity:S1 (Critical)
Version:5.2.38, 5.2.40 OS:Any (Mac OS X, Windows XP)
Assigned to: CPU Architecture:Any

[15 Jun 2012 22:39] Dalibor Sojic
Description:
I have two databases:
1. developing database (ex: dev)
2. Real system database (ex: real)

Modeling "dev", synchronizing with "dev" database is OK, but when I have to commit the updates on the "real" database, problem occur.

It drop database and create it again.

How to repeat:
On the server:

1. Create database: "db1"
2. Create few tables
3. Create copy of the "db1" to "db2"

MySQL workbench:
1. Create model from existing database (db1)
2. Perform few changes
3. Synchronize it (this is OK)
4. Try to "synchronize with any source" (db2) - here is the problem
[18 Jun 2012 7:11] Valeriy Kravchuk
I've tried several times with 5.2.40 on Windows XP and in all cases script starts with dropping existing database, db2. This is not any good.
[28 Jun 2012 3:01] Alfredo Kojima
Synchronize with any source is not meant to synchronize with different schemas. Synchronization
always assumes that the target schema has the same name as the original schema.
If you need to synchronize with "real", then you should first rename the dev schema to "real" before doing so. That being said, in versions up to 5.2.40 there was a problem that prevented synchronizing a model after renaming it, that problem will be fixed in an upcoming version.