Upgrade Database Engine

Upgrade Database Engine


Updated: September 17, 2015

Applies To: SQL Server 2016 Preview

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

  1. Database Engine Upgrade Methods 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. Database Engine Upgrade Planning and Testing 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. Steps to Take After Upgrading the Database Engine After your databases have been upgraded to SQL Server 2016, 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. Changing the Database Compatibility Mode and Using the Query Store One of the steps to take after your databases have been upgraded to SQL Server 2016 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. Taking Advantage of New 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.

Community Additions

© 2016 Microsoft