Transfer data from DB2 table to SQL Server without programming

by

Want to transfer data from DB2 table to SQL Server ?

Using Withdata software DBCopier, a DB2 to SQL Server converter, you can transfer data from DB2 table to SQL Server easily and fast.

Download DBCopier Download DBCopier

Transfer data from DB2 table To SQL Server table

Login to DB2 and SQL Server -> Choose source DB2 table -> Set target SQL Server table -> 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 From Table” at task dialog.

Import data from DB2  table to SQL Server  table - Task Window

then show the wizard.

1. Open a source DB2 table.

Convert data from DB2  table to SQL Server  table - Open Source

2. Select a destination SQL Server table and config fields.

Extract DB2  table data to SQL Server  table - select table

3. Preview data.

Migrage data from DB2  table to SQL Server  table - preview

4. Import DB2 data to SQL Server.

Import data from DB2  table to SQL Server  table - import

Transfer data from DB2 table to SQL Server in command line

Save session, and then create .bat file for Windows command line, or .sh file for Linux / macOS.

Set scheduled tasks for transferring data from DB2 table 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.

2) Set scheduled task.


More about DBCopier – DB2 to SQL Server Converter

Download DBCopier for 30-day free trial Download DBCopier