Upgrade Database Engine

APPLIES TO: yesSQL Server (Windows only) noAzure SQL Database noAzure SQL Data Warehouse noParallel Data Warehouse

The articles in this section will help you upgrade the SQL Server database engine from a prior release of SQL Server to SQL Server 2017.

  1. 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.

  2. Plan and Test the Database Engine Upgrade Plan After reviewing the upgrade methods, you are 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.

  3. Complete the Database Engine Upgrade After your databases have been upgraded to SQL Server 2017, there are additional steps you need to take, including taking a new backup, enabling new features, and repopulating full-text catalogs. This article discusses these steps.

  4. Change the Database Compatibility Mode and Use the Query Store One of the steps to take after your databases have been upgraded to SQL Server 2017 is to enable new features by changing the database compatibility mode and then using the query store to monitor performance. This article discusses this process and provides a recommended workflow.

  5. Take Advantage of New SQL Server Features Finally, after you have completed the previous steps, you are 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.