migrate an access database to oracle

[Sujit15]

Please let me know if it is possible to migrate a database from Microsoft Access to Oracle?

if so how do I proceed please?

[Lemog]

Yes it is possible. A migration from Microsoft Access to Oracle can involve the migration of the database only or the migration of the database and the front-end application, that is, the Forms and Reports.

[Sujit15]

Is there any tools available for the migration of the database to Oracle?

[Lemog]

When migrating the database only, you should use the Oracle Migration Workbench. The Migration Workbench includes two wizards that guide you through the database migration in a step-by-step manner.

[Sujit15]

Can I migrate the entire database using the Oracle Migration Workbench? What all versions of Microsoft Access are supported by it?

[Lemog]

Yes, you can perform the migration of the entire Microsoft Access database using the Migration Workbench. It supports the migration of the data, tables, indexes, validation rules, relations and link tables from Microsoft Access to Oracle.

The Oracle Migration Workbench can migrate Microsoft Access 2.0, 95, 97 and 2000 databases to either Oracle8i (8.1.7 upwards), Oracle9i or Oracle10g