Step 2: Migrate the Microsoft Access Database to Oracle

To migrate the Microsoft Access database to Oracle:

1. Start Oracle SQL Developer version 1.2.0 or later. For example:

   1. Create an Oracle user named MIGRATIONS with the default tablespace USER and temporary tablespace TEMP and grant it at least RESOURCE, CREATE SESSION, and CREATE VIEW privileges.

   2. Create a database connection named Migration_Repository that connects to the MIGRATIONS user.

   3. Right-click the connection, select Migration_Repository, and then select Migration Repository and then Associate Migration Repository to create the repository.

2. Load the database metadata (.xml file) created in step 1. Select Migration and then Capture Microsoft Access Exported XML.

   This captures the schema and creates a Captured Model of the Microsoft Access database.

3. Convert the captured database schema to Oracle. Right-click Captured Model and select Convert to Oracle Model.

4. Generate the migrated Oracle database schema. Right-click Converted Model and select Generate.

   The generated DDL statements should execute against your Oracle database instance, to generate the migrated schema objects.

For more information about Oracle SQL Developer Migration Workbench, see:

http://www.oracle.com/technology/tech/migration//workbench/index_sqldev_omwb.html