On Sep 13, 2006, at 9:46 PM, David Link wrote:
I'm looking at replacing an Oracle database that only has a few
tables, but that is accessed by many programs in the company via
oracle jdbc drivers, oracle odbc drivers and python database
interface.
Is there a way to intercept the calls to the oracle listener and
redirect to postgres without changing the calling application?
None that I know of, but all of those should happily be able to point
at a PostgreSQL database (at least jdbc and odbc, since it's what
they're designed for; I'm assuming python can do it too).
A bigger issue you're likely to run into is that unless your programs
are using only the barest, simplest commands you're likely to run
into syntax compatibility issues. If that's the case you'll either
need to port the code (there is a tool out there somewhere that might
help with that), or you can try our (commercial) product.
--
Jim Nasby [EMAIL PROTECTED]
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
