[Company Logo Image] 

Home Up Contents Coffee Break Credits Glossary Links Search

 
Upgrading One Edition To Another Edition

 

 

Home
Analysis Services
Azure
CLR Integration
High Availability
Open Source
Security
SQL Server 2008
SQL Server 2012
SQL Server 2014
SQL Server 2016
Tips
Troubleshooting
Tuning

Upgrading one edition of Microsoft SQL Server 2008 to Another Edition of SQL Server 2008


There are two options for upgrading to a different edition of SQL Server 2008:

1) Use the Edition Upgrade Wizard from the SQL Server installation media. See this link for step-by-step instructions

2) Run setup from the command prompt with the SKUUPGRADE=1 parameter. See this article for more information.

The following is an example of the second option:

D:\SQL Server x86\Servers>setup.exe ADDLOCAL=SQL_Engine INSTANCENAME=MSSQLSERVER UPGRADE=SQL_Engine SKUUPGRADE=1 /qb

Parameters are case sensitive.

All service packs and cumulative updates you have installed prior to the upgrade need to be installed again.


References.


How to: Install SQL Server 2008 from the Command Prompt

How to: Upgrade to a Different Edition of SQL Server 2008 (Setup)

Version and Edition Upgrades
 

 

 

.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.