Upgrade SQL Express to SQL Standard

If you'd like to upgrade a SQL Express instance to a SQL Standard instance via an in place upgrade, it's nice and easy to do through the inbuilt wizard within the SQL Setup GUI.

  1. Select Edition Upgrade from the Maintenance menu
    image2021-2-9-15_6_47
  2. Click Next
    Edition-upgrade-2008-R2-2
  3. Enter the SQL product key
    image2021-2-9-15_9_11
  4. Accept the license terms
    image2021-2-9-15_10_31
  5. Select the required instance (Usually MSSQLSERVER)
    image2021-2-9-15_21_51
  6. Click Next
    image2021-2-9-15_23_7
  7. Click Upgrade
    image2021-2-9-15_24_7
  8. Upgrade Complete!
  • Run the following query to confirm the upgrade worked.
Select @@version
  • You should get an output stating the following. Look for the Standard Edition identifier
Microsoft SQL Server 2008 R2 (RTM) - 10.50.1617.0 (Intel X86)   Apr 22 2011 11:57:00   Copyright (c) Microsoft Corporation  Standard Edition on Windows NT 5.2 <X86> (Build 3790: Service Pack 2)