Transfer data from DB2 query to PostgreSQL table without programming

by

Want to transfer data from DB2 query results to PostgreSQL table?

Using Withdata software DB Copier, a DB2 to PostgreSQL converter for Windows, MacOS, and Linux, you can transfer data from DB2 query result to PostgreSQL table easily and fast.

Download DBCopier Download DBCopier

Transfer data from DB2 query To PostgreSQL table

Login to DB2 and PostgreSQL -> Enter source DB2 query -> Set target PostgreSQL table -> Copy DB2 query data to PostgreSQL table

Choose source DB2 database and logon.

convert DB2  query to PostgreSQL table - Choose DB2 and logon

Choose target PostgreSQL database and logon.

save DB2  query results to PostgreSQL table - Choose PostgreSQL and logon

Click “Convert From Query” at task dialog.

Import data from DB2  query results to PostgreSQL  table - Task Window

then show the wizard.

1. Set a DB2 query.

Convert data from DB2  query results to PostgreSQL  table - open query results

2. Select a destination PostgreSQL table and config fields.

Extract DB2  query results data to PostgreSQL  table - select table

3. Preview data.

Migrage data from DB2  query results to PostgreSQL  table - preview

4. Transfer data from DB2 query result to PostgreSQL table.

save data from DB2  query results to PostgreSQL  table - import

Transfer data from DB2 query to PostgreSQL in command line

Save “DB2 query to PostgreSQL” session, then you can:

Set scheduled tasks for transferring data from DB2 query to PostgreSQL

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

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

2) Set scheduled task.

FAQ


More about DBCopier DB2 to PostgreSQL Converter