Re: A way to link oracle DB to postgres DB for data transfer

Yes, Perl is an option.

> Perl is not a strongly typed language, as such it provides the best canvas
> for intercultural relationships....

Provide options, not opinions. I could have just as easily said,

"Use Java if you are familiar with C, C++ or any other standard language.
Use Perl if your parents are brother and sister, or you've suffered a
dehabilitating brain injury..."

David.

----- Original Message -----
From: "Medi Montaseri" <medi(dot)montaseri(at)intransa(dot)com>
To: "David Griffiths" <dgriffiths(at)boats(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Sent: Thursday, October 24, 2002 5:25 PM
Subject: Re: [GENERAL] A way to link oracle DB to postgres DB for data
transfer

> Or write a DB Synchronizer written in Perl using DBI::Pg and DBI::Oracle.
> Perl is not a strongly typed language, as such it provides the best canvas
> for intercultural relationships....
>
> David Griffiths wrote:
>
> >Use JDBC - create a connection to each database and then copy data back
and
> >forth from one connection to the other.
> >
> >David
> >----- Original Message -----
> >From: <Zuhra(dot)Sanusi(at)seagate(dot)com>
> >To: <pgsql-general(at)postgresql(dot)org>
> >Sent: Thursday, October 24, 2002 4:42 PM
> >Subject: [GENERAL] A way to link oracle DB to postgres DB for data
transfer
> >
> >
> >
> >
> >>I need to transfer data that reside in my oracle database to my
> >>
> >>
> >postgres
> >
> >
> >>database on a specific interval.
> >>
> >>So, is a way to create a link between the oracle DB and the postgres DB
> >>for data transfer usage.
> >>
> >>If I were to do it between 2 oracle database , I could have done via a
> >>DBLINK.
> >>
> >>I would greatly appreciate if someone could give me pointers on how to
get
> >>this done.
> >>
> >>Thank you. Any help is greatly appreciated.
> >>
> >>Regards
> >>Zuhra Sanusi
> >>
> >>
> >>
> >>---------------------------(end of broadcast)---------------------------
> >>TIP 4: Don't 'kill -9' the postmaster
> >>
> >>
> >
> >---------------------------(end of broadcast)---------------------------
> >TIP 2: you can get off all lists at once with the unregister command
> > (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
> >
> >
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly