Home > Documentation > Oracle to MySQL

Synchronization

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

Assume both Oracle and MySQL databases have table "People" defined as below:

    Table1(
        ID Integer NOT NULL, 
        FName Varchar2(50),
        LName Varchar2(50), 
        EMail Varchar2(50), 
        Primary Key (ID)
    );

This table has the following contents in Oracle database:

In MySQL database:

After migrating Oracle data to MySQL in "Synchronize" mode Oracle table is kept untouched and MySQL table is modified as (pay attention to the cell marked red):