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

Hi Suhas,

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

> We have tried it already.Actually there are a quite a lot of syntax changes
> required .Which is making task time consuming.
>
> You can find below statement in ora2pg website.
> Ora2Pg do its best to automatically convert your Oracle database to
> PostgreSQL but there's still manual works to do. The Oracle specific PL/SQL
> code generated for functions, procedures, packages and triggers has to be
> reviewed to match the PostgreSQL syntax.
>
> Oh. Sorry :)

Once i have used *SQLWays* kind of tool for the conversion of Oracle to
PostgreSQL. But i didn't remember the name of that tool. Even the tool i
have used didn't gave me 100% expected result. Still, i modified the code
given by the tool as per business needs.

Hope someone will give you better tools on this.

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-tp5790797p5790845.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-support
>