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

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: suhas_bt022 <suhas_bt022(at)yahoo(dot)co(dot)in>
Cc: pgadmin-hackers(at)postgresql(dot)org
Subject: Re: Tool for translation of Oracle PL/SQL into Postgresql PL/pgSQL
Date: 2014-02-06 18:53:36
Message-ID: 1391712816.2595.1.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

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

In response to

Browse pgadmin-hackers by date

  From Date Subject
Next Message Guillaume Lelarge 2014-02-06 18:55:30 Re: Format SQL (external tool)
Previous Message Craig Ringer 2014-02-06 12:34:21 Re: Format SQL (external tool)