This discussion is archived
1 Reply Latest reply: Mar 13, 2012 2:50 AM by wkobargs RSS

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

922653 Newbie
Currently Being Moderated
Hi

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

Regards,
Arjun

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

    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.

    Regards
    Wolfgang

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points