| title | Supported Version and Edition Upgrades (SQL Server 2022) | ||||
|---|---|---|---|---|---|
| description | The supported version and edition upgrades for SQL Server 2022. | ||||
| author | rwestMSFT | ||||
| ms.author | randolphwest | ||||
| ms.date | 06/16/2025 | ||||
| ms.service | sql | ||||
| ms.subservice | install | ||||
| ms.topic | upgrade-and-migration-article | ||||
| helpviewer_keywords |
|
||||
| monikerRange | >=sql-server-2017 |
[!INCLUDE SQL Server - Windows Only]
This article lists the supported upgrade paths from the following [!INCLUDE ssNoVersion] versions, and the supported edition upgrades for [!INCLUDE sssql22-md].
You can upgrade from:
- [!INCLUDE ssSQL11] SP4 or later
- [!INCLUDE ssSQL14] SP3 or later
- [!INCLUDE ssSQL16] SP3 or later
- [!INCLUDE sssql17-md]
- [!INCLUDE sssql19-md]
For older versions of [!INCLUDE ssnoversion-md], you can also Migrate to SQL Server 2022.
-
Before you upgrade from one edition of [!INCLUDE sssql22-md] to another, verify that the functionality you're currently using is supported in the edition to which you're moving. For more information, see Editions and supported features of SQL Server 2022.
-
Verify supported hardware and software, including the supported operating system. For more information, see Hardware and software requirements for SQL Server 2022.
-
Before upgrading [!INCLUDE ssNoVersion], enable Windows Authentication for [!INCLUDE ssNoVersion] Agent and verify the default configuration, that the [!INCLUDE ssNoVersion] Agent service account is a member of the [!INCLUDE ssNoVersion] sysadmin group.
-
Upgrade is blocked if there's a pending restart.
-
Upgrade is blocked if the Windows Installer service isn't running.
-
Cross-version instances of [!INCLUDE sssql22-md] aren't supported. Version numbers of the [!INCLUDE ssDE] components must be the same in an instance of [!INCLUDE sssql22-md].
-
[!INCLUDE sssql22-md] is only available for 64-bit platforms. Cross-platform upgrade isn't supported. You can't upgrade a 32-bit instance of [!INCLUDE ssNoVersion] to native 64-bit using [!INCLUDE ssNoVersion] Setup. However, you can back up or detach databases from a 32-bit instance of [!INCLUDE ssNoVersion], and then restore or attach them to a new instance of [!INCLUDE ssNoVersion] (64-bit), if the databases aren't published in replication. You must re-create any logins and other user objects in
master,msdb, andmodelsystem databases. -
You can't add new features during the upgrade of your existing instance of [!INCLUDE ssNoVersion]. After you upgrade an instance of [!INCLUDE ssNoVersion] to [!INCLUDE sssql22-md], you can add features by using the [!INCLUDE sssql22-md] Setup. For more information, see Add Features to an Instance of SQL Server (Setup).
[!INCLUDE sssql22-md] supports upgrade from the following versions of SQL Server:
- [!INCLUDE ssSQL11] SP4 or later
- [!INCLUDE ssSQL14] SP3 or later
- [!INCLUDE ssSQL16] SP3 or later
- [!INCLUDE sssql17-md]
- [!INCLUDE sssql19-md]
The following table lists the supported upgrade scenarios from earlier versions of [!INCLUDE ssNoVersion] to [!INCLUDE sssql22-md].
| Upgrade from | Supported upgrade path |
|---|---|
| [!INCLUDE ssSQL11] SP4 Enterprise | [!INCLUDE sssql22-md] Enterprise |
| [!INCLUDE ssSQL11] SP4 Developer | [!INCLUDE sssql22-md] Developer [!INCLUDE sssql22-md] Standard [!INCLUDE sssql22-md] Web [!INCLUDE sssql22-md] Enterprise |
| [!INCLUDE ssSQL11] SP4 Standard | [!INCLUDE sssql22-md] Enterprise [!INCLUDE sssql22-md] Standard |
| [!INCLUDE ssSQL11] SP4 Web | [!INCLUDE sssql22-md] Enterprise [!INCLUDE sssql22-md] Standard [!INCLUDE sssql22-md] Web |
| [!INCLUDE ssSQL11] SP4 Express | [!INCLUDE sssql22-md] Enterprise [!INCLUDE sssql22-md] Standard [!INCLUDE sssql22-md] Web [!INCLUDE sssql22-md] Express |
| [!INCLUDE ssSQL11] SP4 Business Intelligence | [!INCLUDE sssql22-md] Enterprise |
| [!INCLUDE ssSQL11] SP4 Evaluation | [!INCLUDE sssql22-md] Evaluation [!INCLUDE sssql22-md] Enterprise [!INCLUDE sssql22-md] Standard [!INCLUDE sssql22-md] Web [!INCLUDE sssql22-md] Developer |
| [!INCLUDE ssSQL14] SP3 Enterprise | [!INCLUDE sssql22-md] Enterprise |
| [!INCLUDE ssSQL14] SP3 Developer | [!INCLUDE sssql22-md] Developer [!INCLUDE sssql22-md] Standard [!INCLUDE sssql22-md] Web [!INCLUDE sssql22-md] Enterprise |
| [!INCLUDE ssSQL14] SP3 Standard | [!INCLUDE sssql22-md] Enterprise [!INCLUDE sssql22-md] Standard |
| [!INCLUDE ssSQL14] SP3 Web | [!INCLUDE sssql22-md] Enterprise [!INCLUDE sssql22-md] Standard [!INCLUDE sssql22-md] Web |
| [!INCLUDE ssSQL14] SP3 Express | [!INCLUDE sssql22-md] Enterprise [!INCLUDE sssql22-md] Standard [!INCLUDE sssql22-md] Web [!INCLUDE sssql22-md] Express [!INCLUDE sssql22-md] Developer |
| [!INCLUDE ssSQL14] SP3 Business Intelligence | [!INCLUDE sssql22-md] Enterprise |
| [!INCLUDE ssSQL14] SP3 Evaluation | [!INCLUDE sssql22-md] Evaluation [!INCLUDE sssql22-md] Enterprise [!INCLUDE sssql22-md] Standard [!INCLUDE sssql22-md] Web [!INCLUDE sssql22-md] Developer |
| [!INCLUDE ssSQL16] SP3 Enterprise | [!INCLUDE sssql22-md] Enterprise |
| [!INCLUDE ssSQL16] SP3 Developer | [!INCLUDE sssql22-md] Developer [!INCLUDE sssql22-md] Standard [!INCLUDE sssql22-md] Web [!INCLUDE sssql22-md] Enterprise |
| [!INCLUDE ssSQL16] SP3 Standard | [!INCLUDE sssql22-md] Enterprise [!INCLUDE sssql22-md] Standard |
| [!INCLUDE ssSQL16] SP3 Web | [!INCLUDE sssql22-md] Enterprise [!INCLUDE sssql22-md] Standard [!INCLUDE sssql22-md] Web |
| [!INCLUDE ssSQL16] SP3 Express | [!INCLUDE sssql22-md] Enterprise [!INCLUDE sssql22-md] Standard [!INCLUDE sssql22-md] Web [!INCLUDE sssql22-md] Express [!INCLUDE sssql22-md] Developer |
| [!INCLUDE ssSQL16] SP3 Business Intelligence | [!INCLUDE sssql22-md] Enterprise |
| [!INCLUDE ssSQL16] SP3 Evaluation | [!INCLUDE sssql22-md] Evaluation [!INCLUDE sssql22-md] Enterprise [!INCLUDE sssql22-md] Standard [!INCLUDE sssql22-md] Web [!INCLUDE sssql22-md] Developer |
| [!INCLUDE sssql17] Enterprise | [!INCLUDE sssql22-md] Enterprise |
| [!INCLUDE sssql17] Developer | [!INCLUDE sssql22-md] Developer [!INCLUDE sssql22-md] Standard [!INCLUDE sssql22-md] Web [!INCLUDE sssql22-md] Enterprise |
| [!INCLUDE sssql17] Standard | [!INCLUDE sssql22-md] Enterprise [!INCLUDE sssql22-md] Standard |
| [!INCLUDE sssql17] Web | [!INCLUDE sssql22-md] Enterprise [!INCLUDE sssql22-md] Standard [!INCLUDE sssql22-md] Web |
| [!INCLUDE sssql17] Express | [!INCLUDE sssql22-md] Enterprise [!INCLUDE sssql22-md] Standard [!INCLUDE sssql22-md] Web [!INCLUDE sssql22-md] Express [!INCLUDE sssql22-md] Developer |
| [!INCLUDE sssql17] Business Intelligence | [!INCLUDE sssql22-md] Enterprise |
| [!INCLUDE sssql17] Evaluation | [!INCLUDE sssql22-md] Evaluation [!INCLUDE sssql22-md] Enterprise [!INCLUDE sssql22-md] Standard [!INCLUDE sssql22-md] Web [!INCLUDE sssql22-md] Developer |
| [!INCLUDE sssql19] Enterprise | [!INCLUDE sssql22-md] Enterprise |
| [!INCLUDE sssql19] Developer | [!INCLUDE sssql22-md] Developer [!INCLUDE sssql22-md] Standard [!INCLUDE sssql22-md] Web [!INCLUDE sssql22-md] Enterprise |
| [!INCLUDE sssql19] Standard | [!INCLUDE sssql22-md] Enterprise [!INCLUDE sssql22-md] Standard |
| [!INCLUDE sssql19] Web | [!INCLUDE sssql22-md] Enterprise [!INCLUDE sssql22-md] Standard [!INCLUDE sssql22-md] Web |
| [!INCLUDE sssql19] Express | [!INCLUDE sssql22-md] Enterprise [!INCLUDE sssql22-md] Standard [!INCLUDE sssql22-md] Web [!INCLUDE sssql22-md] Express [!INCLUDE sssql22-md] Developer |
| [!INCLUDE sssql19] Business Intelligence | [!INCLUDE sssql22-md] Enterprise |
| [!INCLUDE sssql19] Evaluation | [!INCLUDE sssql22-md] Evaluation [!INCLUDE sssql22-md] Enterprise [!INCLUDE sssql22-md] Standard [!INCLUDE sssql22-md] Web [!INCLUDE sssql22-md] Developer |
| [!INCLUDE sssql22-md] release candidate 1 | [!INCLUDE sssql22-md] Enterprise |
| [!INCLUDE sssql22_md] Developer | [!INCLUDE sssql22-md] Enterprise |
1 Microsoft support to upgrade from release candidate software is specifically for customers who participated in the Early Adopter Program.
You can migrate databases from older versions of [!INCLUDE ssnoversion-md] to [!INCLUDE sssql22-md], as long as the source database compatibility level is 90 or higher. Databases with a compatibility level of 90 (for example, on [!INCLUDE ssversion2005-md]), are automatically upgraded to a compatibility level of 100 when migrated to [!INCLUDE sssql22-md]. If the compatibility level on the source database is 100 or higher, it's unchanged on [!INCLUDE sssql22-md].
For information, see Upgrade SQL Server to the latest version.
The following tips and tools can help you plan and implement your migration.
-
Migration tools. Migration is supported through the SQL Server migration component in SQL Server Management Studio.
-
Backup and restore. A backup taken on [!INCLUDE sql2008-md] and later, can be restored to [!INCLUDE sssql22-md] without changing its compatibility level, as long as the database backup has a compatibility level of
100or higher.Databases with a compatibility level of
90, including backups taken on [!INCLUDE ssversion2005-md], are automatically upgraded to a compatibility level of100when restored to [!INCLUDE sssql22-md]. -
Log shipping. Log shipping is supported if the primary is running [!INCLUDE sql2008-md] SP3 or later, or [!INCLUDE sql2008r2-md] SP2 or later, and the secondary is running [!INCLUDE sssql22-md].
[!WARNING]
If an automatic or manual failover happens and the [!INCLUDE sssql22-md] instance becomes primary, [!INCLUDE sql2008-md] or [!INCLUDE sql2008r2-md] instance becomes secondary and can't receive changes from primary. -
Bulk load: Tables can be bulk copied from [!INCLUDE sql2008-md] or [!INCLUDE sql2008r2-md] to [!INCLUDE sssql22-md].
The following table lists the supported edition upgrade scenarios in [!INCLUDE sssql22-md].
For step-by-step instructions on how to perform an edition upgrade, see Upgrade to a different edition of SQL Server (Setup).
| Upgrade from | Upgrade to |
|---|---|
| [!INCLUDE sssql22-md] Enterprise (Server+CAL and Core) 2 | [!INCLUDE sssql22-md] Enterprise |
| [!INCLUDE sssql22-md] Evaluation Enterprise 2 | [!INCLUDE sssql22-md] Enterprise (Server+CAL or Core License) [!INCLUDE sssql22-md] Standard [!INCLUDE sssql22-md] Developer [!INCLUDE sssql22-md] Web Upgrading from Evaluation (a free edition) to any of the paid editions is supported for stand-alone installations, but isn't supported for clustered installations. This limitation doesn't apply to stand-alone instances installed on a Windows Failover Cluster participating in an availability group. |
| [!INCLUDE sssql22-md] Standard 2 | [!INCLUDE sssql22-md] Enterprise (Server+CAL or Core License) |
| [!INCLUDE sssql22-md] Developer 2 | [!INCLUDE sssql22-md] Enterprise (Server+CAL or Core License) [!INCLUDE sssql22-md] Web [!INCLUDE sssql22-md] Standard |
| [!INCLUDE sssql22-md] Web | [!INCLUDE sssql22-md] Enterprise (Server+CAL or Core License) [!INCLUDE sssql22-md] Standard |
| [!INCLUDE sssql22-md] Express 1 | [!INCLUDE sssql22-md] Enterprise (Server+CAL or Core License) [!INCLUDE sssql22-md] Developer [!INCLUDE sssql22-md] Standard [!INCLUDE sssql22-md] Web |
Additionally you can also perform an edition upgrade between [!INCLUDE sssql22-md] Enterprise (Server+CAL license) and [!INCLUDE sssql22-md] Enterprise (Core License):
| Edition upgrade from | Edition upgrade to |
|---|---|
| [!INCLUDE sssql22-md] Enterprise (Server+CAL License) 2 | [!INCLUDE sssql22-md] Enterprise (Core License) |
| [!INCLUDE sssql22-md] Enterprise (Core License) | [!INCLUDE sssql22-md] Enterprise (Server+CAL License) |
1 Also applies to [!INCLUDE sssql22-md] Express with Tools and [!INCLUDE sssql22-md] Express with Advanced Services.
2 Changing the edition of a clustered instance of [!INCLUDE sssql22-md] is limited. The following scenarios aren't supported for [!INCLUDE sssql22-md] failover clusters:
- [!INCLUDE sssql22-md] Enterprise to [!INCLUDE sssql22-md] Developer, Standard, or Evaluation.
- [!INCLUDE sssql22-md] Developer to [!INCLUDE sssql22-md] Standard or Evaluation.
- [!INCLUDE sssql22-md] Standard to [!INCLUDE sssql22-md] Evaluation.
- [!INCLUDE sssql22-md] Evaluation to [!INCLUDE sssql22-md] Standard.