Sync data from DB2 to Oracle without programming

by

Want to sync data from DB2 to Oracle ?

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

Download DBCopier Download DBCopier

Synchronize data from DB2 to Oracle

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

Choose source DB2 database and logon.

sync DB2  to Oracle - Choose DB2 and logon

Choose target Oracle database and logon.

sync DB2  to Oracle - Choose Oracle and logon

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

sync from DB2  to Oracle  - Task Window

then show the wizard.

1. Select source DB2 tables to sync.

sync from DB2  to Oracle  - Open source database

2. List target Oracle tables. Set “Import Type” to “Replace”, it will do a full synchronization.

sync data from DB2  to Oracle  - list target tables

3. Select Oracle tables to sync.

sync from DB2  to Oracle  - select tables

4. Sync DB2 data to Oracle.

sync from DB2  to Oracle  - sync

You can schedule and automate this “DB2 to Oracle” 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 Oracle Converter