pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Holger Jakobs <holger@jakobs.com>
To: pgsql-admin@lists.postgresql.org, P C <puravc@gmail.com>
To: dbatoCloud Solution <dbatocloud17@gmail.com>
Cc: Firthouse banu <penguinsfairy@gmail.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Looking for help to migrate Oracle PL SQL code to PGSQL code
Date: Mon, 08 Nov 2021 07:36:47 +0100
Message-ID: <88EFBB75-96C0-4EB9-9F52-951A168CC7ED@jakobs.com> (raw)
In-Reply-To: <CADrzpjGqmB9gaLUA-MXyRWnEt71wC_Qwq0rx1OEb=qBPSudbxg@mail.gmail.com>
References: <CAEz7P_sZkqc15E=zdrtnRafBqQqk8TyC9-aaCufPxeRJrx5MGg@mail.gmail.com>
	<CAK_Ha4zNcd17HZ=au=XmqZGn78-08274_q8MRUhMzqaRLG+xog@mail.gmail.com>
	<CAEz7P_tLi4DKJLV_W8GCYXf+c_dx5n+z+nvyH9mmhthVmi6=mg@mail.gmail.com>
	<CADrzpjGqmB9gaLUA-MXyRWnEt71wC_Qwq0rx1OEb=qBPSudbxg@mail.gmail.com>

Another tool
https://www.cybertec-postgresql.com/en/products/cybertec-migrator/

Am 8. November 2021 07:16:18 MEZ schrieb P C <puravc@gmail.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 -

view thread (6+ messages)

Message-ID: <88EFBB75-96C0-4EB9-9F52-951A168CC7ED@jakobs.com>
Permalink:  ../88EFBB75-96C0-4EB9-9F52-951A168CC7ED@jakobs.com/
Also on:    postgresql.org/message-id/88EFBB75-96C0-4EB9-9F52-951A168CC7ED@jakobs.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: holger@jakobs.com, puravc@gmail.com, dbatocloud17@gmail.com, penguinsfairy@gmail.com
  Subject: Re: Looking for help to migrate Oracle PL SQL code to PGSQL code
  In-Reply-To: <88EFBB75-96C0-4EB9-9F52-951A168CC7ED@jakobs.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox