Skip site navigation (1) Skip section navigation (2)

Re: Share Data between PostgreSQL and Oracle

From: Raja Kumar Thatte <trajakumar(at)yahoo(dot)com>
To: David Wagoner <dwagoner(at)arsenaldigital(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Share Data between PostgreSQL and Oracle
Date: 2003-10-23 03:49:08
Message-ID: 20031023034908.81504.qmail@web20605.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-admin
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(at)arsenaldigital(dot)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

In response to

pgsql-admin by date

Next:From: JeffDate: 2003-10-23 12:30:48
Subject: Re: Need PGSQL ODBC Driver for Solaris
Previous:From: CoLDate: 2003-10-22 21:03:03
Subject: Re: Multi-Language server

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group