Re: Oracle -> Postgres live translation? - Mailing list pgsql-general

From Jan Wieck
Subject Re: Oracle -> Postgres live translation?
Date
Msg-id 4006B62C.6060707@Yahoo.com
Whole thread Raw
In response to Oracle -> Postgres live translation?  (Eric <ericg@conceptid.ca>)
List 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@Yahoo.com #


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Foreign key question
Next
From: David Helgason
Date:
Subject: Bytea/Large Objects/external files best practices