MySQL Forums
Forum List  »  Synchronization

Synchronization not working properly
Posted by: Vincenzo Turturro
Date: August 21, 2014 01:15AM

My configuration

Client:
Windows XP SP3
Mysql Workbench 6.1.7.11891 build 1788

Servers:
(Developing & testing)
Windows Server 2008 R2 Core
MySql Server 5.6.19

(Live data hosting)
Windows Storage Server 2012 Standard
MySql Server 5.6.19

In MySQL WB I created a model of the DB I need to manage.

When I use the function "Synchronize with any source" to align the test db to the model, everything works fine.

When I use the same function to align the live db to the model, the target schema is reported as if it's empty (the window "Differences found" reports N/A for each table).

For this reason the synchronization process fails, because the target schema is NOT empty and contains all the tables of the model but the SQL scripts generated for the alignment of each table don't do anything because they begin with "CREATE TABLE IF NOT EXIST".

I created a new schema in the live DB and synchronized it twice with the same model.
The first time (target schema empty) everything worked fine.
The second time it didn't, because the target schema was reported empty and it wasn't.

In all the above tests I checked the message log in the "Retrieve and reverse engineer schema objects" window and it always reported the correct number of objects found in the target database.

Thus it seems as if MySql WB can read the schema of both target dbs but can't manage the check of the db hosted in the Windows 2012 server.

Thanks to anyone who will help.

Options: ReplyQuote


Subject
Views
Written By
Posted
Synchronization not working properly
2239
August 21, 2014 01:15AM


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.