Sync data from DB2 to SQL Server without programming

by

Want to sync data from DB2 to SQL Server ?

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

Download DBCopier Download DBCopier

Synchronize data from DB2 to SQL Server

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

Choose source DB2 database and logon.

sync DB2  to SQL Server - Choose DB2 and logon

Choose target SQL Server database and logon.

sync DB2  to SQL Server - Choose SQL Server and logon

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

sync from DB2  to SQL Server  - Task Window

then show the wizard.

1. Select source DB2 tables to sync.

sync from DB2  to SQL Server  - Open source database

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

sync data from DB2  to SQL Server  - list target tables

3. Select SQL Server tables to sync.

sync from DB2  to SQL Server  - select tables

4. Sync DB2 data to SQL Server.

sync from DB2  to SQL Server  - sync

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