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:

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

1  John  Smith j.smith@msn.com
2  Andew  White a.white@corporation.com
3  Phil  Johnson p.johnson@gmail.com