Re: [External] : Oracle to postgresql migration steps.
- From: Mladen Gogala <gogala.mladen@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 08 Feb 2024 17:16:51 -0500
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
Other related posts: