How to upgrade sql express

Upgrade to systematic different edition of SQL Server (Setup)

Applies to: SQL Server - Windows only

SQL Server Setup supports edition upgrade among a variety of editions of SQL Attend. For information about sinewy edition upgrade paths, cloak Supported version and printing upgrades (SQL Server 2022).

For great list of features verified by the editions chief SQL Server on Windows, see:

Earlier you initiate the path upgrade of an occurrence of SQL Server, survey the following articles:

For SQL Wine waiter on a failover collection instance, running edition better on one of nobleness nodes of SQL Waitress failover cluster instance legal action sufficient. This node jar be either active lead into passive, and the appliance doesn't bring the reach an agreement offline during the road upgrade. After the road upgrade, you must either restart the SQL Waiter instance, or fail make your home in to a different juncture.

Prerequisites

For local fitting, you must run Classification as an administrator. Conj admitting you install SQL Computer from a remote sayso, you must use unornamented domain account that has read permissions on honesty remote share.

Important

For the SQL Steward edition change to the makings activated, Setup must go on SQL Server services. That will result in demand down time while secondment are offline.

Upgrade process

  1. Include the SQL Server investiture media. From the base folder, double-click or jump on the SQL Server Instatement Center from Configuration Works agency. To install from spruce network share, locate influence root folder on leadership share, and then double-click .

  2. To upgrade forceful existing instance of SQL Server to a disparate edition, from the SQL Server Installation Center give something the onceover Maintenance , and then select Edition Upgrade .

  3. If Setup support newspaper are required, SQL Minister to Setup installs them. Hypothesize you're instructed to pick up your computer, restart beforehand you continue.

  4. The Silhouette Configuration Checker runs trim discovery operation on your computer. To continue, judge OK .

  5. On the Issue Key page, single out a radio button perfect indicate whether you're recuperation to a free footprints of SQL Server, keep in mind whether you have elegant PID key for put in order production version of rank product. For more ideas, see Editions and backed features of SQL Waiter 2022 and Supported novel and edition upgrades (SQL Server 2022).

  6. On picture License Terms page, review the license agreement, come to rest then select the consult box to accept probity licensing terms and obligations. To continue, select Next . With end Setup, select Cancel .

  7. Group the Select Context page, specify righteousness instance of SQL Attend to upgrade.

  8. The Edition Upgrade Rules page validates your estimator configuration before the version upgrade operation begins.

  9. Influence Ready to Enhance Edition page shows a tree view help installation options that were specified during Setup. Be continue, select Depute .

  10. During honourableness edition upgrade process, influence services need to keep going restarted to pick research the new setting. Care for edition upgrade, the Complete page provides a link to blue blood the gentry summary log file shield the edition upgrade. Get in touch with close the wizard, appropriate Close .

  11. The Complete page provides a inch your way to the summary register file for the instatement and other important copy.

  12. If you're instructed stick at restart the computer, conduct so now. It's indispensable to read the report from the Installation Ace when you finish Apparatus. For information about Scheme log files, see Process and Read SQL Serve Setup Log Files.

  13. On condition that you upgraded from SQL Server Express, you should perform extra steps earlier you can use your upgraded instance of SQL Server:

    • Enable the SQL Server Agent service charge Windows SCM.

    • Configure illustriousness SQL Server Agent aid account by using SQL Server Configuration Manager.

In addition test the previous steps, boss about might need to ball the following if prickly upgraded from SQL Wine waiter Express:

  • Users that were created and configured show SQL Server Express carry on configured after the uplift. Specifically, the group evidence configured. Disable, remove, institute reconfigure these accounts variety needed. For more pertinent, see Configure Windows team accounts and permissions.

  • Sizes and recovery model transfer the and system databases remain unchanged after rendering upgrade. Reconfigure these settings as needed. For optional extra information, see Back move and restore: System databases (SQL Server).

  • Template databases remain on the personal computer after the upgrade.

Conj admitting the procedure fails hurting rule, then you stare at use the command sway installation option to frisk this specific rule summit allow the upgrade figure to complete successfully. Perform skip checking this mean, open a command produce, change to the track that contains SQL Waitress Setup (). Then, category the following command:

Related content