Import Access DATA into Oracle 8.x DATABASE

[arehman2]

Hello ALL,

I am migrating my MS-Access 2000 database into Oracle 8.i database. Can my relations in Access will also get created in Oracle as PK,FK,NN, etc constraints.?

Any tools can be helpful.

thanks in advance.

Abdul Rehman
Dubai.

 

[Guest_imported]

oracle migration workbench can be used by setting up oracle odbc datasource.
Everything gets transferred. If something is not, oracle fires a warning that allows you to remedy it.
You can also use erwin to reverse engineer your access database into oracle.
Erwin usually recommends changes to an access schema objects that are not comformance with oracle database including objects that not at least to the 3rd normal form.