Sync data from DB2 to PostgreSQL

by

Want to sync data from DB2 to PostgreSQL ?

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

Download Withdata DBCopier Download DBCopier

Synchronize data from DB2 to PostgreSQL

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

Choose source DB2 database and logon.

sync DB2 to PostgreSQL - Choose DB2 and logon

Choose target PostgreSQL database and logon.

sync DB2 to PostgreSQL - Choose PostgreSQL and logon

Click “Wizard – Import All Tables” at task dialog.

sync from DB2 to PostgreSQL - Task Window

then show the wizard.

1. Select source DB2 tables to sync.

sync from DB2 to PostgreSQL - Open source database

2. List target PostgreSQL tables.

Set “Import Type” to “Replace”, it will do a full synchronization.

sync data from DB2 to PostgreSQL - full synchronization

Or set “Import Type” to “Upsert”, it will do a upsert synchronization.

sync data from DB2 to PostgreSQL - upsert synchronization

3. Select PostgreSQL tables to sync.

sync from DB2 to PostgreSQL - select tables

4. Sync DB2 data to PostgreSQL.

sync from DB2 to PostgreSQL - sync

Synchronize data from DB2 to PostgreSQL in command line

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

Set scheduled tasks for synchronizing data from DB2 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 “Sync DB2 to PostgreSQL” conversion.
  2. Set scheduled task for “Sync DB2 to PostgreSQL” conversion.

FAQ


More about Withdata DBCopier DB2 to PostgreSQL Converter

See also: