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

From: P C <puravc(at)gmail(dot)com>
To: dbatoCloud Solution <dbatocloud17(at)gmail(dot)com>
Cc: Firthouse banu <penguinsfairy(at)gmail(dot)com>, pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Looking for help to migrate Oracle PL SQL code to PGSQL code
Date: 2021-11-08 06:16:18
Message-ID: CADrzpjGqmB9gaLUA-MXyRWnEt71wC_Qwq0rx1OEb=qBPSudbxg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Holger Jakobs 2021-11-08 06:36:47 Re: Looking for help to migrate Oracle PL SQL code to PGSQL code
Previous Message Satoshi Nakamoto 2021-11-07 16:55:27 Re: Stuck Checkpoint Process