Search Postgresql Archives

Re: Move data from DB2 to Postgres any software/solutions/approach?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxx> 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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux