Sync data from SQL Server to DB2

by

Want to sync data from SQL Server to DB2 ?

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

Download Withdata DBCopier Download DBCopier

Synchronize data from SQL Server to DB2

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

Choose source SQL Server database and logon.

sync SQL Server to DB2 - Choose SQL Server and logon

Choose target DB2 database and logon.

sync SQL Server to DB2 - Choose DB2 and logon

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

sync from SQL Server to DB2 - Task Window

then show the wizard.

1. Select source SQL Server tables to sync.

sync from SQL Server to DB2 - Open source database

2. List target DB2 tables.

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

sync data from SQL Server to DB2 - full synchronization

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

sync data from SQL Server to DB2 - upsert synchronization

3. Select DB2 tables to sync.

sync from SQL Server to DB2 - select tables

4. Sync SQL Server data to DB2.

sync from SQL Server to DB2 - sync


More about SQL Server to DB2 converter

See also: