We have tried it already.Actually there are a quite a lot of syntax changes
required .Which is making task time consuming.
You can find below statement in ora2pg website.
Ora2Pg do its best to automatically convert your Oracle database to
PostgreSQL but there's still manual works to do. The Oracle
Hi,
Ora2pg does not translate PL/SQL into Postgresql PL/pgSQL.
We need to do it manually.
I was looking for a open source solution to this problem .
Thanks
Suhas
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Tool-for-translation-of-Oracle-PL-SQL-into-Postgresql-PL-p
We are trying to migrate a huge oracle database to postgresql.. I am finally
stuck with conversion of a huge database with around 250 stored procedures
.Its very painful procedure to convert plsql to plpgsql manually..
Anyone worked out a better solution for this ?
Any script or tool might help