https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-migrate-Ambari-DB-from-postgres-to-Oracle/m-p/94636#M7931 <P>I would strongly recommend customers to involve Oracle DBA for this.</P> Sun, 04 Oct 2015 17:30:29 GMT pardeep_kumar 2015-10-04T17:30:29Z https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-migrate-Ambari-DB-from-postgres-to-Oracle/m-p/94634#M7929 Thu, 01 Oct 2015 00:52:01 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-migrate-Ambari-DB-from-postgres-to-Oracle/m-p/94634#M7929 pardeep_kumar 2015-10-01T00:52:01Z https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-migrate-Ambari-DB-from-postgres-to-Oracle/m-p/94635#M7930 <OL> <LI>Setup Oracle schema using <A href="http://docs.hortonworks.com/HDPDocuments/Ambari-2.1.1.0/bk_ambari_reference_guide/content/_using_ambari_with_oracle.html">link</A></LI><LI>CSV dump of postgres tables. <A href="http://stackoverflow.com/questions/1120109/export-postgres-table-to-csv-file-with-headings">example</A></LI><LI><A href="http://stackoverflow.com/questions/1120109/export-postgres-table-to-csv-file-with-headings"></A>use oracle sqlldr to load data into oracle table</LI></OL><P>Or You can try <A href="http://www.postgresql.org/about/news/1496/">this </A></P> Thu, 01 Oct 2015 01:05:39 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-migrate-Ambari-DB-from-postgres-to-Oracle/m-p/94635#M7930 nsabharwal 2015-10-01T01:05:39Z https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-migrate-Ambari-DB-from-postgres-to-Oracle/m-p/94636#M7931 <P>I would strongly recommend customers to involve Oracle DBA for this.</P> Sun, 04 Oct 2015 17:30:29 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-migrate-Ambari-DB-from-postgres-to-Oracle/m-p/94636#M7931 pardeep_kumar 2015-10-04T17:30:29Z https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-migrate-Ambari-DB-from-postgres-to-Oracle/m-p/94637#M7932 <P>How to Migrate Ambari DB from Postgress to MYSQL? tried <A href="https://hortonworks.my.salesforce.com/kA0E0000000fy7d">https://hortonworks.my.salesforce.com/kA0E0000000fy7d</A></P><P>But when I source /tmp/ambari.sql , Its failing with syntax errors . Tried using Mysql workbench But 19 tables got affected.</P><P>Thanks,</P><P>Siva.</P> Wed, 04 May 2016 11:23:11 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-migrate-Ambari-DB-from-postgres-to-Oracle/m-p/94637#M7932 spadidam 2016-05-04T11:23:11Z