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

From: Dinesh Kumar <dinesh(dot)kumar(at)enterprisedb(dot)com>
To: suhas_bt022 <suhas_bt022(at)yahoo(dot)co(dot)in>
Cc: "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org>
Subject: Re: Tool for translation of Oracle PL/SQL into Postgresql PL/pgSQL
Date: 2014-02-06 13:10:24
Message-ID: CAKWsr7iDne_WfOJtVyJXOBtjaXtm6kpu0Ltk8L0LYBmU9nPE0Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hi Suhas,

On Thu, Feb 6, 2014 at 6:02 PM, suhas_bt022 <suhas_bt022(at)yahoo(dot)co(dot)in> wrote:

> Hi,
>
> Ora2pg does not translate PL/SQL into Postgresql PL/pgSQL.
> We need to do it manually.
> I was looking for a open source solution to this problem .
>
>
Ora2Pg do converts the PL/SQL objects to PL/PGSQL. I haven't tried it , but
from their website, it seems it supports this functionality.

Find this here <http://ora2pg.darold.net/config.html>.

-p | --plsql : Enable PLSQL to PLPSQL code conversion.

If this is not you are looking for, then hope some will give you another
open source tool.

Thanks,
Dinesh

Thanks
> Suhas
>
>
>
> --
> View this message in context:
> http://postgresql.1045698.n5.nabble.com/Tool-for-translation-of-Oracle-PL-SQL-into-Postgresql-PL-pgSQL-tp5790797p5790832.html
> Sent from the PostgreSQL - pgadmin support mailing list archive at
> Nabble.com.
>
>
> --
> Sent via pgadmin-support mailing list (pgadmin-support(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-suppor<http://www.postgresql.org/mailpref/pgadmin-support>
>

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message suhas_bt022 2014-02-06 13:24:54 Re: Tool for translation of Oracle PL/SQL into Postgresql PL/pgSQL
Previous Message Craig Ringer 2014-02-06 12:34:21 Re: Format SQL (external tool)