Batch copy DB2 tables to PostgreSQL

by

Want to batch copy data from DB2 tables to PostgreSQL ?

Try Withdata DBCopier, a DB2 to PostgreSQL converter for Windows, Mac, and Linux, Bulk copy DB2 to PostgreSQL, Easy and Fast.

Download Withdata DBCopier Download DBCopier

Batch copy data from DB2 tables to PostgreSQL tables

Login to DB2 and PostgreSQL -> Select source DB2 tables -> Set target PostgreSQL tables -> Copy DB2 data to PostgreSQL

Choose source DB2 database and logon.

convert DB2 data to PostgreSQL data - Choose DB2 and logon

Choose target PostgreSQL database and logon.

convert DB2 data to PostgreSQL data - Choose PostgreSQL and logon

Click “Convert All Tables” at task dialog.

Batch import data from DB2 tables to PostgreSQL tables - Task Window

then show the wizard.

1. Select source DB2 tables.

Batch convert data from DB2 tables to PostgreSQL tables - Open Source schema

2. List target PostgreSQL tables.

Batch extract data from DB2 tables to PostgreSQL tables - select destination schema

3. Select PostgreSQL tables to import.

Batch import data from DB2 tables to PostgreSQL tables - select tables

4. Transfer data from DB2 tables to PostgreSQL.

Batch copy data from DB2 tables to PostgreSQL tables - batch import

Batch transfer data from DB2 tables to PostgreSQL in command line

Save “DB2 tables to PostgreSQL” session, then you can:

Set scheduled tasks for coping data from DB2 tables to PostgreSQL

You can schedule and automate this “DB2 to PostgreSQL” conversion task by:

  1. Save session and create .bat (Windows) or .sh (Linux/macOS) file for “DB2 to PostgreSQL” conversion.
  2. Set scheduled task for “DB2 to PostgreSQL” conversion.

FAQ


More about Withdata DBCopier DB2 to PostgreSQL Converter

See also: