Обсуждение: How to migrate from oracle to postgres !!

Zitat von Suresh Borse <s.borse@direction.biz>:

> Dear All,
>
> How to migrate existing database which in Oracle  to postgres?
>
> Please provide me the solution/limitation for triggers , procedure ,
> packages & views while migrating.
>
>
> Thanks & Regards,
>
> Suresh Borse
> (DBA)

Not long ago someone posted the following link

http://wiki.kandalaya.org/cgi-bin/twiki/view/Main/MigratingOracleToPostgreSQL

but i honestly don't know how useful it is.

Regards

Andreas

On Fri, 2009-01-30 at 17:04 +0530, Suresh Borse wrote:
> How to migrate existing database which in Oracle  to postgres?

Some people use Ora2Pg for taking data snapshot from Oracle to
PostgreSQL:

http://pgfoundry.org/projects/ora2pg/

Also, there is another project which adds Oracle compat functions to
PostgreSQL, which will help you to port your application easier:

http://pgfoundry.org/projects/orafce

..and here is the presentation from Peter. Subject: Porting Oracle
applications to PostgreSQL:

http://www.pgcon.org/2008/schedule/track/Tutorial/62.en.html

-HTH.

Regards,
--
Devrim GÜNDÜZ, RHCE
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
                   http://www.gunduz.org