Oracle -> Postgres live translation?
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...
Postgres is on linux Debian server.
It would be very cool... :)
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 #