Re: Oracle to Postgres migration
- From: Igor Neyman <igor.neyman@xxxxxxxxx>
- To: vit.spinka@xxxxxxxxxxxx
- Date: Thu, 13 Jan 2011 16:19:59 -0500
Hello Vit,
I haven't looked at EnterpriseDB lately and specifically what new features
they offer.
But, the "general" feeling is that they are developing features, that would
bring "community" version of PostgreSQL closer to Oracle, and make migration
somewhat easier. I think, they even have some kind of "migration" tool.
Still they (Oracle and PG) really far apart, considering abundance of Oracle
features.
What I like is that with Postgres one can get some features available in
Oracle only for "extra" $$, i.e. Postgres (even "community" version)
provides table Partitioning, though you have to do some Pl/PgSQL programming
to use/implement this feature.
Regards,
Igor
On Thu, Jan 13, 2011 at 3:45 PM, Vit Spinka <vit.spinka@xxxxxxxxxxxx> wrote:
> 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:
