Sync data from DB2 to SQL Server

by

Posted on by

Want to sync data from DB2 to SQL Server ?

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

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

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

sync data from DB2 to SQL Server - upsert synchronization

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

Synchronize data from DB2 to SQL Server in command line

Save “DB2 to SQL Server” session, then you can:

Set scheduled tasks for synchronizing data from DB2 to SQL Server

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 for “Sync DB2 to SQL Server” conversion.
  2. Set scheduled task for “Sync DB2 to SQL Server” conversion.

FAQ

More about Withdata DBCopier – DB2 to SQL Server Converter

See also: