Lists: | pgsql-odbc |
---|
From: | "Jagaraj, Peter" <peter(dot)jagaraj(at)gmacrfc(dot)com> |
---|---|
To: | "'pgsql-odbc(at)postgresql(dot)org'" <pgsql-odbc(at)postgresql(dot)org> |
Subject: | FW: Multiple databases question |
Date: | 2003-02-07 19:29:14 |
Message-ID: | 34F479803A00524D8B4C7FE9A93E92E0500E7A@SMSPAP41M.na.corp.gmacrfc.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-odbc |
Here is the situation:
I have a bunch of tables in PostgreSQL. Our production db is Oracle running
on Unix. I would like to read records from PostgreSQL and insert them into
Oracle tables. Is there a simple way, say via PSQL or PL/SQL routine, to do
this?
Thanks
_____
Peter Jagaraj
Data Warehouse Analyst
Enterprise Technology Services
Phone:(952) 857-6151 Fax:(952) 238-8711
GMAC- RFC
<mailto:peter(dot)jagaraj(at)gmacrfc(dot)com> peter(dot)jagaraj(at)gmacrfc(dot)com
From: | Benjamin Scherrey <scherrey(at)proteus-tech(dot)com> |
---|---|
To: | "Jagaraj, Peter" <peter(dot)jagaraj(at)gmacrfc(dot)com>, pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: FW: Multiple databases question |
Date: | 2003-02-12 22:28:38 |
Message-ID: | A73XMHWU05LK97D0T4ZPLESPFA73RM.3e4aca96@BONZO |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-odbc |
You don't say what your client environment is but I would probably lean towards writing up a very
small python app/script rather than bothering with ODBC. Python has excellent support for both
PostgreSQL and Oracle connectivity - and it works under just about any environment.
good luck,
Ben Scherrey
2/7/2003 2:29:14 PM, "Jagaraj, Peter" <peter(dot)jagaraj(at)gmacrfc(dot)com> wrote:
> Here is the situation:
>
> I have a bunch of tables in PostgreSQL. Our production db is Oracle running
> on Unix. I would like to read records from PostgreSQL and insert them into
>
> Oracle tables. Is there a simple way, say via PSQL or PL/SQL routine, to do
> this?
>
> Thanks