SQL Server – Upgrading Edition

Background

Needing to upgrade SQL Server from Standard to Enterprise.

 

Script

Though this is do-able through GUI, I prefer to use script and do so from the command line.

Outline

  1. Options
    • /q
      • Specifies that Setup runs in a quiet mode without any user interface.
      • This is used for unattended installations.
    •  /IACCEPTSQLSERVERLICENSETERMS
      • Required to acknowledge acceptance of the license terms
    • /ACTION
      • Required to indicate the installation workflow. Supported values:
        • editionupgrade
    • /INSTANCENAME
      • Instance Name
        • For Default Instance, please specify MSSQLSERVER
    • /PID
      • Product Key
        • Please specify the Product Key

Sample Script

Here is a sample script:


REM Setup.exe /q /ACTION=editionupgrade /INSTANCENAME=<MSSQLSERVER or instancename> /PID=<PID key for new edition>" /IACCEPTSQLSERVERLICENSETERMS

REM Set Instance Name
set _instance=MSSQLSERVER

REM Specifies the product key for the edition of SQL Server
set _ProductKey=

REM Set Location of Install Media
rem set _setupLocation=F:
set _setupLocation=C:\Downloads\Microsoft\SQLServer\v2014\RTM\SQL2014Ent\Extract

"%_setupLocation%\Setup.exe" /q /IACCEPTSQLSERVERLICENSETERMS /ACTION=editionupgrade /INSTANCENAME=%_instance% /PID=%_ProductKey% 

 

Note

  1. Please edit and ensure that ProductKey is entered in _ProductKey

 

GUI

If you are a GUI person, here are your screen shots.

  1. Run setup.exe
    • Screens
      • Window – SQL Server Installation Center
        • On the “SQL Server Installation Center” window, access the “Maintenance” Tab
        • In the Maintenance Tab, select the “Edition Upgrade” button
      • Window – Upgrade the Edition for SQL Server 2014
        • On the “Product Key” window
          • Enter or validate the Product Key
        • On the “License Terms” window
          • Accept the Licensing terms, by clicking on the check-box
        • On the “Global Rules” window
          • The setup application iterates through pre-requisite Checklist
        • On the “Edition Upgrade Rules” window
          • The setup binary goes through check that are pertinent for that edition
            • Is Computer a Domain Controller?
            • Is Service Disabled
            • Is machine/SQL Instance configured for AWE
            • Is Service Account enabled for Lock Pages in memory ( LPIM)
        • On the “Select Instance” window
          • Please choose the SQL Instance to upgrade
        • On the “Feature Rules” window
        • On the “Ready to Upgrade” window
          • Review your choices
          • Make a note of configurationFile.ini
          • Click the upgrade button
        • On the “Complete” window
          • Review the results of the upgrade

Images

Maintenance

Upgrade the Edition for SQL Server 2014 – Product Key

Upgrade the Edition for SQL Server 2014 – License Terms

Upgrade the Edition for SQL Server 2014 – Global Rules

 

Upgrade the Edition for SQL Server 2014 – Edition Upgrade Rules

Upgrade the Edition for SQL Server 2014 – Select Instance

 

Upgrade the Edition for SQL Server 2014 – Feature Rules

Upgrade the Edition for SQL Server 2014 – Ready to upgrade edition

 

References

  1. Developer Network
    • SQL Server 2016 Technical Documentation SQL Server Installation  Install SQL Server 2016
      Link

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s