Re: Move data from DB2 to Postgres any software/solutions/approach? - Mailing list pgsql-general

From John R Pierce
Subject Re: Move data from DB2 to Postgres any software/solutions/approach?
Date
Msg-id 4C0974D9.10705@hogranch.com
Whole thread Raw
In response to Re: Move data from DB2 to Postgres any software/solutions/approach?  (DM <dm.aeqa@gmail.com>)
Responses Re: Move data from DB2 to Postgres any software/solutions/approach?
List pgsql-general
DM wrote:
> Sorry i didnt frame my question properly earlier, we are looking for
> solution to do real time replication from db2 to postgres, its
> different from migration.
> Eventually we want to move away from DB2. Intention is to create a
> subset of a db2 database on postgres and allow users to access the
> postgres database.

*real* realtime, as in transaction by transaction?  or sorta-realtime,
as in updates every X interval where X is a minute or few?

wild guess says, you'll need to roll that yourself, probably on the DB2
side using triggers, and I have no idea how you'd connect to PG from the
DB2 procedures (as I know very little about DB2 specifically)



pgsql-general by date:

Previous
From: David Fetter
Date:
Subject: Re: Move data from DB2 to Postgres any software/solutions/approach?
Next
From: DM
Date:
Subject: Re: Move data from DB2 to Postgres any software/solutions/approach?