Home > Documentation > OraDump to MySQL

Synchronization

OraDump 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 Dump file and MySQL databases have table "People" defined as below:

    Table1(
        ID Integer NOT NULL, 
        FirstName Varchar2(50),
        LastName Varchar2(50), 
        EMail Varchar2(50), 
        Primary Key (ID)
    );

This table has the following contents in Oracle dump file:

In MySQL database:

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