Step 2: Migrate the Microsoft Access Database to Oracle

Previous
Previous
 
Next
Next

To migrate the Microsoft Access database to Oracle:

  1. Log in to Oracle Migration Workbench 10.1.0.4.0 or higher.

  2. Load the database metadata (.xml file) resulting from Step 1. This migrates the schema and data to Oracle.

    If you are using version 10.1.0.4.0 of Oracle Migration Workbench, make sure that you have updated the /omwb/msaccess_exporter folder with the latest version of the schema.dtd from the zip file in Step 1.


    Important:

    When using the Oracle Migration Workbench, you must verify that the Destination Database in the Migration wizard is the same instance where Application Express 3.0 is installed. If you do not, you are not able to complete the next step.

    For more information about Oracle Migration Workbench, see:

    http://www.oracle.com/technology/tech/migration/index.html