1 Reply Latest reply on Mar 13, 2012 9:50 AM by wkobargs-Oracle

    Migration from Access to Oracle 10g (Problem with migration wizard)


      I have an access database which I want to migrate to Oracle DB.

      I have created 2 connections.

      1. Access connection with the source database
      2. Oracle connection.

      I have associated the oracle connection to the repository.

      When I go through 'MIGRATION WIZARD' process. I am not able to view the source database file while capturing. Tried it several times.

      Need a help in this


      Edited by: 919650 on Mar 9, 2012 2:47 AM
        • 1. Re: Migration from Access to Oracle 10g (Problem with migration wizard)

          you cannot do an online migration with MS Access as you can do with other foreign datasources. You can only do an offline migration.

          The first step that you need to do is to call the Microsoft Access Exporter. Click on Tools - Migration - Microsoft Access Exporter and chose the exporter of the MS Access version that you are using.

          The exporter creates an xml file for you. After the exporter has finished you can do the migration, click on Tools - Migration - Migrate, but in Step 4 please select "Offline", and then you can select the xml file that the exporter has created. The following steps in the Migration assistant are then doing the migration for you.

          You might also want to read the chapter "Before Migrating From Microsoft Access" in the online help of SQL Developer.