Home > Documentation > MS Access to Oracle

Synchronization

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

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

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

This table has the following contents in MS Access database:

In Oracle database:

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

Have questions? Contact us