Batch copy MySQL tables to DB2

by

Posted on by

Want to batch copy data from MySQL tables to DB2 ?

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

Download Withdata DBCopier Download DBCopier

Batch copy data from MySQL tables to DB2 tables

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

Choose source MySQL database and logon.

convert MySQL data to DB2 data - Choose MySQL and logon

Choose target DB2 database and logon.

convert MySQL data to DB2 data - Choose DB2 and logon

Click “Convert All Tables” at task dialog.

Batch import data from MySQL tables to DB2 tables - Task Window

then show the wizard.

1. Select source MySQL tables.

Batch convert data from MySQL tables to DB2 tables - Open Source schema

2. List target DB2 tables.

Batch extract data from MySQL tables to DB2 tables - select destination schema

3. Select DB2 tables to import.

Batch import data from MySQL tables to DB2 tables - select tables

4. Transfer data from MySQL tables to DB2.

Batch copy data from MySQL tables to DB2 tables - batch import

Batch transfer data from MySQL tables to DB2 in command line

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

Set scheduled tasks for coping data from MySQL tables to DB2

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

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

FAQ

More about Withdata DBCopier – MySQL to DB2 Converter

See also: