Re: Looking for help to migrate Oracle PL SQL code to PGSQL code

Поиск
Список
Период
Сортировка
От P C
Тема Re: Looking for help to migrate Oracle PL SQL code to PGSQL code
Дата
Msg-id CADrzpjGqmB9gaLUA-MXyRWnEt71wC_Qwq0rx1OEb=qBPSudbxg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Looking for help to migrate Oracle PL SQL code to PGSQL code  (dbatoCloud Solution <dbatocloud17@gmail.com>)
Ответы Re: Looking for help to migrate Oracle PL SQL code to PGSQL code  (Holger Jakobs <holger@jakobs.com>)
Список pgsql-admin
Ashok,

There are tools like ora2pg and others which will help you convert oracle-plsql to pg-psql. However, note 2 things:
1. It will not do a 100% conversion.
2. You will need to verify whatever it has converted to ensure that your functionality is not impacted which means testing efforts will be substantial.

All-in-all, as others shared, it is quite a task. Although ora2pg/tools will reduce some work, the time will not reduce because you will still need to verify the conversion and convert yourself whatever is not converted.

HTH

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

Предыдущее
От: Satoshi Nakamoto
Дата:
Сообщение: Re: Stuck Checkpoint Process
Следующее
От: Holger Jakobs
Дата:
Сообщение: Re: Looking for help to migrate Oracle PL SQL code to PGSQL code