I am using Oracle SQL migration 3.0.04 for migrating MS Access database (2007) to Oracle. I am using the Tools>Migration>Migrate option for this. I have already created a repository and connection to source. I am facing a problem in using the wizard. The Capture window of the wizard is not showing any tables for me select and proceed further. Can anybody tell me if I am missing any steps. Thanks in advance for any help or comment.
If you are using windows, under the Tools > Migration Menu, you should get a set of Access Exporters which you can run against your database. This will generate an xml file which you can load with the wizard to see the structure of the Access database.
If it is just data you need, then you can make an access connection and right click on the table in the access connection and select "Copy to Oracle". This will copy the tables and data to oracle.
I am not using "Copy to Oracle" option since it don't copies everything (constraint, relationships, complete data etc) to oracle (as per oracle documentation). Also I am getting error while using Access exporter (Error # 3270) from Tools>Migration>MS Access Exporter.
Does the Tools>Migration>Migrate option is not meant for MS Access migration?