Thread: Share Data between PostgreSQL and Oracle

Anyone have experience doing this?  I would like to hear your tips and experiences.

Here's our situation.  We have an Oracle DB on Sun Solaris 8 and a PostgreSQL DB on Linux (RH 7.3) that we need to share data between, specifically from PostgreSQL to Oracle.  I want to experiment with Oracle's Generic Connectivity via ODBC connection.  The advantage here seems to be DB-to-DB connection, ability to use Oracle SQL and tools, etc.  Limitations might be network performance.

An alternative is to produce flat files from PostgreSQL, FTP them to Oracle server, and SQL*Load them into Oracle.  Not a real-time solution, but load performance is usually very good with SQL*Loader.

Best regards,

David B. Wagoner
Database Administrator
Arsenal Digital Solutions
Web: http://www.arsenaldigital.com

Hai friend
Perl DBI and DBD cab be user for accessing oracle or
postgress.

I think, you are looking for this kind of solution

Regards
raja
--- David Wagoner <dwagoner@arsenaldigital.com> wrote:
> Anyone have experience doing this?  I would like to
> hear your tips and
> experiences.
>
> Here's our situation.  We have an Oracle DB on Sun
> Solaris 8 and a
> PostgreSQL DB on Linux (RH 7.3) that we need to
> share data between,
> specifically from PostgreSQL to Oracle.  I want to
> experiment with Oracle's
> Generic Connectivity via ODBC connection.  The
> advantage here seems to be
> DB-to-DB connection, ability to use Oracle SQL and
> tools, etc.  Limitations
> might be network performance.
>
> An alternative is to produce flat files from
> PostgreSQL, FTP them to Oracle
> server, and SQL*Load them into Oracle.  Not a
> real-time solution, but load
> performance is usually very good with SQL*Loader.
>
>
>
> Best regards,
>
> David B. Wagoner
> Database Administrator
> Arsenal Digital Solutions
> Web: http://www.arsenaldigital.com
>


__________________________________
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com