Re: Oracle DB migration to Postgrsql

  • From: Karthikeyan Panchanathan <keyantech@xxxxxxxxx>
  • To: "shravankota@xxxxxxxxx" <shravankota@xxxxxxxxx>, "gogala.mladen@xxxxxxxxx" <gogala.mladen@xxxxxxxxx>
  • Date: Fri, 14 Apr 2023 10:18:53 +0000

There are couple of options.

I would start from  https://ora2pg.darold.net/start.html

HTH
Karth



Sent from Outlook for iOS<https://aka.ms/o0ukef>
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> on behalf 
of Shravan Kumar Kota <shravankota@xxxxxxxxx>
Sent: Friday, April 14, 2023 1:40:04 AM
To: gogala.mladen@xxxxxxxxx <gogala.mladen@xxxxxxxxx>
Cc: Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>
Subject: Re: Oracle DB migration to Postgrsql

Any one can help me on this please .

On Thu, Apr 13, 2023, 08:22 Shravan Kumar Kota 
<shravankota@xxxxxxxxx<mailto:shravankota@xxxxxxxxx>> wrote:
Hello Mladen,

Thanks you for your reply.

I didn't understand what you are saying.

You mean to say that we need to take help from developer while migrating 
database ?

Thanks.
Shravan.

On Thu, Apr 13, 2023, 07:49 Mladen Gogala 
<gogala.mladen@xxxxxxxxx<mailto:gogala.mladen@xxxxxxxxx>> wrote:
On 4/12/23 10:08, Shravan Kumar Kota wrote:

Hi all ,

Is any one done migration of Oracle database to Postgrsql?
Yes

If yes please let me know process / steps to do it or if any doc or url please 
share with me.

Thanks
Shravan.

LOL! The above message exudes a rare degree of self-confidence! The knowledge 
you refer to is something that I sell. However, even if if you somehow got my 
part of knowledge, you would still need the developer's side of the story. The 
developers were in charge of the application. I was only helping them with both 
databases. Remember: as a DBA you are a SME for everything database. The trick 
is in learning both.

--
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com

Other related posts: