CODEWITHSUNDEEP
oracle-databasems-access
Arjun Babu
Arjun Babu

Reputation: 219

MS Access to Oracle database

I am developing an ASP.net application with Access database. I need to convert this Access database to Oracle. How can I do that?

I saw two options

  1. Migrating the access database to Oracle through MIGRATION WIZARD in SQL developer
  2. In Oracle, just creating a new connection with existing MS Access database and then converting to oracle.

Kindly let me know the best solution for this

thanks in advance,

Arjun

Upvotes: 0

Views: 671

Answers (3)

kumar chandraketu
kumar chandraketu

Reputation: 2370

Please check the solution at Insert into from ms access to oracle db

You can customize the code based on your requirement. You can bundle the whole code into one class and prepare it as exe application.

Upvotes: 0

b0rg
b0rg

Reputation: 1897

TRY IT and then tell us.

My experience integrating all things oracle with all things microsoft has always been complicated, and a lot of manual intervention was required.

It also depends on the complexity of your existing access database, if it's only one table, then you can grab that table sql, correct it for nvarchar -> varchar2 fields and datapump the data into oracle.

If Access has 1000+ tables I would suggest getting a professional to do it. Any reasonable dba should handle it no problem.

Upvotes: 1

APC
APC

Reputation: 146189

The two choices you proffer could be rewritten like this:

  1. Use an automated tool written by experts
  2. Do it the hard way and figure it out for myself

This is a personal, even philosophical, choice. Do you need to get the task done quickly? Or do you want to learn something along the way?

Upvotes: 3

Related Questions