Upgrade SQL Server 2016 to 2017

0

Recently, SQL Server 2017 was released as GA to the masses. This represents the latest and greatest SQL server technology available to consume. There are some really great new features that are contained in SQL Server 2017 to be aware of, some of which are listed below.  In this post, we will take a look at how to Upgrade SQL Server 2016 to 2017.

SQL Server 2017 New Features

Just to mention a few of the notable features in the Database Engine:

  • CLR Assemblies – can now be whitelisted
    Resumable online index rebuilds – If an index is interrupted due to a failover, etc, these can now be resumed
  • IDENTITY_CACHE – allows avoding gaps in teh values of identity columns
  • Query processing improvments – New processing improvements that adapt optimization strategies to application workloads
  • Automatic database tuning – analyzes query performance problems, recommends solutions
  • Graph database capabilities – modeling features for relationships between tables
  • New Availability Groups functionlity – clusterless support minimum replica commit availability groups setting and Windows-Linux cross OS migrations and testing
  • Dynamic management views – New management views
  • Database tuning advisor – additional options for improved performance
  • Database scoped credential – new security mechanisms

For a more thorough listing of the new features contained in SQL Server 2017, take a look at the official Microsoft documentation here.

Upgrade SQL Server 2016 to 2017

It is best practice before beginning the SQL Server 2017 upgrade, to make sure that SQL Server 2016 is fully updated.  At the time of this writing, SQL Server 2016 SP1 CU5 is available.  This is the version that we will update our SQL Server 2016 server to before running the upgrade.  Notice before updating, our version is 13.0.4001.0.

SQL-Server-2016-version-before-patching Upgrade SQL Server 2016 to 2017

SQL Server 2016 version before patching

After downloading the cumulative update, we run the updater and apply the latest rollup.

SQL-Server-2016-CU5-install Upgrade SQL Server 2016 to 2017

SQL Server 2016 CU5 install

After applying the cumulative update, we can check the version of our SQL 2016 Server.  It should now be 13.0.4451.0.

After-installing-SQL-Server-2016-SP1-CU5 Upgrade SQL Server 2016 to 2017

After installing SQL Server 2016 SP1 CU5

Enter the product key of SQL Server 2017.

Enter-your-SQL-Server-2017-product-key Upgrade SQL Server 2016 to 2017

Enter your SQL Server 2017 product key

Next, the normal stuff – we accept the EULA and move forward.

Accept-the-SQL-Server-2017-EULA Upgrade SQL Server 2016 to 2017

Accept the SQL Server 2017 EULA

We can choose to check Windows Updates for updates to SQL Server 2017 which is recommended.

Check-for-important-SQL-Server-2017-updates Upgrade SQL Server 2016 to 2017

Check for important SQL Server 2017 updates

Next, we select the specific SQL instance we want to upgrade to SQL Server 2017.

Select-the-SQL-Server-2016-Instance-to-upgrade Upgrade SQL Server 2016 to 2017

Select the SQL Server 2016 Instance to upgrade

We will note the features to upgrade cannot be changed during an upgrade.  The installed components will be upgraded as is.

Select-SQL-Server-2016-features-to-upgrade Upgrade SQL Server 2016 to 2017

Select SQL Server 2016 features to upgrade

We can specify the instance ID name for the ugprade.

SQL-Server-2017-Instance-configuration Upgrade SQL Server 2016 to 2017

SQL Server 2017 Instance configuration

Ready to proceed with the upgrade.  We can review the listed summary of upgrade actions.  Click Upgrade to begin the process.

Begin-SQL-Server-2017-Upgrade-process Upgrade SQL Server 2016 to 2017

Begin SQL Server 2017 Upgrade process

The upgrade progresses forward with the action items specified.

SQL-Server-2017-Upgrade-progresses Upgrade SQL Server 2016 to 2017

SQL Server 2017 Upgrade progresses

The Upgrade to SQL Server 2017 is successful.

SQL-Server-2017-Upgrade-process-is-successful Upgrade SQL Server 2016 to 2017

SQL Server 2017 Upgrade process is successful

We know the upgrade was truly successful as we can check the version number presented to management studio.  We now should see 14.0.1000.169 as our version for SQL Server 2017.

After-Upgrade-SQL-Server-version-is-SQL-Server-2017-RTM Upgrade SQL Server 2016 to 2017

After Upgrade SQL Server version is SQL Server 2017 RTM

Thoughts

SQL Server 2017 certainly contains some very cool new features.  I had no issues with the upgrade SQL Server 2016 to 2017.  The upgrade process is the same as it has been with previous SQL versions.  Make sure to update your current SQL version to the latest patch level before upgrading as this always helps to mitigate issues.