| title | Complete the Database Engine Upgrade | Microsoft Docs | ||
|---|---|---|---|
| ms.custom | |||
| ms.date | 07/21/2017 | ||
| ms.prod |
|
||
| ms.reviewer | |||
| ms.suite | |||
| ms.technology |
|
||
| ms.tgt_pltfrm | |||
| ms.topic | article | ||
| ms.assetid | 3f08087e-e532-416c-8caa-e0ec88c57596 | ||
| caps.latest.revision | 10 | ||
| author | MikeRayMSFT | ||
| ms.author | mikeray | ||
| manager | jhubbard |
After the upgrading SQL Server complete, there are a number of additional steps that you may need to take. These include the following:
After upgrading the [!INCLUDEssDE], complete the following tasks:
-
Backup your databases: Perform a full backup of each database.
-
Enable new features: In SQL Server 2016 and SQL Server 2017, some changes are only enabled once the DATABASE_COMPATIBILITY level for a database has been changed to 130 or greater. For more information and for the recommended workflow, see Change the Database Compatibility Mode and Use the Query Store.
-
Integration Services:
Migrate Integration Services packages to [!INCLUDEssCurrent] format. For more information, see Upgrade Integration Services Packages.
-
Reporting Services: For a new installation upgrade, restore the Reporting Services encryption Keys. For more information, see Back Up and Restore Reporting Services Encryption Keys.
-
Master Data Services: Upgrade the MDS database schema and create the SQL Server 2017 web application. For more information, see Upgrade Master Data Services.
-
Data Quality Services: Upgrade the DQS databases schema and verify the DQS databases schema upgrade. For more information, see Upgrade Data Quality Services.
-
Full Text Search: Re-populate full-text catalogs to ensure semantic consistency in query results. For more information, see Populate Full-Text Indexes.