| 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