Re: Oracle DB migration to Postgrsql

AWS has a free tool:

https://aws.amazon.com/dms/schema-conversion-tool/ https://docs.aws.amazon.com/SchemaConversionTool/latest/userguide/CHAP_Installing.html

It doesn't do everything (what does?) but it is super helpful.

Jeremiah

On Thu, Apr 13, 2023 at 10:40 PM Shravan Kumar Kota <shravankota_at_gmail.com> wrote:

> Any one can help me on this please .
>
> On Thu, Apr 13, 2023, 08:22 Shravan Kumar Kota <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>
>> 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-1217https://dbwhisperer.wordpress.com
>>>
>>>
> CAUTION: This email originated from outside of the organization. Do not
> click links or open attachments unless you recognize the sender and know
> the content is safe.
>
>

--
http://www.freelists.org/webpage/oracle-l