How to migrate Ambari DB from postgres to Oracle?

[#1 · Accepted solution]

1. Setup Oracle schema using link
2. CSV dump of postgres tables. example
3. use oracle sqlldr to load data into oracle table

Or You can try this

[#2]

I would strongly recommend customers to involve Oracle DBA for this.

[#3]

How to Migrate Ambari DB from Postgress to MYSQL? tried https://hortonworks.my.salesforce.com/kA0E0000000fy7d

But when I source /tmp/ambari.sql , Its failing with syntax errors . Tried using Mysql workbench But 19 tables got affected.

Thanks,

Siva.