Copy data from DB2 (Linux) to PG

From: Ravi Krishna <srkrishna1(at)aol(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Copy data from DB2 (Linux) to PG
Date: 2018-11-01 17:27:58
Message-ID: 277119983.568633.1541093278753@mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have a project to develop a script/tool to copy data from DB2 to PG. The approach I am thinking is

1. Export data from db2 in a text file, with, say pipe as delimiter.
2. Load the data from the text file to PG using COPY command.

In order to make it faster I can parallelize export and load with upto X number of tables concurrently.

Is there a tool in which I can avoid first exporting and then loading. I think one way I can do it is by
using pipes by which I can export from db2 to a pipe and simultaneously load it to PG using COPY.

Any other tool for this job?

thanks.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message James A. Robinson 2018-11-01 17:36:41 Re: Copy data from DB2 (Linux) to PG
Previous Message GPT 2018-11-01 16:57:48 Re: rw_redis_fdw: SQL Errors when statement is within a function