Copy data from DB2 (Linux) to PG

Поиск
Список
Период
Сортировка
Искать
От
Ravi Krishna
Тема
Copy data from DB2 (Linux) to PG
Дата
Msg-id
277119983.568633.1541093278753@mail.yahoo.com
Список
Дерево обсуждения
Copy data from DB2 (Linux) to PG Ravi Krishna <srkrishna1@aol.com>
Re: Copy data from DB2 (Linux) to PG Achilleas Mantzios <achill@matrix.gatewaynet.com>
Re: Copy data from DB2 (Linux) to PG Florian Bachmann <fbachmann.public@gmail.com>
Re: Copy data from DB2 (Linux) to PG Ravi Krishna <srkrishna1@aol.com>
Re: Copy data from DB2 (Linux) to PG "James A. Robinson" <jim.robinson@gmail.com>
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.

В списке pgsql-general по дате отправления
От: GPT
Дата:
От: James A. Robinson
Дата:
FAQ