1 person found this helpful
Follow the steps by steps from Oracle. http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/hol08/sqldev_migration/msaccess/migrate_microsoft_access_otn.htm
This tutorial shows you how to migrate a Microsoft Access database to Oracle Database 11g using Oracle SQL Developer. Article is here.
Thanks for your prompt reply.
But the steps shown where not with Sql developer version 4.15
I doubt that the version matters. You're migrating data from one platform to the next. What matters is that you're about to migrate your data successfully. If the version matters, I'm sure that Oracle would have included the version number if it's a critical requirement (My own assumption!) it in the migration. Check this link to see a video step by step of how to accomplish what you're looking to do - from the same article.
Microsoft Access Migration Overview
Using Oracle SQL Developer Migration Workbench, you can quickly migrate your Microsoft Access database to Oracle.
There are four main steps in the database migration process:
Capture the Source Database
- Online Capture: This requires creating a connection in SQL Developer to a Microsoft Access database. Using JDBC, the Microsoft Access database metadata can be accessed and the Capture Model created.
- Offline Capture: This involves using the Exporter to extract the metadata out of the Microsoft Access database to files. These files can then be "captured" by SQL Developer.
Convert the Captured Database Oracle SQL Developer Migration Workbench uses the Captured Model to convert the captured objects to Oracle-format objects, building up a representation of the structure of the destination database. This structure is called the Converted Model. Generate the Oracle Database Oracle SQL Developer Migration Workbench generates DDL statements to create the new Oracle database, based upon the Converted Model objects. Running the DDL statements will result in the creation of the objects in the Oracle database. Migrate the Data The last step in the process is to migrate the data. You can do this in one of two ways.
- Online Data Move: You can create a connection from within Oracle SQL Developer to your Microsoft Access source database and migrate the data.
- Offline Data Move: You can export the data from Microsoft Access using the Exporter. SQL Developer will create a series of sqlldr files that you can run from a batch file to load the data into Oracle.
The second method is what you will perform in this tutorial.
As per the tutorial video the migration menu is specifically available on the top and in sql developer 4.15 it is in connection window.
While choosing the file it is asking for JDBC drivers for ms access.
Due to the above I am not to migrate the database.
I see. What error did you get regarding JDBC driver?
Java 8 (required by the SQL Developer 4.1.x & up releases) no longer includes ODBC bridge support. The last release supporting MSAccess connections is 4.0.3 with JDK 7.
Possibly an off-line capture and migration is possible with 4.1.5, but not really sure.
The off-line capture is not working.
If that is the case, then I suppose the only solution is to go with 4.0.3 and the most recent Java 7 JDK. In the link I provided in my prior post, you can find this comment...
Since it is quite possible and simple to install multiple versions of SQL Developer and Java JDKs...
so you should have no problem doing a migration and then removing 4.0.3 if desired. Here is that download page: