Migrating external Full SQL 2008 database to local 2012 Express database

[dfranciscus]

Hi all,

We currently use an external SQL 2008 database with our Vcenter 5.5 on Windows server. Since SQL 2008 is not compatible with Vcenter 6, I would like to actually move the vcenter and UM databases from this external database to a local SQL 2012 express instance on the Vcenter VM. I tried this a few days ago and while moving and attached the databases worked, after migrating I had a big issue with a few instances of java.exe taking up all my CPU on the vcenter server.

I tried changing the java heap on vcenter but it did not seem to make a difference. I had to restore my old vcenter VM from a backup.

Most of the articles I have found are about trying to do the opposite (local SQL to external SQL) but I have not found anything about doing external to local. Is moving an external SQL databses to local supported?

Any help would be appreciated.

[vHaridas]

Hi,

vCenter 6 usages embedded PostgreSQL database and it does support SQL 2008 Diabase also.

Refer vCenter Database interoperability matrixes. VMware Product Interoperability Matrixes

if you use SQL express then it would be replaced by PostgreSQL during vCenter upgrade to 6.

About moving DB to express edition, I think steps would be similar to moving DB to external SQL server, However you will not have any agent jobs in sql express.

https://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=10286...

[dfranciscus]

I received a message during the upgrade stating it did not support my database (SQL 2008), which is why I am attempting to migrate the database.

I followed that guide and while it seemed to work I ran into the java.exe issue afterwards. I have to believe it has something to do with having the database local now and/or having SQL 2012 express installed.

[vHaridas]

do you have vpxd.log logs when you had migrated DB to express.

This blog also clarifies that SQL 2008 is supported.

vSphere 6 - Clarifying the misinformation - VMware vSphere Blog - VMware Blogs

have you installed SQL 2008 SP2?

what error you get during upgrade of vCenter 6? can you post installation logs.