Thread: Tool for translation of Oracle PL/SQL into Postgresql PL/pgSQL

Tool for translation of Oracle PL/SQL into Postgresql PL/pgSQL

From
suhas_bt022
Date:
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



--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Tool-for-translation-of-Oracle-PL-SQL-into-Postgresql-PL-pgSQL-tp5790796.html
Sent from the PostgreSQL - pgadmin hackers mailing list archive at Nabble.com.


Re: Tool for translation of Oracle PL/SQL into Postgresql PL/pgSQL

From
Guillaume Lelarge
Date:
On Wed, 2014-02-05 at 22:37 -0800, suhas_bt022 wrote:
> 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 ?

ora2pg can help you on this. Probably your best bet. Alas, no tool will
offer you an automatic conversion of every function/procedure/package.


--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com