| From: | "James A(dot) Robinson" <jim(dot)robinson(at)gmail(dot)com> |
|---|---|
| To: | srkrishna1(at)aol(dot)com |
| Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Copy data from DB2 (Linux) to PG |
| Date: | 2018-11-01 17:36:41 |
| Message-ID: | CAPd04b4Zd=YRuZg1giqMzj=gzVWz1jNeBzqc_n0C=+UYQjyK3w@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Nov 1, 2018 at 10:28 AM Ravi Krishna <srkrishna1(at)aol(dot)com> wrote:
>
> 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.
I've never used it, but there is this in case it's helpful:
https://github.com/dalibo/db2topg/
> 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?
Is the DB2 side static or being actively updated?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ravi Krishna | 2018-11-01 17:49:57 | Re: Copy data from DB2 (Linux) to PG |
| Previous Message | Ravi Krishna | 2018-11-01 17:27:58 | Copy data from DB2 (Linux) to PG |