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

Поиск
Список
Период
Сортировка
От Dinesh Kumar
Тема Re: Tool for translation of Oracle PL/SQL into Postgresql PL/pgSQL
Дата
Msg-id CAKWsr7h_iat5iv0AYNy+z+quPwng4fgzOFgoeoCDJ6VZdVAuPA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Tool for translation of Oracle PL/SQL into Postgresql PL/pgSQL  (suhas_bt022 <suhas_bt022@yahoo.co.in>)
Список pgadmin-support
Дерево обсуждения
Hi Suhas,


On Thu, Feb 6, 2014 at 6:54 PM, suhas_bt022 <suhas_bt022@yahoo.co.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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

В списке pgadmin-support по дате отправления:

Предыдущее
От: suhas_bt022
Дата:
Сообщение: Re: Tool for translation of Oracle PL/SQL into Postgresql PL/pgSQL
Следующее
От: Guillaume Lelarge
Дата:
Сообщение: Re: Format SQL (external tool)