SQL 2014 In-Place Upgrade To SQL 2017

This is an in-place upgrade. Which means you will be able to upgrade to a later version using the same SQL key. Ensure you know the version. If you are not sure, you can go to SQL configuration manager > SQL Server Services > SQL Server <Database name> . Right click and select properties. Then select the “Advanced” tab. Scroll down to “Stock keeping unit name”

Once confirmed, load up the ISO image or installation file on the machine and “Run as administrator”. Then select the “Installation” icon.

Select “Upgrade from a previous version of SQL Server”

The system will run through the pre-checks.

Then it will check the instances. Now this is where you need to be careful as when you selecting a Database instance and you have multiple instances, you will have to upgrade each one. Else only the selected instance will be upgraded to 2017. The other instances will still be on the legacy version.

Then it will run through the feature checks.

Now the feature roles. SQL has built in rules to check if the upgrade can continue and any anticipated blocks along the way.

Then click “Upgrade”. The bar should start moving and should not take too long.

Upon completion, it will list the features which has been upgrade and notify you. If you look at the below options on the left and some of the above images, you will noticed this one has more options. The reason is the SQL version. The one with the least components is Standard and the below is Enterprise. That is all.

Now, as of 2016, selected components has been decoupled. Which means the process we completed, only upgrades the database components. Not the management studio. Thereafter, you will have to download the SQL Management Studio 18.3.1 . It is a 500MB file. Once downloaded, run the installation as “Administrator”.

Once completed, look for SSMS 2018 or SQL Management Studio 2018. Click, login and continue working.

The Dark Theme look is awesome.

Be the first to comment

Leave a Reply

Your email address will not be published.


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