Moving vCenter Database from SQL Express to SQL 2005

[MKrantz]

I am trying to find the procedures for moving the vCenter databse from SQL Express to SQL 2005 on a new server. Anyone have any info? Anyone have any first hand experience with this?

[MauroBonder]

i found any KB´s with proceduce, check what apply for you

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

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

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

hope help

good luck

Please, don't forget the awarding points for "helpful" and/or "correct" answers.  

Mauro Bonder - Moderator

[AndreTheGiant]

Follow the KB.

Basically you have to move the DB (this can be done with Management Studio) and change the ODBC connection.

Andre

[MKrantz]

So the ODBC connection from the vCenter to the SQL server is all that needs to be changed to let vCenter know where the database has moved to?

[Troy_Clavell]

MKrantz wrote:

So the ODBC connection from the vCenter to the SQL server is all that needs to be changed to let vCenter know where the database has moved to?

Yes.  Once the DB has been moved, just update you ODBC connections