Upgrade SQL Server
Applies to: SQL Server - Windows only
You can upgrade instances of SQL Server 2012 (11.x), SQL Server 2014 (12.x), SQL Server 2016 (13.x), SQL Server 2017 (14.x), or SQL Server 2019 (15.x) directly to SQL Server 2022 (16.x). For SQL Server 2008 (10.0.x) and SQL Server 2008 R2 (10.50.x), you need to either do a side-by-side upgrade, or a migration, to move to SQL Server 2022 (16.x) 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 SQL Server 2014 (12.x) 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.
Upgrade documentation
For a list of features supported by the editions of SQL Server on Windows, see:
- Editions and supported features of SQL Server 2022
- Editions and supported features of SQL Server 2019
- Editions and supported features of SQL Server 2017
- Editions and supported features of SQL Server 2016
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
Related content
- 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)