Here are the environmental details:
SQLDeveloper 32-bit Version 3.2.20.09 (Build MAIN-09.87)
Oracle Database: 12C single instance (no RAC)
Oracle client: 12C 32 bit
Windows 64 bit desktop
I am attempting to migrate an MS Access application to Oracle. I pick the ‘Migrate’ selection from the ‘Tools’ Menu SQL Developer. This puts me into the Migration Wizard. When I get to the ‘Source Database’ step of the migration wizard, the ‘Choose the Third Party database from which you are migrating’ drop-down box is not being populated with the current available connections. It is empty. If I type a valid connection name into the box, SQL Developer takes it on this screen but does not keep it for the next screen/step. It has no persistence. I even tried to make sure that each connection was open/connected before beginning the migration process.
Due to the fact that I am attempting to migrate an MSAccess application, I am mixing 32-bit and 64 bit software. This may be the issue as to why the drop down is losing addressability. I have not applied any patches to this version of SQL Developer.
For Access you should make an offline migration.
You need to follow the steps in the SQL*Developer documentation -
Oracle® SQL Developer
User's Guide Release 3.2
in the section -
220.127.116.11 Before Migrating From Microsoft Access
and create the XML file.
Then run the migration wizard but choose 'Offline' in the Source Database step and then the XML file you have created from the Access database.
Alternatively, you could use the 'Copy to Oracle' option by right clicking on Access tables from the Access database in the 'Connections' list.
If you need easy way to migrate Microsoft Access to Oracle probably it is more reasonable to review some tools specially designed to this purpose. For example:
Access to Oracle converter by Intelligent Converters
Access to Oracle converter by SpectralCore
Access to Oracle converter by Interface Computers
Hope, this will help.