Postgres Pro
Downloads
Home   >   mailing lists

Re: Tool for translation of Oracle PL/SQL into Postgresql PL/pgSQL - Mailing list pgadmin-hackers

From Guillaume Lelarge
Subject Re: Tool for translation of Oracle PL/SQL into Postgresql PL/pgSQL
Date
Msg-id 1391712816.2595.1.camel@localhost.localdomain
Whole thread Raw
In response to Tool for translation of Oracle PL/SQL into Postgresql PL/pgSQL  (suhas_bt022 <suhas_bt022@yahoo.co.in>)
List pgadmin-hackers
Tree view 
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

pgadmin-hackers by date:

Previous
From: suhas_bt022
Date:
Subject: Tool for translation of Oracle PL/SQL into Postgresql PL/pgSQL
Next
From: Dave Page
Date:
Subject: pgAdmin III commit: Cleanup some compiler warnings seen with clang on O