asked on

vCenter 5.5 SQL 2008 Express in-place Upgrade to 2008 Standard

Hi, I have been scouring the web for an inplace upgrade of SQL 2008 express to standard, the instance holds the vcenter database and update manager database. Is it simple to follow this link for the edition to be upgraded from Express to Standard ?

https://blogs.msdn.microsoft.com/petersad/2011/01/24/how-to-perform-an-sql-server-edition-upgrade/

ASKER CERTIFIED SOLUTION

Andrew Hancock (VMware vExpert PRO / EE Fellow/British Beekeeper)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ExchangeKB

ASKER

Thanks Andrew, the server is a physical server 2008 r2 server which till date hasn't been backed up at all. Should the vmware services be stopped when running the upgrade, I was seeing the vmware kb https://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=1028601

Should any of the steps listed in the kb be followed pre or post upgrade ?

Andrew Hancock (VMware vExpert PRO / EE Fellow/British Beekeeper)

I would stop vCenter Server and related services, whilst you upgrade.

ExchangeKB

ASKER

Thanks, will be running this soon, fingers crossed. Wonder why vmware kb involves complex steps of backing up and restore db even for in place upgrades like express to standard.

ExchangeKB

ASKER

Just want to check if this is the same if upgrading from SQL 2008 Express to SQL 2012 Standard ?

Andrew Hancock (VMware vExpert PRO / EE Fellow/British Beekeeper)

do you require any additional help to close this question?

ExchangeKB

ASKER

thanks Andrew, the in place upgrade worked a treat.