Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mjyH7-0006E5-Fy for pgsql-admin@arkaria.postgresql.org; Mon, 08 Nov 2021 06:37:01 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mjyH5-0006wl-B8 for pgsql-admin@arkaria.postgresql.org; Mon, 08 Nov 2021 06:36:59 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mjyH5-0006wb-0l for pgsql-admin@lists.postgresql.org; Mon, 08 Nov 2021 06:36:59 +0000 Received: from jakobs.com ([85.214.83.89] helo=rs.plausibolo.de) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mjyH0-0005m6-G6 for pgsql-admin@postgresql.org; Mon, 08 Nov 2021 06:36:58 +0000 Received: from localhost (localhost [127.0.0.1]) by rs.plausibolo.de (Postfix) with ESMTP id 7BE2E380524; Mon, 8 Nov 2021 07:36:53 +0100 (CET) Received: from rs.plausibolo.de ([IPv6:::1]) by localhost (h2367442.stratoserver.net [IPv6:::1]) (amavisd-new, port 10024) with ESMTP id QUBP3Jgne0V9; Mon, 8 Nov 2021 07:36:53 +0100 (CET) Received: from [127.0.0.1] (dynamic-046-114-111-251.46.114.pool.telefonica.de [46.114.111.251]) by rs.plausibolo.de (Postfix) with ESMTPSA id 19965380399; Mon, 8 Nov 2021 07:36:53 +0100 (CET) Date: Mon, 08 Nov 2021 07:36:47 +0100 From: Holger Jakobs To: pgsql-admin@lists.postgresql.org, P C , dbatoCloud Solution CC: Firthouse banu , pgsql-admin Subject: Re: Looking for help to migrate Oracle PL SQL code to PGSQL code User-Agent: K-9 Mail for Android In-Reply-To: References: Message-ID: <88EFBB75-96C0-4EB9-9F52-951A168CC7ED@jakobs.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=----GFS96YXLDA6CGT92VL5UN0S3C5VBGU Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------GFS96YXLDA6CGT92VL5UN0S3C5VBGU Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Another tool https://www=2Ecybertec-postgresql=2Ecom/en/products/cybertec-migrator/ Am 8=2E November 2021 07:16:18 MEZ schrieb P C : >Ashok, > >There are tools like ora2pg and others which will help you convert >oracle-plsql to pg-psql=2E However, note 2 things: >1=2E It will not do a 100% conversion=2E >2=2E You will need to verify whatever it has converted to ensure that you= r >functionality is not impacted which means testing efforts will be >substantial=2E > >All-in-all, as others shared, it is quite a task=2E Although ora2pg/tools >will reduce some work, the time will not reduce because you will still ne= ed >to verify the conversion and convert yourself whatever is not converted= =2E > >HTH --=20 Holger Jakobs, Bergisch Gladbach +49 178 9759012 - sent from mobile, therefore short - ------GFS96YXLDA6CGT92VL5UN0S3C5VBGU Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable Another tool
https://www=2Ecybertec-pos= tgresql=2Ecom/en/products/cybertec-migrator/

Am 8=2E November 2021 07:16:18 MEZ schrieb P C <puravc@gmail=2Ec= om>:
Ashok,

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

All-in-all, as others shared, it is quite a t= ask=2E Although ora2pg/tools will reduce some work, the time will not reduc= e because you will still need to verify the conversion and convert yourself= whatever is not converted=2E

HTH
--
Holger Jakobs, Bergisch Gladbach
+49 178 9759012- sent from mobile, therefore short -
------GFS96YXLDA6CGT92VL5UN0S3C5VBGU--