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

I am not particularly thrilled by the AWS schema conversion tool, because it requires AWS username. Also, the documentation could use improvement. Personally, I use ora2pg (https://github.com/darold/ora2pg) It does require visual inspection of the resulting SQL file because ora2pg doesn't always select the right data type. For data, I usually use some kind of replication, Golden Gate or SharePlex. I usually have to rewrite PL/SQL code myself.

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


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