What is the most Oracle compatible open source DBMS?

views:

183

answers:

+5 Q:

What is the most Oracle compatible open source DBMS?

My organization is thinking on using an open source DBMS (free if possible, but not mandatory) for all new apps that we develop. Since we already have quite a few apps that connect to an oracle server, we would like to use a DBMS that is as compatible as possible with Oracle. So we can port the apps to oracle with the less work in the case we don't get the same performance or just don't like how it responds. Also, most of the developers have experience only with Oracle.

Which one would you recommend? We're trying to cut down costs.

+8 A:

Postgresql has always proven to be a good choice in my experience.

Read up on Oracle to Postgres conversion

There is also this page which offers links to more information and tools for migration.

Specifically the Porting from Oracle PL / SQL section of the PostgreSQL manual.

kerchingo 2010-02-03 23:10:54

The referenced page appears to be ancient, though. The phrases "Postgres large objects are scheduled for a major overhaul in summer 2000" and "However, with the lztext extension coming with Postgres 7.0" indicate that any conversion advice on this page should be considered suspect. I agree with the recommendation of PostgreSQL, just not the instructions on the referenced page.

Matthew Wood 2010-02-03 23:30:57

+1 Agreed. I have included some links to more recent sources of information that will hopefully help.

kerchingo 2010-02-03 23:44:41

+2 A:

Definitely not MySQL. They are as similar as pickles and wool socks.

Use postgres. I suggest this resource:

http://wiki.postgresql.org/wiki/PostgreSQL_for_Oracle_DBAs

hobodave 2010-02-03 23:11:18

+1 just for "pickles and wool socks". Spot on info as well.

duffymo 2010-02-04 02:08:40

In the light of the recent acquisition of Sun it will be interesting to see how this changes in the coming years.

Jeffrey Kemp 2010-02-04 02:23:18

+2 A:

Probably Postgres Plus Advanced Server.

Ignacio Vazquez-Abrams 2010-02-03 23:11:27

This one seems like a very good alternative. However, I understood that the extensions for making compatible are not open source. Am I right?

tou 2010-02-04 16:41:44

I... don't actually know. This is what Google came up with >.>

Ignacio Vazquez-Abrams 2010-02-04 16:45:11

+3 A:

PostgreSQL is probably the only open source enterprise class DBMS and the syntax resembles more of PL/SQL than anything else.

Pratik 2010-02-03 23:11:57

+1 A:

why not Oracle's Berkeley 11g? I bet it offers best integration with Oracle.

coulminer 2010-10-10 06:30:13

ansaurus

tags:

views:

answers:

What is the most Oracle compatible open source DBMS?

related questions