Re: [External] : Oracle to postgresql migration steps.

On Thu, 2024-02-08 at 09:18 -0800, Jeremiah Cetlin Wilton wrote:
> Hi Shravan,
>
> Well obviously there have been some VERY helpful responses here so far,
> so I can probably only help a little more.
>
> Here is a nice little tool you can use for free, and you're not obligated
> at all to use AWS as a target. Cross-database-type migrations are complex
> and have many moving parts, but this tool can get you off of square one.
>
> https://aws.amazon.com/dms/schema-conversion-tool/
>
> Thanks
>
> Jeremiah
>

Well, I am not a big fan of the tool, primarily because it requires AWS profile to work. My task is to help migrate an OLTP application which runs on top of Oracle to an application running on top of PostgreSQL 16.x database. I don't want to worry about AWS during that migration. I usually use ora2pg (https://github.com/darold/ora2pg) That is a bit more work, but is rather reliable for creating the schema. The output SQL file should be inspected in order to ensure that all the data types are correct.

-- 
Mladen Gogala
Database SME
https://dbwhisperer.wordpress.com


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