MySQL and SQL Server Synchronization

MySQL to SQL Server converter implements synchronization as inserting source rows missing in MS SQL table and updating existing rows with MySQL data. For synchronization purpose source and target tables must have identical structures and define primary key or unique index.

Assume both MySQL and SQL Server databases have table "Employees" defined as below:

    Table1(
        ID Integer NOT NULL, 
        FName Varchar(50),
        LName Varchar(50), 
        EMail Varchar(50), 
        Primary Key (ID)
    );

This table has the following contents in MySQL database:

In MS SQL database:

After synchronizing SQL Server database with MySQL data the source table is kept untouched and the destination table is modified as follows (updated cell is marked red):

Have questions? Contact us