Batch copy data from one DB2 tables to another DB2 without programming

by

Posted on by

Want to batch copy data from one DB2 tables to another DB2?

Using Withdata software DBCopier, a DB2 data transfer, you can copy data from one DB2 tables to another DB2 in a batch, easily and fast.

  • Can run in GUI mode, Step by Step, just a few mouse clicks.
  • Can run in Command line, for Scheduled Tasks and Streams.
  • Supports Windows 10, 11, 2003, 2008, 2012, 2016, 2019, 2022.

Download DBCopier Download DBCopier

Batch copy tables data from one DB2 database to another

Login to source and target DB2 -> Select DB2 tables to copy -> Copy data between DB2 databases

Choose source/target DB2 database and logon.

copy data between DB2 databases - Choose DB2 and logon

Click “Convert All Tables” at task dialog.

Batch copy data from one DB2 tables to another DB2 - Task Window

then show the wizard.

1. Select source DB2 tables.

Batch copy tables data from one DB2 to another - select tables

2. List target DB2 tables.

Batch convert data from one DB2 tables to another DB2 - select destination schema

3. Select target DB2 tables to copy data.

Batch import data from one DB2 tables to another DB2 - select tables

4. Copy data between DB2.

Batch transfer data from one DB2 tables to another DB2 - import

You can schedule and automate this “DB2 Copy” conversion task by:

1) Save session and create .bat (Windows) or .sh (Linux/macOS) file.

2) Set scheduled task.

More about DBCopier – DB2 Copier

Download DBCopier for 30-day free trial Download DBCopier