Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

In place Upgrade SQL 2008 Express to SQL 2012 Standard for vCenter

Posted on 2016-11-15
12
Medium Priority
?
225 Views
Last Modified: 2016-11-17
If I want to in place upgrade SQL Server 2008 Express to SQL Server 2012 Standard, is it just stop vCenter services and insert SQL 2012 Standard install and perform the upgrade of the vCenter SQL Express database instance, or should I upgrade 2012 Express and then again perform a Edition upgrade to SQL 2012 Standard.
0
Comment
Question by:ExchangeKB
  • 3
  • 3
  • 2
  • +2
12 Comments
 
LVL 24

Assisted Solution

by:Luciano Patrão
Luciano Patrão earned 500 total points
ID: 41887716
Hi,

Yes you can upgrade directly to 2012.

Here you can see the upgrade level:

https://technet.microsoft.com/en-us/library/ms143393(v=sql.110).aspx

Maybe some information how to:

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

Regarding vCenter, yes you need to stop all vCenter services before the upgrade.

Jail
0
 
LVL 125

Assisted Solution

by:Andrew Hancock (VMware vExpert / EE MVE^2)
Andrew Hancock (VMware vExpert / EE MVE^2) earned 500 total points
ID: 41887758
and make sure you take a full backup of vCenter Server and/or SQL database, should you need to roll back.

Also this was completed by a recent EE Member, and it FAILED!

e.g. vCenter Server has now been broken since the SQL in place upgrade.
1
 
LVL 7

Expert Comment

by:Andy
ID: 41887830
If it's a VM SQL server, take a snapshot first aswell as the other backups.
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 125
ID: 41887914
I would not recommend a Snapshot, a VM running on a snapshot causes poor performance.
0
 
LVL 7

Expert Comment

by:Andy
ID: 41887927
Although not recommended, I've done it many times with no noticeable issues.
0
 
LVL 27

Expert Comment

by:Zberteoc
ID: 41887938
Why not install the SQL 2012 from scratch and then migrate the databases using backup/restore?
0
 
LVL 24

Expert Comment

by:Luciano Patrão
ID: 41888089
@Andrew you are right, I forget to mention that part. Always do a proper Backup of the SQL and vCenter before the upgrade.

@Zberteoc yes is the proper way. But for vCenter then you need to do same changes. Is not just backup/restore to the new SQL Server. In vCenter needs some configurations change.

So since new vCenter versions are pointing to VCSA and embedded Postgres DB, in the future maybe no need for SQL.
0
 
LVL 3

Author Comment

by:ExchangeKB
ID: 41889981
@Luciano  Just to confirm the upgrade level I can upgrade SQL 2008 R2 SP1 Express to SQL 2012 Standard SP3, does the service pack level matter ?
0
 
LVL 27

Assisted Solution

by:Zberteoc
Zberteoc earned 1000 total points
ID: 41890055
You have to upgrade to SQL 2012 first and then in second step you install SP3.
0
 
LVL 3

Author Comment

by:ExchangeKB
ID: 41890096
Thanks Zberteoc

Can you point me to a step by step of inplace  upgrade of SQL 2008 R2 Express  to SQL 2012 Standard, the link previously is just a edition upgrade from 2008 express to standard.
0
 
LVL 27

Accepted Solution

by:
Zberteoc earned 1000 total points
ID: 41891480
This should do it. The fact that yours is EXPRESS doesn't matter:

https://www.youtube.com/watch?v=d2SE46xaKYE
0
 
LVL 24

Expert Comment

by:Luciano Patrão
ID: 41891572
Hi

In My initial reply you have both answers. If is possible to upgrade and how to upgrade.

Service pack are always apply after the initial upgrade, or SQL install.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

578 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