Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

How to migrate Ambari DB from postgres to Oracle?

Solved Go to solution
Highlighted

How to migrate Ambari DB from postgres to Oracle?

 
1 ACCEPTED SOLUTION

Accepted Solutions

Re: How to migrate Ambari DB from postgres to Oracle?

  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

3 REPLIES 3

Re: How to migrate Ambari DB from postgres to Oracle?

  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

Re: How to migrate Ambari DB from postgres to Oracle?

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

Re: How to migrate Ambari DB from postgres to Oracle?

New Contributor

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.

Don't have an account?
Coming from Hortonworks? Activate your account here