I'm trying to migrate a msAccess database to oracle. First of all, I do not have any MsOffice component in my workstation.
I couldn't even create a Access connection, I could only do that after installing a MS file called AccessDatabaseEngine.
Now, I'm trying to perform the migration process (with wizard), but whenever I reach the Source Database step (I am trying an ONLINE migration), the combobox with the possible sources is empty... and I DO have a MSAccess connection created (and Access does not show listed as a possible data source).
Do I need to install MSAccess to perform the migration?
Windows 7 64b
Thanks for the help
yes, you need to have Access installed on the same machine as SQL*seveloper before you can migrate an Access database to Oracle.
This is outlined in the documentation -
Oracle® SQL Developer
User's Guide Release 3.2
in the section -
18.104.22.168 Before Migrating From Microsoft Access
and there are certain stpes you need to follow before you can migrate the Access database.
According to the supported platform information here -
the only supported versions are -
Microsoft Access 97, 2000, 2002, 2003, 2007
I have not seen anything about support in SQL*Developer v4 but you could download and try that version.