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 1mjl5B-0007vQ-6k for pgsql-admin@arkaria.postgresql.org; Sun, 07 Nov 2021 16:31:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mjl5A-0006oM-1t for pgsql-admin@arkaria.postgresql.org; Sun, 07 Nov 2021 16:31:48 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mjl59-0006Yd-57 for pgsql-admin@lists.postgresql.org; Sun, 07 Nov 2021 16:31:47 +0000 Received: from mout.kundenserver.de ([212.227.126.187]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mjl52-0006MK-3Y for pgsql-admin@postgresql.org; Sun, 07 Nov 2021 16:31:45 +0000 Received: from ANAT ([78.197.128.121]) by mrelayeu.kundenserver.de (mreue010 [212.227.15.168]) with ESMTPSA (Nemesis) id 1MLiPA-1n1Hvj3BLM-00HgAK; Sun, 07 Nov 2021 17:31:35 +0100 From: "Michel SALAIS" To: "'dbatoCloud Solution'" , "'Firthouse banu'" Cc: References: In-Reply-To: Subject: RE: Looking for help to migrate Oracle PL SQL code to PGSQL code Date: Sun, 7 Nov 2021 17:31:34 +0100 Message-ID: <006c01d7d3f4$edc2da50$c9488ef0$@msym.fr> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_006D_01D7D3FD.4F8A2880" X-Mailer: Microsoft Outlook 16.0 Thread-Index: AQMTqFkR3jkLcIF2rvcNzHW8HgACygJzlfo1ATodR7KpYyiPUA== Content-Language: fr X-Provags-ID: V03:K1:Od4kGidaY5/g/o4+E4v6+cVv84HUPJLHOsaEsi2/wZVuJDIAGvl xEnXXJywOuifrB+HesLqQpGOjxq5veYOSFPO/noaLK4fqZK5WxmU+A3bzVK/xGu4NTtqExO M37vqoIW+dDTEPBmfpeAUNlHinsXqdSvagxPshuaCSGo8zJWS5JMnP+G94IT1u5rrRJu4dI cZGeE0bk4IoHQVME5Qkng== X-Spam-Flag: NO X-UI-Out-Filterresults: notjunk:1;V03:K0:Zpj6uycUDDU=:2H0JX71l/OgVCjyGhPQk4V FVSTTSy5xqExVQkQFLU0QFUiYdT3CvHT9Eeq1wSoUZ9VHcQIwe6YMEMGFYIZM7bobkVw1pZRj gew5pYfajPK0UhhsgZddTzCgNV07PTjpi1HK09OqFD3SnBM5IQe/VYWgfmUZtibKgHiMQ7TCK ZfFc44IzMenH3LcdY3wOzpH8z33rjinL9mCTNeBOzG8GIUawcT9FERtfinkTDXoO4uHDwFjK+ IW6TP3MbvweTfdmdzHqsL1b/hZ+Xgm6z6pdOeo+vRp6mpzGyimtRmvUw3rIsWuT6y1BkTZxX9 ehCnNaaPbYZC76xj2xVxc2VCRuwc/Xlz9O09jQePMkW5o+QC3Rcdd6IhdxgShA+Fz+S+N11m4 xpxgNdCtk6yjWGssgnpn0mWGB6664hpGSqq/4YWF/MqIacSfEsrBpHb5kaXs38F4cxCkz6wqr eNgb94YvemfA20KBtGy5BK3XRZKON46R3UzoRVTFxgLTKbBLzHS+GM5zIJRQUfuqi3jHaCIoT iRCceBU07tWyRDVmsnmIW4m951ql4rrwgazn2Lv+sTPGV9wVlPUxym5FhsB8Y4vyz6Q873nVu suepQARIXzHSST1ARgkJ+ArTzPzEV3fPXIFdKSzRDbG2XkHAHKxBINAXw1/z6/odrGfP4C8qc PQTZ+abw8AMrcGi8hjoI6+7oC8zDoBzN+ehPuKwK4pzhWqK7u7d4wepELcC9lPiDulYMliDzy t0vFrk241u5nfL7/6Y6nh9vOC0GWt4BiSL0E/Q== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multipart message in MIME format. ------=_NextPart_000_006D_01D7D3FD.4F8A2880 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable You can use ora2pg which can do a lot for you = (https://ora2pg.darold.net/start.html). =20 But this doesn=E2=80=99t mean that all will be automatic. You have to = recheck PL/pgSQL code generated by the tool. This is necessary because = of the difference of functionalities between Oracle and PostgreSQL. If = you have a lot of PL/SQL code, this will not be a little task. Anyway, = application code is on your charge. =20 Best regards Michel SALAIS De : dbatoCloud Solution =20 Envoy=C3=A9 : dimanche 7 novembre 2021 17:15 =C3=80 : Firthouse banu Cc : pgsql-admin@postgresql.org Objet : Re: Looking for help to migrate Oracle PL SQL code to PGSQL code =20 Hi Firthouse banu =20 Can you please share your experience of migrating oracle code to = postgresql ? I mean the steps and overview which would be great. =20 =20 Thanks Ashok ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Ashokkumar Mani +91 81975 99922=20 W: https://dbatocloudsolution.blogspot.in/ = | E: dbatocloud17@gmail.com = =20 =20 =20 =20 =20 On Sun, Nov 7, 2021 at 8:08 PM Firthouse banu > wrote: I have done it in my previous project . Yes it=E2=80=99s difficult and = time taking process . Because some features which is in oracle will not = be working for Postgres. We need to find the equivalent of it and change = code .=20 I have used AWS schema conversion tool to converts complete schema as it = will not do your complete job some changes needs to be done = manually=E2=80=A6.=20 =20 Thanks Firthouse =20 On Sun, 7 Nov 2021 at 9:28 PM, dbatoCloud Solution = > wrote: Hi Team I want to migrate Oracle PL/SQL code to PostgreSQL pg/sql code.=20 Could you please let me know if someone has done it? if yes then what = kind of challenges do we need to face it?=20 =20 Thanks Ashok ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Ashokkumar Mani +91 81975 99922=20 W: https://dbatocloudsolution.blogspot.in/ = | E: dbatocloud17@gmail.com = =20 =20 =20 ------=_NextPart_000_006D_01D7D3FD.4F8A2880 Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: quoted-printable

You can use ora2pg which can do a = lot for you (https://ora2pg.darold.net/s= tart.html).

 

But this doesn=E2=80=99t mean that = all will be automatic. You have to recheck PL/pgSQL code generated by = the tool. This is necessary because of the difference of functionalities = between Oracle and PostgreSQL. If you have a lot of PL/SQL code, this = will not be a little task. Anyway, application code is on your = charge.

 

Best = regards

Michel = SALAIS

De : dbatoCloud Solution = <dbatocloud17@gmail.com>
Envoy=C3=A9 : dimanche 7 = novembre 2021 17:15
=C3=80 : Firthouse banu = <penguinsfairy@gmail.com>
Cc : = pgsql-admin@postgresql.org
Objet : Re: Looking for help = to migrate Oracle PL SQL code to PGSQL code

 

H= i Firthouse banu

 

C= an you please share your experience of migrating oracle code to = postgresql ? I mean the steps and overview which would be = great.

 

 <= /o:p>

Thanks=

Ashok<= /o:p>

~~~~~~~~~~~~~~~~~~= ~~~~~~~~~~~~~~~~~~~~

As= hokkumar Mani

&n= bsp;+91 81975 99922 

W: https://dbatocloudsolution.blogspot.in/ = | E: = dbatocloud17@gmail.com

 <= /o:p>

 <= /o:p>

 

 

On = Sun, Nov 7, 2021 at 8:08 PM Firthouse banu <penguinsfairy@gmail.com> = wrote:

I = have done it in my previous project . Yes it=E2=80=99s difficult and = time taking process . Because some features which is in oracle will not = be working for Postgres. We need to find the equivalent of it and change = code . 

I have used = AWS schema conversion tool to converts complete schema as it will not do = your complete job some changes needs to be done = manually=E2=80=A6. 

 

Thanks

Firthouse

 

On = Sun, 7 Nov 2021 at 9:28 PM, dbatoCloud Solution <dbatocloud17@gmail.com> = wrote:

H= i Team

I= want to migrate Oracle PL/SQL code to PostgreSQL pg/sql = code. 

C= ould you please let me know if someone has done it? if yes then = what kind of challenges do we need to face it? 

 <= /o:p>

Thanks=

Ashok<= /o:p>

~~~~~~~~~~~~~~~~~~= ~~~~~~~~~~~~~~~~~~~~

As= hokkumar Mani

&n= bsp;+91 81975 99922 

W: = https://dbatocloudsolution.blogspot.in/ = | E: = dbatocloud17@gmail.com

 <= /o:p>

 <= /o:p>

------=_NextPart_000_006D_01D7D3FD.4F8A2880--