Home > Archive > PostgreSQL Discussion > April 2006 > posgresql <-> oracle









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author posgresql <-> oracle
Mark Harrison

2006-04-06, 8:25 pm

We're got the need to replicate (two-way) some data between
postgresql and oracle.

Does anybody have versions of pg_dump or equivalents that
can go back and forth between the two databases?
It would be great if I could get both --schema-only
and --data-only functionality from this.

Thanks!
Mark

--
Mark Harrison
Pixar Animation Studios

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Joshua D. Drake

2006-04-06, 8:25 pm

Mark Harrison wrote:
> We're got the need to replicate (two-way) some data between
> postgresql and oracle.
>
> Does anybody have versions of pg_dump or equivalents that
> can go back and forth between the two databases?
> It would be great if I could get both --schema-only
> and --data-only functionality from this.
You might be able to use dbi-link over at pgFoundry.

Joshua D. Drake

>
> Thanks!
> Mark
>


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com