?
Solved

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

Posted on 2012-04-11
10
Medium Priority
?
1,860 Views
Last Modified: 2012-04-12
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?
0
Comment
Question by:thelink12
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
  • 3
  • +1
10 Comments
 
LVL 10

Assisted Solution

by:Subhashish Laha
Subhashish Laha earned 400 total points
ID: 37833259
0
 
LVL 10

Expert Comment

by:Subhashish Laha
ID: 37833266
Backup your SQL database first before upgrading the Database.
0
 

Author Comment

by:thelink12
ID: 37833367
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
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 
LVL 3

Expert Comment

by:unsatiated
ID: 37833517
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
 
LVL 10

Expert Comment

by:Subhashish Laha
ID: 37833556
Go through below article, this is related to your query and will help you out

http://communities.vmware.com/thread/345105
0
 
LVL 123
ID: 37833740
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
 

Author Comment

by:thelink12
ID: 37833793
I am confused.  The interoperability guide says that SQL 2005 express does not work with 5.0.
0
 
LVL 123
ID: 37833802
Its wrong!

its not supported, not supported and work are two very different things.
0
 
LVL 123

Accepted Solution

by:
Andrew Hancock (VMware vExpert / EE MVE^2) earned 1600 total points
ID: 37834107
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
 

Author Closing Comment

by:thelink12
ID: 37837583
Excellent.  Thank you for your help!
0

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this step by step tutorial with screenshots, we will show you HOW TO: Enable SSH Remote Access on a VMware vSphere Hypervisor 6.5 (ESXi 6.5). This is important if you need to enable SSH remote access for additional troubleshooting of the ESXi hos…
In this article, I will show you HOW TO: Create your first Windows Virtual Machine on a VMware vSphere Hypervisor 6.5 (ESXi 6.5) Host Server, the Windows OS we will install is Windows Server 2016.
Teach the user how to convert virtaul disk file formats and how to rename virtual machine files on datastores. Open vSphere Web Client: Review VM disk settings: Migrate VM to new datastore with a thick provisioned (lazy zeroed) disk format: Rename a…
Teach the user how to use vSphere Update Manager to update the VMware Tools and virtual machine hardware version Open vSphere Client: Review manual processes for updating VMware Tools and virtual hardware versions: Create a new baseline group in vSp…
Suggested Courses

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question