Access Database Migration to Oracle Database

[newbieDev]

Hi Everyone,

I have some data migration questions.

I have been tasked with migrating an Access database to an Oracle database. The Oracle database structure is different from the Access database as I now how more tables, and existing tables were somewhat modified to have more or less fields. My largest table has about 2000 records.

How do I migrate the Access Database Data to the Oracle Database, and maintain the relationships that existed in the Access Database? - I am thinking of retaining all IDs in the Access Database (use a sequence to generate new ones) but I feel there might be away to use new IDs and still maintain the relationships.

I plan to use SQL loader to migrate the data - I have basically created separate control and data files for all the tables.

I will greatly appreciate any recommendation on this.

Thanks in advance!

 

[dbtoo2001]

http://www.oracle.com/technology/tech/migration/focusareas/access.html

 

[Thargy]

newbie,

also note that Application Express has an Access migration utility, so check that out as well as dbtoo's link.

Regards

Tharg

Grinding away at things Oracular