MySQL Forums
Forum List  »  Synchronization

Re: Synchronization not working properly
Posted by: Vincenzo Turturro
Date: August 21, 2014 02:22AM

Just updated both servers configuration.
Now they have both MySql Server 5.6.20.
The issue persists.

Vincenzo Turturro Wrote:
-------------------------------------------------------
> 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
Re: Synchronization not working properly
1268
August 21, 2014 02:22AM


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.