Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

How to migrate Ambari DB from postgres to Oracle?

avatar
 
1 ACCEPTED SOLUTION

avatar
Master Mentor
  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

View solution in original post

3 REPLIES 3

avatar
Master Mentor
  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

avatar

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

avatar
Explorer

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.