What is the most Oracle compatible open source DBMS? [closed]
We don’t allow questions seeking recommendations for books, tools, software libraries, and more. You can edit the question so it can be answered with facts and citations.
Closed 7 years ago.
开发者_高级运维 Improve this questionMy 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.
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.
PostgreSQL is probably the only open source enterprise class DBMS and the syntax resembles more of PL/SQL than anything else.
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
Probably Postgres Plus Advanced Server.
why not Oracle's Berkeley 11g? I bet it offers best integration with Oracle.
精彩评论