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 DB Copier, a DB2 data transfer for Windows, MacOS, and Linux, you can copy data from one DB2 tables to another DB2 in a batch, easily and fast.

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

Copy DB2 tables in command line

Save “Copy DB2 tables” session, then you can:

Set scheduled tasks for coping DB2 tables

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.

FAQ

More about DBCopier – DB2 Copier