Lonni J Friedman wrote:
On Tue, 22 Mar 2005 17:51:06 -0800, Randy Samberg
<[EMAIL PROTECTED]> wrote:
Does anyone know if there is a way in Postgres to emulate Oracle, in other
words make Postgres think it is an Oracle database? If so, do you have any
idea what percentage of people are doing this, and how successful they are
with this? Also, how is this done? Do you know of any good links that
discuss this. My manager is thinking about replacing a couple of Oracle
databases with Postgres, and would like to know the answer to this question.
You mean make postgres slow, bloated & buggy?
I am going to assume that was a joke, but it is not helpful.
There is no real way to "emulate" Oracle. The best you could
do is to have some level of software proxy that would understand
the Oracle protocol and then translate that to PostgreSQL but you
are looking at a huge mess.
You would have to consider all the queries and such.
What I can tell you is that it doesn't take much to port Oracle
to PostgreSQL. There are some major differences in feature set
but those can usually be solved programmatically.
Sincerely,
Joshua D. Drake
--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - [EMAIL PROTECTED] - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL
begin:vcard
fn:Joshua Drake
n:Drake;Joshua
org:Command Prompt, Inc.
adr:;;PO Box 215 ;Cascade Locks;OR;97014;US
email;internet:[EMAIL PROTECTED]
title:Consultant
tel;work:503-667-4564
tel;fax:503-210-0334
x-mozilla-html:FALSE
url:http://www.commandprompt.com
version:2.1
end:vcard
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
