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.Sanusi@seagate.com>
>To: <pgsql-general@postgresql.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@postgresql.org)
>
>
