Sync data from Oracle to DB2 without programming

by

Want to sync data from Oracle to DB2 ?

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

Download DBCopier Download DBCopier

Synchronize data from Oracle to DB2

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

Choose source Oracle database and logon.

sync Oracle  to DB2 - Choose Oracle and logon

Choose target DB2 database and logon.

sync Oracle  to DB2 - Choose DB2 and logon

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

sync from Oracle  to DB2  - Task Window

then show the wizard.

1. Select source Oracle tables to sync.

sync from Oracle  to DB2  - Open source database

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

sync data from Oracle  to DB2  - list target tables

3. Select DB2 tables to sync.

sync from Oracle  to DB2  - select tables

4. Sync Oracle data to DB2.

sync from Oracle  to DB2  - sync

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

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

2) Set scheduled task.

FAQ


More about DBCopier Oracle to DB2 Converter