Sync data from DB2 to PostgreSQL without programming

by

Want to sync data from DB2 to PostgreSQL ?

Using Withdata software DB Copier, a DB2 to PostgreSQL sync tool for Windows, MacOS, and Linux, you can synchronize data from DB2 to PostgreSQL easily and fast.

Download 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  - list target tables

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

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

1) Save session and create .bat (Windows) or .sh (Linux/macOS) file.

2) Set scheduled task.

FAQ


More about DBCopier DB2 to PostgreSQL Converter