JDatabaseImport

JDatabaseImport is an incredibly helpful software tool designed to import data between various databases with ease. It provides a simple and straightforward interface that allows you to import data effortlessly between multiple databases. This amazing tool can be used in two distinct ways, either through the use of a configuration file or by accessing its API using Java.

Utilizing JDatabaseImport is extremely simple. The software enables you to set up all your preferences using a configuration file, making the process straightforward, efficient and easy to understand. In fact, with just the use of the configuration file, you can easily import data from one database to another.

Looking at an example, consider the file *export.xml*, which contains a simple configuration that tells JDatabaseImport how to import data from one database into another. By setting values for 'from', 'to' and specifying the tables, it’s possible to import data between different databases like hsqldb and MySQL. One thing to keep in mind is that JDatabaseImport does not generate the target tables, but only imports data from one source database into the other.

The code snippet below shows how to use JDatabaseImport to import data from MySQL to hsqldb.

java -cp mysql-connector-3.1.1.jar:hsqldb.jar:jdatabaseimport.jar
br.com.caelum.jdatabaseimport.Main export.xml

This initial release of JDatabaseImport has been tested with hsqldb, MySQL, Derby, and Oracle using some field types and different configurations.

In conclusion, JDatabaseImport is a solid software tool that can help you import data between databases with ease. It simplifies the process significantly, and you can use it to import data from any database to another. If you’re looking for a reliable and straightforward way to import data from one database to another, JDatabaseImport should be your go-to tool.