| From: | Holger Jakobs <holger(at)jakobs(dot)com> |
|---|---|
| To: | pgsql-admin(at)lists(dot)postgresql(dot)org, P C <puravc(at)gmail(dot)com>, 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:36:47 |
| Message-ID: | 88EFBB75-96C0-4EB9-9F52-951A168CC7ED@jakobs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Another tool
https://www.cybertec-postgresql.com/en/products/cybertec-migrator/
Am 8. November 2021 07:16:18 MEZ schrieb P C <puravc(at)gmail(dot)com>:
>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
--
Holger Jakobs, Bergisch Gladbach
+49 178 9759012
- sent from mobile, therefore short -
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lynn Carol Johnson | 2021-11-08 12:45:07 | Postgres dying after many failed logins |
| Previous Message | P C | 2021-11-08 06:16:18 | Re: Looking for help to migrate Oracle PL SQL code to PGSQL code |