DB2 Import Tools

Withdata FileToDB, Import data from files to DB2

• DB2 import CSV
• DB2 import TSV
• DB2 import TXT
• DB2 import LOG
• DB2 import Excel
• DB2 import JSON
• DB2 import XML
• DB2 import SQL
• DB2 import HTML
• DB2 import RDF
• DB2 import YAML
• DB2 import Fixed-Width Text

Withdata DBCopier, Import data from other databases to DB2

• Import Access data to DB2
• Import DBF data to DB2
• Import dBase data to DB2
• Import xBase data to DB2
• Import FoxBase data to DB2
• Import FoxPro data to DB2
• Import Visual FoxPro data to DB2
• Import HiperSix data to DB2
• Import Clipper data to DB2
• Import MySQL data to DB2
• Import MariaDB data to DB2
• Import Percona data to DB2
• Import Oracle data to DB2
• Import SQLite data to DB2
• Import PostgreSQL data to DB2
• Import RedShift data to DB2
• Import SQL Server data to DB2
• Import Azure data to DB2

Withdata DBBlobEditor, Import data from files to DB2 BLOB/CLOB

• Import data from files to DB2 BLOB
• Import data from files to DB2 CLOB

Withdata MongoToDB, Import data from MongoDB to DB2

• Import MongoDB data to DB2

Frequently asked questions

How do I import DB2 data to another database?

Open the Withdata DB2 import tool, choose the source DB2 database and the target database (Access, DB2, DBF, MySQL, Oracle, SQLite, PostgreSQL, RedShift or SQL Server), map the columns, and run. You can import a whole schema, selected tables, or the result of a custom query.

Can I import only some tables, rows or columns?

Yes. Select individual tables or views, filter rows with a WHERE clause, and map only the columns you need. Upsert and update modes let you refresh existing rows instead of duplicating them.

Does it work on Windows, Mac and Linux?

Yes. Every Withdata DB2 tool ships for Windows (32 and 64 bit), macOS and Linux (.deb and .rpm), with both a GUI and a CLI so you can schedule the import as a recurring task. A free trial is available.