On Thu, Nov 1, 2018 at 10:28 AM Ravi Krishna <srkrishna1@xxxxxxx> 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?
