Skip to content

upgrade-database-engine.md

Latest commit

 

History

History
37 lines (30 loc) · 2.73 KB

upgrade-database-engine.md

File metadata and controls

37 lines (30 loc) · 2.73 KB
title Upgrade Database Engine | Microsoft Docs
ms.custom
ms.date 07/18/2017
ms.prod
sql-server-2016
sql-server-2017
ms.reviewer
ms.suite
ms.technology
setup-install
ms.tgt_pltfrm
ms.topic article
helpviewer_keywords
compatibility [SQL Server], databases
compatibility levels [SQL Server], after upgrade
Database Engine [SQL Server], upgrading
ms.assetid 3c036813-36cf-4415-a0c9-248d0a433859
caps.latest.revision 62
author MikeRayMSFT
ms.author mikeray
manager jhubbard

Upgrade Database Engine

The topics in this section will help you upgrade the [!INCLUDEssNoVersion] database engine from a prior release of [!INCLUDEssNoVersion] to [!INCLUDEssCurrent].

  1. Choose a Database Engine Upgrade Method Before beginning an upgrade, you need to understand the various upgrade methods. This topic 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 topic discusses developing an upgrade plan and testing it.

  3. Complete the Database Engine Upgrade After your databases have been upgraded to [!INCLUDEssCurrent], there are additional steps you need to take, including taking a new backup, enabling new features, and re-populating full-text catalogs. This topic 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 [!INCLUDEssCurrent] is to enable new features by changing the database compatibility mode and then using the query store to monitor performance. This topic 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 topic suggests a few of these enhancements and provides links for more information.