SQL

Upgrade SQL Server 2016 to 2017

Today we take a quick look at how to Upgrade SQL Server 2016 to 2017. SQL Server 2017 has some really cool new features worth taking a look at

Highlights

  • For a more thorough listing of the new features contained in SQL Server 2017, take a look at the official Microsoft documentation here.
  •   In this post, we will take a look at how to Upgrade SQL Server 2016 to 2017.
  •   This is the version that we will update our SQL Server 2016 server to before running the upgrade.

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
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
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
After installing SQL Server 2016 SP1 CU5

Enter the product key of SQL Server 2017.

Enter-your-SQL-Server-2017-product-key
Enter your SQL Server 2017 product key

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

Accept-the-SQL-Server-2017-EULA
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
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
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
Select SQL Server 2016 features to upgrade

We can specify the instance ID name for the ugprade.

SQL-Server-2017-Instance-configuration
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
Begin SQL Server 2017 Upgrade process

The upgrade progresses forward with the action items specified.

SQL-Server-2017-Upgrade-progresses
SQL Server 2017 Upgrade progresses

The Upgrade to SQL Server 2017 is successful.

SQL-Server-2017-Upgrade-process-is-successful
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
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.

Subscribe to VirtualizationHowto via Email 🔔

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Brandon Lee

Brandon Lee is the Senior Writer, Engineer and owner at Virtualizationhowto.com and has over two decades of experience in Information Technology. Having worked for numerous Fortune 500 companies as well as in various industries, Brandon has extensive experience in various IT segments and is a strong advocate for open source technologies. Brandon holds many industry certifications, loves the outdoors and spending time with family.

Related Articles

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.