Inplace upgrade of vCenter Server from 4.1 to 5 and SQL Express

I have an existing installation of vCenter Server 4.1.xxx.  I am looking to do an inplace uprade to version 5.0.  Its a small environment and the database I am using is SQL Express 2005.  If I use the vCenter Server install Wizard it tells me I need to upgrade the database.  Will that automatically upgrade SQL Express 2005 to 2008?
thelink12Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Subhashish LahaCommented:
0
Subhashish LahaCommented:
Backup your SQL database first before upgrading the Database.
0
thelink12Author Commented:
I have seen that article, I am looking to find out if the install process will upgrade SQL 2005 to 2008 or if the the author already did that as part of the article.  THe author states that he is running version 4.1 but not if the database is 2005 or 2008.
0
Acronis True Image 2019 just released!

Create a reliable backup. Make sure you always have dependable copies of your data so you can restore your entire system or individual files.

unsatiatedCommented:
If you are running a 32bit OS, you cannot perform an in-place upgrade and will have to migrate the database using the follow procedure.

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

Even if you have a 64bit OS, 2005 SQLExpress is not supported and you will have to backup the SQL2005 database and restore it into the newly created SQL2008 express instance.
0
Subhashish LahaCommented:
Go through below article, this is related to your query and will help you out

http://communities.vmware.com/thread/345105
0
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
We complete inplace upgrades for clients from vCenter 4.1 to 5.0.

The installation wizard detects an existing version of vCenter and upgrades.

No upgrade is performed to SQL Express 2008. SQL Express 2005 is left.

The database is upgraded to work with vCenter 5.0.

It is true if you read Pages 32 of the Upgrade it states SQL Express 2005 - Not Supported.

But that does not mean it does not function and work.

Its a shame the installation does not warn in v5.0, this could have changed in v5.0 u1
0
thelink12Author Commented:
I am confused.  The interoperability guide says that SQL 2005 express does not work with 5.0.
0
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
Its wrong!

its not supported, not supported and work are two very different things.
0
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
Okay, here are some screenshots from our vCenter 5.0 installation, which was an in-place upgrade ontop of vCenter 4.1. (SQL Express 2005)

It works satisfactorily, like all our client sites, which know, it's not officially supported by VMware, if there was an issue with vCenter, which you have to have a seperate support contract, ontop of the ESXi servers support contract.

Our clients decided, they would test on SQL Express 2005, and if there were any issues with vCenter 5.0, they would then proceed with an SQL Express 2008 installation, but for them it was little risk, versus the effort, of installing new SQL Express 2008, and then compelting upgrade due to timescales.

SQLExpress2005-1.jpg
SQLExpress2005-2.jpg
SQLExpress2005-3.jpg
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
thelink12Author Commented:
Excellent.  Thank you for your help!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
VMware

From novice to tech pro — start learning today.