free gui tool to export and import data from and to relational databases

Question

I'm searching free (as in freedom) GUI tools that allow me to export data from one relational database into files (CSV, XML, ...) and to bulk import this data into another database. Both database might be from different vendors.

I'm already aware of tools that migrate schemas, like liquibase and not searching for that.

Extra plus points if such a tool

• is written in Java and uses JDBC drivers
• is an eclipse plugin (because our other tools are also eclipse based)
• allows all kinds of filtering and modification of the data during import or export
• can handle large (as in giga- or terabytes) data sets
• can be scheduled
• can continue an interrupted import/export

Similar questions:

• Export large amounts of binary data from one SQL database and import it into another database of the same schema

It seems that the WBExport and WBImport commands of SQLWorkbench are very good candidates. I also need to look whether ETL Tools like Pentaho ETL do this stuff.

Answer 1

CloverETL meets nearly all your requirements. With free version you can work with following databases: MySQL, PostgreSQL, SQLite, MS SQL, Sybase, Oracle, and Derby.