VMware Cloud Community
sw1982
Contributor
Contributor
‎12-05-2013 02:22 AM

SQL 2008 R2 Express to SQL 2010 Standard upgrade

Hello

I have out grown SQL express edition and have purchased SQL 2012 Standard edition. Can someone offer some guidance on how I can upgrade my vCenter server from 2008 R2 Standard to 2012 Standard? I want to use the same server.

I have been advised that I have a compatible version of VMWare etc.

Many thanks

Tags (3)
0 Kudos
5 Replies
admin
Immortal
Immortal
‎12-05-2013 02:29 AM

I have out grown SQL express edition and have purchased SQL 2012 Standard edition.

Refer the KB article: VMware KB: Migrating the vCenter Server database from SQL Express to full SQL Server

~dGeorgey

0 Kudos
sw1982
Contributor
Contributor
‎12-05-2013 02:45 AM

Thanks.  Do I uninstall the old version of SQL before installing the new version?

0 Kudos
raog
Expert
Expert
‎12-06-2013 12:06 AM

Stop the old DB service. Are you planning on using the same machine as VC for the new SQL installation?

Regards

Girish

To Virtualization and beyond! PS::If you felt the answer as helpful, please mark it as helpful/answered so that it helps other users as well! Blog:: www.virtualtipsntricks.com
0 Kudos
sw1982
Contributor
Contributor
‎12-06-2013 12:53 AM

Same machine - anything else I need to be aware of?

Thanks

0 Kudos
sw1982
Contributor
Contributor
‎12-09-2013 04:43 AM

Hello,

A couple of questions:

a) I have databases called RSA, VIM_UMDB & VIM_VCDB - do I need to move all of these?

b) What features should I install when installing SQL 2012?

Thanks

0 Kudos