Skip to main content
reca
reca
Gold ⭐️
September 29, 2021
Solved

Is it possible to migrate the Postgres db to Oracle for Cloudera 5.13.3?

I have a cluster that uses a Postgres db with version 9.4.17 installed on a host in the cluster and I want to migrate to an external Oracle db. I have researched about the methods to do this in Cloudera documentations and I found that I have to have a Cloudera version higher than 5.15. Would it make any difference if we do the migration using Cloudera 5.13? what could be the differences between 5.13 and 5.15 in terms of db?

 

"""Configuration uses Cloudera Manager 5.15.0 or later on supported platforms."""

https://docs.cloudera.com/documentation/enterprise/6/6.3/topics/cm_ag_migrate_postgres_db_to_oracle_mysql.html

 

 

GangWar
GangWarAnswer
Platinum ⭐️⭐️
October 1, 2021

@reca This should work. The Oracle Database earlier versions are supported for C5.13. Please see the support matrix here. 

https://docs.cloudera.com/documentation/enterprise/6/6.3/topics/cm_ag_migrate_postgres_db_to_oracle_mysql.html

 

Once you decide the Oracle DB version you can just follow this guide for migrating a Postgres DB to Oracle. 

https://docs.cloudera.com/documentation/enterprise/6/6.3/topics/cm_ag_migrate_postgres_db_to_oracle_mysql.html

Cheers! Was your question answered? Make sure to mark the answer as the accepted solution. If you find a reply useful, say thanks by clicking on the thumbs up button.
View in thread

3 replies

GangWar
Platinum ⭐️⭐️
GangWarAnswer
Platinum ⭐️⭐️
October 1, 2021

@reca This should work. The Oracle Database earlier versions are supported for C5.13. Please see the support matrix here. 

https://docs.cloudera.com/documentation/enterprise/6/6.3/topics/cm_ag_migrate_postgres_db_to_oracle_mysql.html

 

Once you decide the Oracle DB version you can just follow this guide for migrating a Postgres DB to Oracle. 

https://docs.cloudera.com/documentation/enterprise/6/6.3/topics/cm_ag_migrate_postgres_db_to_oracle_mysql.html

Translate
Cheers! Was your question answered? Make sure to mark the answer as the accepted solution. If you find a reply useful, say thanks by clicking on the thumbs up button.
salpeyton
salpeyton
Silver ⭐️
October 4, 2021
@GangWar wrote:

@reca This should work. The Oracle Database earlier versions are supported for C5.13. Please see the support matrix here. 

https://docs.cloudera.com/documentation/enterprise/6/6.3/topics/cm_ag_migrate_postgres_db_to_oracle_mysql.html

png to ico

Once you decide the Oracle DB version you can just follow this guide for migrating a Postgres DB to Oracle. 

https://docs.cloudera.com/documentation/enterprise/6/6.3/topics/cm_ag_migrate_postgres_db_to_oracle_mysql.html

Thanks for the info, much appreciated!

Translate
Terms & ConditionsAccessibility statement