-1

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:

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.

Community
  • 1
  • 1
Thomas Koch
  • 2,833
  • 2
  • 28
  • 36
  • Hate to say it, but one of the main close reasons is "Questions asking us to recommend a tool, library or favorite off-site resource are off-topic for Stack Overflow as they tend to attract opinionated answers and spam." – LittleBobbyTables - Au Revoir Jul 12 '13 at 15:00
  • Whether the question is closed or not, I can tell you that I would be taking a hard look at Pentaho Data Integration. – Brian.D.Myers Jul 12 '13 at 19:19

1 Answers1

0

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

agad
  • 2,192
  • 1
  • 20
  • 32