In <[EMAIL PROTECTED]>, Trent Nelson <[EMAIL PROTECTED]> typed: > I'm interested in seeing how well something like PostgreSQL can be > used as a ``drop-in'' replacement for Oracle. If I have clients > connecting via ODBC (Rational ClearQuest), I personally couldn't > care what the underlying database is. Now *that* is something I'd > be interested in seeing a write up for.
It's not a drop-in replacement. You have to install the PostgreSQL ODBC drivers on all the clients. Any client-side scripts will have to be changed to use a PostgreSQL wrappers instead of Oracle wrappers. The SQL is probably subtly different as well. SQL may be a standard, but you still get locked into the databases that you can query with it. <mike -- Mike Meyer <[EMAIL PROTECTED]> http://www.mired.org/consulting.html Independent WWW/Perforce/FreeBSD/Unix consultant, email for more information. To Unsubscribe: send mail to [EMAIL PROTECTED] with "unsubscribe freebsd-questions" in the body of the message