From:       To:      

Home > Documentation > MS Access to Oracle


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:

	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:

2  Andrew  White
3  Phil  Johnson

In Oracle database:

1  John  Smith
2  Andew  White

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

1  John  Smith
2  Andew  White
3  Phil  Johnson

Have questions? Contact us