Re: Oracle -> Postgres live translation?

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 #

In response to

Browse pgsql-general by date

  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