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 <pie...@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. >> > > *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) > > > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
