Sync data from DB2 to Oracle

by

Want to sync data from DB2 to Oracle ?

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

Download Withdata 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 - full synchronization

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

sync data from DB2 to Oracle - upsert synchronization

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


More about DB2 to Oracle converter

See also: