Dela via

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'll either need to 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:

Support for SQL Server 2012 (11.x) ended on July 12, 2022. For new end of support options, see New options for SQL Server 2012 and Windows Server 2012 End of Support.

If you're upgrading from an end-of-support version of SQL Server, such as SQL Server 2008 (10.0.x), SQL Server 2008 R2 (10.50.x), and SQL Server 2012 (11.x), see the end of support options.

Upgrade documentation

The following articles help you upgrade components of SQL Server:

Next steps