From:       To:      

Home > Documentation > OraDump to MySQL


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:

        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:

2  Andrew  White
3  Dan  Albright

In MySQL database:

1  John  Smith
2  Andew  White

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

1  John  Smith
2  Andew  White
3  Dan  Albright