[pgadmin-hackers] 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. -- Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-hackers
Re: [pgadmin-hackers] Tool for translation of Oracle PL/SQL into Postgresql PL/pgSQL
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 -- Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-hackers
