VMware Cloud Community
Mike2020
Contributor
Contributor

How to convert vCenter Database from Oracle 11g to SQL Server 2008 R2?

Hello All,

We currently have our vCenter application on Oracle 11g database and we want it moved to a SQL Server 2008 R2 database. We have an application front-end and database back-end configure. Both of the systems are on Windows Server 2008 R2 Enterprise OS.  Our plan was to install VCenter 5.0 on the SQL Server 2008 R2 database in order to get all the objects (tables, Stored procedures, and views). Once that was done we purge all the records from the tables keeping the relationships and constraints intact. Then we populated all the tables from Oracle 11g database to SQL Server 2008 R2 database via SSIS package. We were able to open the vCenter 5.0 in the SQL Server database environment but nothing shows up under the Inventory. Does anyone know what could be the issue? Do we need to move files from the Oracle database environment?


Thanks.

Reply
0 Kudos
0 Replies