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:

In MySQL database:

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

Have any questions? Contact us