From: | Jan Wieck <JanWieck(at)Yahoo(dot)com> |
---|---|
To: | Eric <ericg(at)conceptid(dot)ca> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Oracle -> Postgres live translation? |
Date: | 2004-01-15 15:47:56 |
Message-ID: | 4006B62C.6060707@Yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Eric wrote:
> Hi,
>
> I would like to know if a daemon exist to intercept Oracle queries and
> translate to postgresql query...
>
> I have a windows app (AccPac) that connect to an Oracle server via
> ODBC. I would like to replace the Oracle server with a postgresql.
> Accpac support only Oracle, DB2, MS-SQL and pervasive.
>
> So, something capable of interpreting...
>
> WinApp <-> Oracle ODBC command <-> Translator <-> Postgres server.
>
> The translator layer...
Hmmm, I guess you want to hack in the ODBC driver for PostgreSQL. It
already does *some* parsing, so you're not starting from scratch three.
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2004-01-15 15:54:55 | Re: fixed-length row |
Previous Message | Karsten Hilbert | 2004-01-15 15:44:46 | Re: Using regular expressions in LIKE |