Batch copy DB2 tables to SQL Server

by

Want to batch copy data from DB2 tables to SQL Server ?

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

Download Withdata DBCopier Download DBCopier

Batch copy data from DB2 tables to SQL Server tables

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

Choose source DB2 database and logon.

convert DB2 data to SQL Server data - Choose DB2 and logon

Choose target SQL Server database and logon.

convert DB2 data to SQL Server data - Choose SQL Server and logon

Click “Convert All Tables” at task dialog.

Batch import data from DB2 tables to SQL Server tables - Task Window

then show the wizard.

1. Select source DB2 tables.

Batch convert data from DB2 tables to SQL Server tables - Open Source schema

2. List target SQL Server tables.

Batch extract data from DB2 tables to SQL Server tables - select destination schema

3. Select SQL Server tables to import.

Batch import data from DB2 tables to SQL Server tables - select tables

4. Transfer data from DB2 tables to SQL Server.

Batch copy data from DB2 tables to SQL Server tables - batch import

Batch transfer data from DB2 tables to SQL Server in command line

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

Set scheduled tasks for coping data from DB2 tables 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 “DB2 to SQL Server” conversion.
  2. Set scheduled task for “DB2 to SQL Server” conversion.

FAQ


More about Withdata DBCopier DB2 to SQL Server Converter

See also: