VMware Cloud Community
JDReal
Contributor
Contributor

How to migrate vcenter server 5.5 database from vPostgresql to oracle database ?

Hello everyone,

     I'm running a vcenter server 5.5  with  embedded database -- vpostgresql. This vcenter has been used for almost a year. Now  I want to use oracle database 11.2.0.4 ,how can i do it?

     I hava already prepared a oracle database ( Use a Script to Create the Oracle Database Schema ).

     What's next ? How to migrate the data from postgresql to oracle ?

     Thank you very much.

Tags (2)
0 Kudos
2 Replies
RajeevVCP4
Expert
Expert

Ora2Pg is a free tool used to migrate an Oracle or MySQLdatabase to a PostgreSQL compatible schema. ... Ora2Pg can be used from reverse engineering Oracle database to huge enterprise database migration or simply to replicate some Oracle data into a PostgreSQL database

Rajeev Chauhan
VCIX-DCV6.5/VSAN/VXRAIL
Please mark help full or correct if my answer is use full for you
0 Kudos
Raj1988
Enthusiast
Enthusiast

VC 5.5 is already end of support .

VMware has no supported way of migrating from vpostgres to oracle DB .

https://dbconvert.com/postgresql/oracle/

0 Kudos