From:       To:      

Home > Documentation > SQL Server to MySQL

Synchronization

SQL Server to MySQL converter implements synchronization as combination of insert records from source table missing in the destination table and update existing MySQL records with SQL Server data. For synchronization purpose source and destination tables must have identical structures and have primary key or unique index defined.

Assume both MS SQL and MySQL databases have table "People" 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 MS SQL database:

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

In MySQL database:

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

After migrating MS SQL data to MySQL in "Synchronize" mode the source table is kept untouched and the destination table is modified as follows (pay attention to the cell 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