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

dm(dot)aeqa(at)gmail(dot)com (DM) writes:
> It is not real time, updates every 5 mins should be fine. 
>
> But the DB2 database is real busy and its real performance based. 

The book "Scalable Internet Architectures" (by Theo Schlossnagle) has
an example of how to build a trigger-based replication system copying
data from an Oracle database to Postgres.

It basically tracks PK values for tuples changed/deleted (which is
what the old RServer and eRServer replication systems for Postgres
did), allowing a process to come in afterwards and pull data over to
the replica.

I presume that DB2 has enough functionality to let you run triggers to
capture which tuples changed, and when. Given that, it shouldn't be
super-difficult to do what you need.
--
select 'cbbrowne' || '@' || 'cbbrowne.com';
http://cbbrowne.com/info/slony.html
"MS apparently now has a team dedicated to tracking problems with
Linux and publicizing them. I guess eventually they'll figure out
this back fires... ;)" -- William Burrow <aa126(at)DELETE(dot)fan(dot)nb(dot)ca>