| title | Complete the Database Engine Upgrade | Microsoft Docs | |
|---|---|---|
| ms.custom | ||
| ms.date | 09/22/2015 | |
| ms.prod | sql-server-2016 | |
| ms.reviewer | ||
| ms.suite | ||
| ms.technology |
|
|
| ms.tgt_pltfrm | ||
| ms.topic | article | |
| ms.assetid | 3f08087e-e532-416c-8caa-e0ec88c57596 | |
| caps.latest.revision | 10 | |
| ms.author | mikeray | |
| manager | jhubbard |
After the upgrade to SQL Server 2016 is 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 upgraded database.
-
Enable new features: In SQL Server 2016, some changes are only enabled once the DATABASE_COMPATIBILITY level for a database has been changed to 130. 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 2016 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.
What information are you looking for, and did you find it? We’re listening to your feedback to improve the content. Please submit your comments to sqlfeedback@microsoft.com