| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | helpviewer_keywords | monikerRange | |||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
Upgrade the Database Engine |
The article provides links to resources that help you upgrade the SQL Server Database Engine from a prior release of SQL Server to the latest version. |
rwestMSFT |
randolphwest |
09/26/2023 |
sql |
install |
upgrade-and-migration-article |
|
>=sql-server-2016 |
[!INCLUDE SQL Server]
The articles in this section help you upgrade the [!INCLUDE ssdenoversion-md] from a prior release of [!INCLUDE ssNoVersion] to [!INCLUDE sssql22-md].
-
Choose a Database Engine upgrade method. Before beginning an upgrade, you need to understand the various upgrade methods. This article discusses the upgrade methods and the steps involved with each upgrade method.
-
Plan and test the Database Engine upgrade plan. After reviewing the upgrade methods, you're ready to develop the appropriate upgrade method for your environment and then test the upgrade method before upgrading the existing environment. This article discusses developing an upgrade plan and testing it.
-
Complete the Database Engine Upgrade. After your database engine has been upgraded and databases are online, there are additional steps you need to take, including taking a new backup, upgrading the databases functionality to enable new features, and repopulating full-text catalogs. This article discusses these steps.
-
Upgrade the Database Compatibility Level.
Applies to: [!INCLUDE ssNoVersion], [!INCLUDE ssazure-sqldb], and [!INCLUDE ssazuremi-md]
One of the steps to take after your databases are online in the new version of [!INCLUDE ssNoVersion] or [!INCLUDE ssazure-sqldb], may be to upgrade the databases functionality mode to enable new features, by changing the database compatibility level. This can be done manually or through the Query Tuning Assistant.
-
Change the Database Compatibility Mode and Use the Query Store. After manually changing the database compatibility level, use the Query Store to monitor performance and identify possible regressions. This article discusses the recommended process and provides a recommended workflow.
-
Change the Database Compatibility Mode with Query Tuning Assistant. Alternatively to a manual change, use the Query Tuning Assistant (QTA) to be guided through the recommended process of changing the database compatibility level. This article discusses this process and provides instructions on the QTA workflow.
For more information about new features and improved behaviors available after changing a database compatibility level, see Differences between Compatibility Levels.
-
-
Take Advantage of New SQL Server Features. Finally, after you have completed the previous steps, you're ready to explore taking advantage of specific new database engine enhancements. This article suggests a few of these enhancements and provides links for more information.