CODEWITHSUNDEEP
javaoracle-databasems-accessjdbcdata-migration
Java_nuB
Java_nuB

Reputation: 39

What would be the best method to migrate Oracle database to MS Access using Java?

This might be a very basic question, but I could use some help with this from the experts here at StackOverflow.

I am just brainstorming and weighing all the options available. So, I do not need help with the code, please. But, some suggestions or ideas would help.

Here's what I thought might work:

  1. Making a d/b connection to Oracle using JDBC
  2. Running SQL statements to fetch data from Oracle
  3. Storing the data obtained in a data-structure
  4. Making a d/b connection to MS Access using the JDBC-ODBC bridge driver
  5. Creating a new d/b in Access and inseting into it using SQL
  6. Closing the connections

Is there an easier or more efficient way to do this?

Another thing, this process needs to be done for several clients and each table in a d/b has millions of records. Doing this process manually would take a lot of time and so it's not such a feasible option.

OK, I hate to make this complicated. But, after importing data from Oracle, we are manipulating the data using Java code. So, after the data-transformation, we then want to migrate it to MS Access and send it to the client's way.

I really appreciate your time and help.

Upvotes: 1

Views: 3437

Answers (1)

Johan Sjöberg
Johan Sjöberg

Reputation: 49187

I don't see why writing a java-program for this would be easier than doing it manually.

I would dump the oracle tables to disk, them import them to MS Access. Perhaps MS Access own import feature (File -> Get external data) might be useful for an ODBC import.

You could even try one of the (although non-free) tools 1,2 which claims to do this for you.

Upvotes: 4

Related Questions