Java library to export database from any DBMS to any DBMS

Question

Is there a java library that be able to export databases from any DBMS (Mysql,SQLServer,Oracle,SQLite,...) to any DBMS?

sethu · Accepted Answer · 2011-10-17 16:21:46Z

2

Thats not easy.. but you could try using apache torque, it will convert your source schema into an intermediate XML. You can then use the XML to generate your schema in the target database. After which you can call on ant targets to export the data into XML from the source database. Then call another ant target to populate the data from the data XML.

I have used this to migrate data from mysql to oracle express to db2. It worked fine for me. In fact it worked better that the oracle provided tools for migration.

Here's a link:

http://db.apache.org/torque/releases/torque-3.3/generator/tasks-reference.html

answered Oct 17, 2011 at 16:21

sethu

8,4717 gold badges44 silver badges67 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Java library to export database from any DBMS to any DBMS

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related