title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | ms.custom | helpviewer_keywords | monikerRange | ||
---|---|---|---|---|---|---|---|---|---|---|---|---|
Upgrade SQL Server |
This article provides links to resources that contain upgrade information for instances of different versions of SQL Server. |
rwestMSFT |
randolphwest |
10/10/2024 |
sql |
install |
quickstart |
|
|
>=sql-server-2016 |
[!INCLUDE SQL Server -Windows Only]
You can upgrade instances of [!INCLUDE ssSQL11], [!INCLUDE ssSQL14], [!INCLUDE ss2016], [!INCLUDE sssql17], or [!INCLUDE sssql19] directly to [!INCLUDE sssql22-md]. For [!INCLUDE sql2008-md] and [!INCLUDE sql2008r2], you need to either do a side-by-side upgrade, or a migration, to move to [!INCLUDE sssql22-md] as there's no common overlap between a supported mainstream operating system. Before running setup to upgrade, review the following articles about the upgrade process and the release notes.
Check out what's new in each version of the product:
- SQL Server 2022 release notes
- SQL Server 2019 release notes
- SQL Server 2017 release notes
- SQL Server 2016 release notes
Support for [!INCLUDE sssql14-md] ended on July 9, 2024. For new end of support options, see End of Support for Windows Server and SQL Server.
If you're upgrading from an end-of-support version of SQL Server, see the end of support options.
[!INCLUDE editions-supported-features-windows]
The following articles help you upgrade components of SQL Server:
- Upgrade Analysis Services
- Upgrade the Database Engine
- Upgrade Data Quality Services
- Upgrade Integration Services
- Upgrade Master Data Services
- Upgrade Power Pivot for SharePoint
- Upgrade or patch replicated databases
- Upgrade and migrate Reporting Services
- Upgrade SQL Server Management Tools
- Upgrade SQL Server Using the Installation Wizard (Setup)
- Upgrade to a different edition of SQL Server (Setup)
- SQL Server end of support options
- Upgrade the Database Engine
- Upgrade Analysis Services
- Upgrade and migrate Reporting Services
- Upgrade Integration Services
- Upgrade or patch replicated databases
- Upgrade Master Data Services
- SQL Server 2008 R2 Best Practices Analyzer
- Discontinued Database Engine functionality in SQL Server
- Upgrade to a different edition of SQL Server (Setup)