2 Replies Latest reply: Apr 11, 2014 1:32 AM by 4b4aff1f-cc1c-475b-b9ea-8021fb57770d RSS

    Migrating MS Access to Oracle 11gR2

    Herta

      Environment 1:

      Windows 7 (64-bit), Microsoft Access 2003 (32-bit), Oracle SQL Developer 4.0.0

      Environment 2:

      Windows XP (32-bit), Microsoft Access 2003 (32-bit), Oracle SQL Developer 4.0.0

       

      Has anyone succeeded in migrating an MS Access database to Oracle 11gR2?

       

      In environment 1, I cannot add a connection to the MS Access database.  And, yes, I tried odbcad32.exe from both %windows%\System32 and %windows%\SysWOW64.

       

      In environment 2, I can connect to the MS Access database. 

       

      I tried to follow "Migrating a Microsoft Access Database to Oracle Database 11g" (http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/sqldev/r30/MSAccessMigration/MSAccessMigration.htm), but in the section on "Capturing the Microsoft Access Exported Files", it happily states: "The procedure for creating the Microsoft Access database scripts has been completed for you and the files are available in the zip file provided in the prerequisites." and I cannot find a reference to how those scripts were created, so I'm stuck there.

       

      The Quick Video entitled "Migrating from Microsoft Access to Oracle" (http://www.oracle.com/technetwork/database/migration/access-084991.html) captures a Sybase database instead, so no luck there either.

       

      Section "2.2.4.3.1  Creating Microsoft Access XML Files" of the "Oracle® SQL Developer User's Guide" states:

      "To prepare for capturing a Microsoft Access database, the Exporter for Microsoft Access tool must be run, either automatically or manually, as explained in Section 2.2.5, "Capturing the Source Database". This tool is packaged as a Microsoft Access MDE file and it allows you to export the Microsoft Access MDB file to an XML file."  But there's nothing whatsoever relevant to this issue in section 2.2.5.  Nor in the "Oracle® SQL Developer Supplementary Information for Microsoft Access Migrations".

      I tried Tools -> Migration -> Create Database Capture Scripts... but there's no MS Access to select. 

      I tried Tools -> Database Export... but cannot connect to the MS Access database.

      Stuck again.

       

      I tried right-clicking on the MS Access db and selecting the "Copy To Oracle..." option, but nothing happens.

       

      I tried using Tools -> Migration -> Migrate

      but at the capture stage, I get an error "java.lang. Exception:  The plugin used to capture this model is not available.  Please re-install the plugin and try again before convert."  But I cannot find a reference to a plug-in for MS Access.

       

      I tried Tools -> Database Copy... but cannot select the MS Access database as source.

       

      I found ckw460's entry in this forum at https://community.oracle.com/thread/2593134 and found "Oracle Application Express 4.2" at http://www.oracle.com/technetwork/developer-tools/apex/downloads/index.html and in the zip the omwb2007.zip (s)he mentioned.  I assume I'd have to use omwb2003.zip, but it is unclear to me how to apply it.

       

      I.e., lots of frustrations and after well over a day, I'm still nowhere.

       

      Can anyone assist?

       

      Kind regards,

       

      Herta