Re: Oracle to Postgres migration

  • From: Vit Spinka <vit.spinka@xxxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 13 Jan 2011 21:45:26 +0100

Hello Igor,
interesting to hear that. I was also reviewing EnterpriseDB at about that time, but the project did not came through. What's your feeling regarding improvements in EnterpriseDB? Does it gets closer Oracle as the time goes, do they implement more Oracle-ish features (to make application porting easier)? Or do they deem this area to be complete and no improvements are done? 

Thanks

Vit

Dne 13.1.2011 20:07, Igor Neyman napsal(a):

Hello Amir,

About 3 years ago I designed and implemented migration of our "home
grown" application (multiple applications and database) from Oracle to
PostgreSQL ("community" version, which is free - not EnterpriseDB).
It required modifications in some data types in our database schema,
taking "special" care CLOB data type, re-writing PL/SQL code (though
Postgres's Pl/PgSQL is very similar).
Also, implemented data migration process from Oracle db into Postgres db
using Oracle's Heterogeneous Services and PostgreSQL ODBC driver.
It all worked (and works) pretty well.

  EnterpriseDB provides extended/enhanced (and not free of charge, but
still much cheaper than Oracle) version of PostgreSQL.
I think they even support Pl/PgSQL packages ("community" version - does
not), and include some (not many) re-writes of several  Oracle supplied
packages.

In short, IMHO you can migrate "home grown" application/s, but not
"third-party" applications.
And amongst opens source DBs - Postgres is the "closest" to Oracle.

Regards,
Igor Neyman


--
//www.freelists.org/webpage/oracle-l

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 01-2011