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

From: David Fetter <david(at)fetter(dot)org>
To: DM <dm(dot)aeqa(at)gmail(dot)com>
Cc: Richard Broersma <richard(dot)broersma(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Move data from DB2 to Postgres any software/solutions/approach?
Date: 2010-06-04 21:49:13
Message-ID: 20100604214913.GA11892@fetter.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(dot)aeqa(at)gmail(dot)com> wrote:
>
> > Thanks Robert,
> >
> > Is there any tools available.
> >
> > Thanks
> > Deepak
> >
> >
> > On Fri, Jun 4, 2010 at 2:19 PM, Richard Broersma <
> > richard(dot)broersma(at)gmail(dot)com> wrote:
> >
> >> On Fri, Jun 4, 2010 at 2:13 PM, DM <dm(dot)aeqa(at)gmail(dot)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(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message DM 2010-06-04 22:08:24 Re: Move data from DB2 to Postgres any software/solutions/approach?
Previous Message Alvaro Herrera 2010-06-04 21:42:49 Re: cannot assign non-composite value to a row variable