Home > Documentation > MySQL to MS SQL

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:

2  Andrew  White a.white@corporation.com
3  Phil  Johnson p.johnson@gmail.com

In MS SQL database:

1  John  Smith j.smith@msn.com
2  Andew  White a.white@yahoo.com

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):

1  John  Smith j.smith@msn.com
2  Andew  White a.white@corporation.com
3  Phil  Johnson p.johnson@gmail.com

Have any questions? Contact us