Re: Oracle DB migration to Postgrsql

From: Karthikeyan Panchanathan <keyantech_at_gmail.com>
Date: Fri, 14 Apr 2023 10:18:53 +0000
Message-ID: <CO6P220MB0610E54E8BFA7CA0151D5A56FF999_at_CO6P220MB0610.NAMP220.PROD.OUTLOOK.COM>



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_at_freelists.org <oracle-l-bounce_at_freelists.org> on behalf of Shravan Kumar Kota <shravankota_at_gmail.com> Sent: Friday, April 14, 2023 1:40:04 AM
To: gogala.mladen_at_gmail.com <gogala.mladen_at_gmail.com> Cc: Oracle-L Freelists <oracle-l_at_freelists.org> 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_at_gmail.com<mailto:shravankota_at_gmail.com>> 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_at_gmail.com<mailto:gogala.mladen_at_gmail.com>> 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

--

http://www.freelists.org/webpage/oracle-l Received on Fri Apr 14 2023 - 12:18:53 CEST

Original text of this message