Re: Copy data from DB2 (Linux) to PG - Mailing list pgsql-general

From James A. Robinson
Subject Re: Copy data from DB2 (Linux) to PG
Date
Msg-id CAPd04b6DkxWsz0DFJFVsz7UKTtaj658g_MYeRpvMaMfFvZNQ0Q@mail.gmail.com
Whole thread Raw
In response to Re: Copy data from DB2 (Linux) to PG  (Ravi Krishna <srkrishna1@aol.com>)
List pgsql-general
On Thu, Nov 1, 2018 at 10:50 AM Ravi Krishna <srkrishna1@aol.com> wrote:
> [...] What I need is a constant refresh.
> We plan to use it daily to replicate data from db2 to pg.

Perhaps you've already considered and discarded the idea, but your use
case made me think back to when I was looking at AWS SCT as a way to
migrate ourselves off a legacy DB into MySQL.  It looks as though it
has support for converting from DB2 to Postgres as well, and if I
recall correctly it had facilities for ongoing replication.

https://docs.aws.amazon.com/SchemaConversionTool/latest/userguide/CHAP_Source.DB2LUW.html


pgsql-general by date:

Previous
From: Ravi Krishna
Date:
Subject: Re: Copy data from DB2 (Linux) to PG
Next
From: Ron
Date:
Subject: Truncated queries in the pg_log file