Home > Documentation > SQLite to MySQL

Synchronization in SQLite to MySQL Converter

SQLite to MySQL converter implements synchronization as combination of inserting SQLite rows that are not exist in the target table and update of existing MySQL records with the source data. For synchronization purpose source and destination tables must have equal structures and have primary key or unique index defined.

Assume both SQLite and MySQL databases have table "employees" defined as below:

    Table1(
        empno Integer NOT NULL, 
        first_name Varchar(20),
        last_name Varchar(20), 
        email Varchar(50), 
        Primary Key (empno)
    );

This table has the following contents in SQLite database:

In MySQL database:

After migrating SQLite 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