469,934 Members | 1,922 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,934 developers. It's quick & easy.

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... :)

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 12 '05 #1
1 2104
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. #
#================================================= = Ja******@Yahoo.com #
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

Nov 22 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by susmita_ganguly | last post: by
63 posts views Thread by Nick Palmer | last post: by
13 posts views Thread by BigDaDDY | last post: by
13 posts views Thread by Chris Botha | last post: by
2 posts views Thread by Ruslan A Dautkhanov | last post: by
reply views Thread by Jack | last post: by
reply views Thread by Winder | last post: by
4 posts views Thread by --CELKO-- | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.