Re: Oracle to Postgres migration
- From: Igor Neyman <igor.neyman@xxxxxxxxx>
- To: Amir.Hameed@xxxxxxxxx
- Date: Thu, 13 Jan 2011 14:07:15 -0500
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
On Thu, Jan 13, 2011 at 1:12 PM, Hameed, Amir <Amir.Hameed@xxxxxxxxx> wrote:
> Folks,
>
> I am interested to know if anyone has done a migration of an Oracle
> database to Postgres (from EnterpriseDB
> http://www.enterprisedb.com/solutions/business_case.do)? This company
> seems to claim that most of the applications developed in Oracle could be
> migrated to their database. Any feedback would be appreciated.
>
>
>
> Thank you
>
> Amir
>
>
>
Other related posts:
