Home > Documentation > MS Access to MySQL

Synchronization

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

Assume both MS Access 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 Access 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 Access 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