Transfer data from multiple similar DB2 tables to same Oracle table without programming

by

Posted on by

Want to transfer data from multiple similar DB2 tables to 1 Oracle table?

Using DBCopier, a native GUI tool, you can transfer data from multiple similar DB2 tables to single Oracle table easily and fast, just a few mouse clicks.

Supports Windows XP, 7, 8, 10, 11, 2003, 2008, 2012

Here you can download and install DBCopier.

Transfer data from multiple similar DB2 tables To same Oracle table

Choose source DB2 database and logon.

convert DB2 data to Oracle data - Choose DB2 and logon

Choose target Oracle database and logon.

convert DB2 data to Oracle data - Choose Oracle and logon

Click “Convert Similar Tables” at task dialog.

Import data from multiple similar DB2 tables to 1 Oracle table - Task Window

then show the wizard.

1. Select similar tables.

Convert data from multiple similar DB2 tables to 1 Oracle table - open query results

2. Select a destination table and config fields.

Extract multiple similar DB2 tables data to 1 Oracle table - select table

3. Preview data.

Migrage data from multiple similar DB2 tables to 1 Oracle table - preview

4. Import.

Import data from multiple similar DB2 tables to 1 Oracle table - import

You can schedule and automate this converting task by:

1) Save session and create .bat file.

2) Set scheduled task.

More about DBCopier – the tool to copy DB2 data to Oracle

30-day free trial Download DBCopier