Preparation Checklist for Migrating Applications

Previous

Next

Before you begin the migration process, verify that your system meets these requirements:

• Oracle Application Express version 3.0

  You must have installed Application Express 3.0. You use the Application Migration feature within Application Express to download the Exporter tool as well as to migrate Microsoft Access forms and reports to Application Express.

• Oracle Migration Workbench version 10.1.0.4.0 or higher (available in English only)

  You must have installed Oracle Migration Workbench version 10.1.0.4.0 or higher. You use the Migration Workbench to migrate the Microsoft Access schema and data to Oracle.

• Exporter tool version 10.2.0.2.0 (available in English only)

  If you are using Oracle Migration Workbench version 10.1.0.4.0, you must install the Exporter tool using the Download Exporter link within Application Express. For instructions, see "Step 1: Export Microsoft Access Metadata".

  If you are using a version higher than 10.1.0.4.0, you can access the Exporter directly from Oracle Migration Workbench.

• Microsoft Access

  Your local machine must have Microsoft Access installed, and it must be installed where the Exporter tool and .mdb file reside.

• Microsoft Data Access Components (MDAC)

  Your local machine should have the latest version of Microsoft Data Access Components (MDAC) installed. You can download the latest version from the Microsoft Web site.

• Printer

  Your local machine must have a printer installed so that a report can be opened in design view. This is a requirement for exporting your Reports information from an .mdb file.

• Analyze your .mdb file before you export your database. Follow the instructions in the next section.

Analyze Your .MDB File in Microsoft Access

Using Microsoft Access, you should analyze your .mdb file before you export your database. Performing these steps will minimize errors in the migration.

1. In Microsoft Access, analyze the objects in your .mdb file:

   1. From the Microsoft Access menu bar, select Tools, Analyze, and then Documenter.

   2. Select the All Object Types tab, and then click the Select All button to select all the objects within the application for analysis.

   3. Remove or resolve any erroneous objects reported by the Documenter.

2. Ensure the application contains no missing references:

   1. In Microsoft Access, launch the design IDE (press Alt+F11 keys).

   2. From the menu bar, select Tools and then References.

   3. Remove or resolve any missing references.

3. Ensure the application compiles successfully:

   1. From the menu bar in the IDE view, select Debug and then Compile.

   2. Resolve any reported errors.

4. Perform a compact and repair on the database:

   • From the menu bar in Microsoft Access, select Tools, Database Utilities, and then Compact and Repair Database.

5. Ensure that all linked tables are valid links:

   1. From the menu bar in Microsoft Access, select Tools, Database Utilities, and then Linked Table Manager.

   2. Verify that all links are up-to-date and pointing to an existing .mdb file that is not read-only.