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

help / color / mirror / Atom feed

From: Michel SALAIS <msalais@msym.fr>
To: 'dbatoCloud Solution' <dbatocloud17@gmail.com>
To: 'Firthouse banu' <penguinsfairy@gmail.com>
Cc: pgsql-admin@postgresql.org
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> (raw)
In-Reply-To: <CAEz7P_tLi4DKJLV_W8GCYXf+c_dx5n+z+nvyH9mmhthVmi6=mg@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>

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

 

But this doesn’t 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é : dimanche 7 novembre 2021 17:15
À : Firthouse banu <penguinsfairy@gmail.com>
Cc : pgsql-admin@postgresql.org
Objet : Re: Looking for help to migrate Oracle PL SQL code to PGSQL code

 

Hi Firthouse banu

 

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

 

 

Thanks

Ashok

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Ashokkumar Mani

 +91 81975 99922 

W: https://dbatocloudsolution.blogspot.in/ <http://dbatocloudsolution.blogspot.in/;  | E: dbatocloud17@gmail.com <mailto:dbatocloud17@gmail.com> 

 

 

 

 

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

I have done it in my previous project . Yes it’s 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…. 

 

Thanks

Firthouse

 

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

Hi Team

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

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

 

Thanks

Ashok

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Ashokkumar Mani

 +91 81975 99922 

W: https://dbatocloudsolution.blogspot.in/ <http://dbatocloudsolution.blogspot.in/;  | E: dbatocloud17@gmail.com <mailto:dbatocloud17@gmail.com> 

 

 

view thread (6+ messages)  latest in thread

Message-ID: <006c01d7d3f4$edc2da50$c9488ef0$@msym.fr>
Permalink:  ../006c01d7d3f4$edc2da50$c9488ef0$@msym.fr/
Also on:    postgresql.org/message-id/006c01d7d3f4$edc2da50$c9488ef0$@msym.fr

copy link · copy postgr.es

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: msalais@msym.fr, dbatocloud17@gmail.com, penguinsfairy@gmail.com
  Subject: RE: Looking for help to migrate Oracle PL SQL code to PGSQL code
  In-Reply-To: <006c01d7d3f4$edc2da50$c9488ef0$@msym.fr>

* 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