complete-the-database-engine-upgrade.md

title	Complete the Database Engine Upgrade | Microsoft Docs
ms.custom
ms.date	10/23/2017
ms.prod	sql-non-specified
ms.prod_service	database-engine
ms.service
ms.component	install-windows
ms.reviewer
ms.suite	sql
ms.technology	server-general
ms.tgt_pltfrm
ms.topic	article
ms.assetid	3f08087e-e532-416c-8caa-e0ec88c57596
caps.latest.revision	10
author	MikeRayMSFT
ms.author	mikeray
manager	jhubbard

Complete the Database Engine Upgrade

[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md] 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. If your database has memory-optimized tables created in SQL Server 2014, review Statistics for Memory-Optimized Tables.

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