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

On Fri, Jun 4, 2010 at 2:13 PM, DM <dm.aeqa@gmail.com> wrote:

We want to replicate /move data form db2 to postgres is there any software /
solutions / approach available to do this?

Here is a link on the postgresql wiki.

Hopefully it has some useful information.

http://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL#IBM_DB2

--
Regards,
Richard Broersma Jr.

Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug

Thanks Robert,

Is there any tools available.

Thanks
Deepak

On Fri, Jun 4, 2010 at 2:19 PM, Richard Broersma <richard.broersma@gmail.com

DM wrote:

Hi All,

We want to replicate /move data form db2 to postgres is there any
software / solutions / approach available to do this?

in general, I'd likely use a perl or similar program to connect to the
'other' database, fetch your data, and insert it into your postgres
database. this, of course, would require knowledge of the specific data
you want to copy. if you are talking about a live ongoing replica,
then it gets more complicated. if you're moving applications from DB2
to postgres, yet more complications.

another approach might be DBI-Link, which is a plugin for postgres that
allows you to connect to foreign external databases from within a
postgres database, using pl/perl

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.

Thanks
Deepak

On Fri, Jun 4, 2010 at 2:23 PM, DM <dm.aeqa@gmail.com> wrote:

Deepak,

You can use DBI-Link to make writeable views of tables in DB2 (or
other data store) from PostgreSQL. You can use the same linkage to
materialize those views, if you like.

The latest version of the software is on GitHub

http://github.com/davidfetter/DBI-Link

You can also join the low-traffic mailing list at

http://pgfoundry.org/projects/dbi-link/

Cheers,
David.
On Fri, Jun 04, 2010 at 02:33:53PM -0700, 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.

Thanks
Deepak

On Fri, Jun 4, 2010 at 2:23 PM, DM <dm.aeqa@gmail.com> wrote:

Thanks Robert,

Is there any tools available.

Thanks
Deepak

On Fri, Jun 4, 2010 at 2:19 PM, Richard Broersma <
richard.broersma@gmail.com> wrote:

On Fri, Jun 4, 2010 at 2:13 PM, DM <dm.aeqa@gmail.com> wrote:

We want to replicate /move data form db2 to postgres is there any

software /

solutions / approach available to do this?

Here is a link on the postgresql wiki.

Hopefully it has some useful information.

http://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL#IBM_DB2

--
Regards,
Richard Broersma Jr.

Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug

--
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fetter@gmail.com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate

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)

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:

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.

well, you might look over
http://www.redbooks.ibm.com/abstracts/sg246828.html which discusses
DB2 replication. "The Appendix C provides information about configuring
federated access to Informix, which can be used as a model for federated
access to other non-DB2 database, such as Oracle, MS SQL Server, Sybase,
and more, using DB2 Information Integrator V8. "

Thank you so much for all your inputs.

On Fri, Jun 4, 2010 at 3:27 PM, John R Pierce <pierce@hogranch.com> wrote:

dm.aeqa@gmail.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@DELETE.fan.nb.ca>