Re: Share Data between PostgreSQL and Oracle

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