Batch copy SQL Server tables to DB2

by

Posted on by

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

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

Download Withdata DBCopier Download DBCopier

Batch copy data from SQL Server tables to DB2 tables

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

Choose source SQL Server database and logon.

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

Choose target DB2 database and logon.

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

Click “Convert All Tables” at task dialog.

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

then show the wizard.

1. Select source SQL Server tables.

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

2. List target DB2 tables.

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

3. Select DB2 tables to import.

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

4. Transfer data from SQL Server tables to DB2.

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

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

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

Set scheduled tasks for coping data from SQL Server tables to DB2

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

  1. Save session and create .bat (Windows) or .sh (Linux/macOS) file for “SQL Server to DB2” conversion.
  2. Set scheduled task for “SQL Server to DB2” conversion.

FAQ

More about Withdata DBCopier – SQL Server to DB2 Converter

See also: