Skip site navigation (1)Skip section navigation (2)
Date:      Tue, 25 Feb 2003 10:12:52 -0600
From:      Mike Meyer <mwm-dated-1046621573.b13c3d@mired.org>
To:        Trent Nelson <trent@limekiln.vcisp.net>
Cc:        "Philip M. Gollucci" <philip@p6m7g8.com>, synrat <synrat@wirewalk.org>, questions@freebsd.org
Subject:   Re: Oracle on FreeBSD
Message-ID:  <15963.38404.257921.610622@guru.mired.org>
In-Reply-To: <20030225091453.GB70361@limekiln.vcisp.net>
References:  <1046128729.490.8.camel@dethstar> <Pine.LNX.4.50.0302242257420.21216-100000@mail.wirewalk.com> <200302242321.04463.philip@p6m7g8.com> <20030225091453.GB70361@limekiln.vcisp.net>

next in thread | previous in thread | raw e-mail | index | archive | help
In <20030225091453.GB70361@limekiln.vcisp.net>, Trent Nelson <trent@limekiln.vcisp.net> 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 <mwm@mired.org>		http://www.mired.org/consulting.html
Independent WWW/Perforce/FreeBSD/Unix consultant, email for more information.

To Unsubscribe: send mail to majordomo@FreeBSD.org
with "unsubscribe freebsd-questions" in the body of the message




Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?15963.38404.257921.610622>