Re: Looking for help to migrate Oracle PL SQL code to PGSQL code - Mailing list pgsql-admin

From P C
Subject Re: Looking for help to migrate Oracle PL SQL code to PGSQL code
Date
Msg-id CADrzpjGqmB9gaLUA-MXyRWnEt71wC_Qwq0rx1OEb=qBPSudbxg@mail.gmail.com
Whole thread Raw
In response to Re: Looking for help to migrate Oracle PL SQL code to PGSQL code  (dbatoCloud Solution <dbatocloud17@gmail.com>)
Responses Re: Looking for help to migrate Oracle PL SQL code to PGSQL code  (Holger Jakobs <holger@jakobs.com>)
List 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 by date:

Previous
From: Satoshi Nakamoto
Date:
Subject: Re: Stuck Checkpoint Process
Next
From: Holger Jakobs
Date:
Subject: Re: Looking for help to migrate Oracle PL SQL code to PGSQL code