Thank you so much for every ones inputs.
It is not real time, updates every 5 mins should be fine.
But the DB2 database is real busy and its real performance based.
Thanks
Deepak
On Fri, Jun 4, 2010 at 2:49 PM, John R Pierce
<pierce@hogranch.com> wrote:
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.
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)