Sunday, October 7, 2018

How to upgrade MS SQL 2014 to SQL 2017

Download the required version.

https://www.microsoft.com/en-us/sql-server/sql-server-editions-express

clip_image001

clip_image002

The Installation Wizard starts the SQL Server Installation Center. To upgrade an existing instance of SQL Server, click Installation in the left-hand navigation area, and then click Upgrade from... previous versions of SQL Server.

clip_image003

Accept the license agreement.

clip_image004

Here you can choose to allow Microsoft updates to pull updates for SQL as well.

clip_image005

In the specify the instance of SQL Server to modify you can choose a specific instance, or in the dropdown combo box, you can also choose to only upgrade shared components.

clip_image006

With the upgrade, it is not possible to change the configured features currently configured by SQL Server 2014.  By default it will upgrade all configured features.

clip_image007

Here you can specify the instance ID for the instance of SQL Server.

clip_image008

Here you can specify the service accounts and collation configuration.

clip_image009

As you can see there are three choices here – Import, Rebuild, and Reset.  Since this was a clean installation of SQL Server 2014 that was being upgraded to SQL Server 2016, I chose to Rebuild full-text catalogs using the new and enhanced word breakers.  As the installation notes below, rebuilding indexes can take a while, and a significant amount of CPU and memory might be required after the upgrade.

clip_image010

Finally, we come to the Ready to Upgrade screen that displays our configuration choices.

clip_image011

After the upgrade process has completed, you are notified that you need to reboot the server to finish out the process.

clip_image012

You should see Succeeded on all the individual upgrade steps.  If not, take a look at the setup log for the upgrade process to begin troubleshooting.

clip_image013

No comments:

Post a Comment

Oracle Database 19c Installation on Oracle Linux 7

Pre-installation settings before installing Oracle Database 19c SELinux If the OS is to be used for an Oracle installation, it is ...