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

by

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

Using DBCopier, a native GUI tool, you can transfer data from multiple similar PostgreSQL tables to single DB2 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 PostgreSQL tables To same DB2 table

Choose source PostgreSQL database and logon.

convert PostgreSQL  data to DB2 data - Choose PostgreSQL and logon

Choose target DB2 database and logon.

convert PostgreSQL  data to DB2 data - Choose DB2 and logon

Click “Convert Similar Tables” at task dialog.

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

then show the wizard.

1. Select similar tables.

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

2. Select a destination table and config fields.

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

3. Preview data.

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

4. Import.

Import data from multiple similar PostgreSQL  tables to 1 DB2  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 PostgreSQL data to DB2

30-day free trial Download DBCopier