reading from ms-access and writing into oracle using java

M

Migrators

Respected sir,

I want a java program which reads data as well as the schema structure
from ms-acess database and migrate the both to Oracle 8i.

Which algorithm should I follow.
 
F

Flip

I want a java program which reads data as well as the schema structure
from ms-acess database and migrate the both to Oracle 8i.

Just off the top of my head, you're going to need to create an ODBC
connenction to your MS-Access db, create an ODBC-JDBC bridge to get access
to your MS-Access db, then use JDBC to pump that data into Oracle. You'll
need to look at JDBC's metadata to interrogate the Access db (hopefully
you'll have that support via the bridge) and then recreate it in Oracle,
then run insert/selects to copy the data over.

Good luck.
 
D

Dave Ockwell-Jenner

Migrators said:
Respected sir,

I want a java program which reads data as well as the schema structure
from ms-acess database and migrate the both to Oracle 8i.

Which algorithm should I follow.

If you are just doing a one-off migration, you could perhaps look into
the Oracle Migration Workbench:-

http://otn.oracle.com/tech/migration/workbench/index.html

The solution will migrate from a variety of source databases to Oracle
and enable you to tweak datatype conversions, etc. I have had great
success with it migrating from MS Access and MySQL to Oracle.
 
M

Mladen Adamovic

I want a java program which reads data as well as the schema structure
from ms-acess database and migrate the both to Oracle 8i.

you have a lot not Java easy solutions to do that task.
 
F

Flip

you have a lot not Java easy solutions to do that task.

Speaking of that, maybe an easier way would be to have Oracle connect to
your Access db via ODBC, OR, another solution would be to have your Access
db create a linked table, and within Access pump all your data over to
Oracle.

As Mladen said there are maybe easier ways outside of java. Are you looking
at reproducing this many times (in production?) or is this a one off thing?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,744
Messages
2,569,484
Members
44,903
Latest member
orderPeak8CBDGummies

Latest Threads

Top