Thread: Tool for translation of Oracle PL/SQL into Postgresql PL/pgSQL
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.
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