Skip to content

5000+ Great Articles

Best Articles & Essays: Interesting Articles to Read Online

  • Editing videos for iPad Pro in 2023 How-To
  • Best ti85 plus ce graphing calculator 2020 Business
  • Windows 7/8/10 File Search Indexing Options Windows 7
  • Check the Age of a Website Computer Tips
  • Ten Best Blinkist Alternatives to Boost Your Reading in 2023 How-To
  • How to Use DiskPart Utility in Windows How-To
  • What is the System Reserved or EFI Partition in Windows? Help Desk
  • How to Check AppleCare Support and Warranty Status for Your Mac Hardware

How to Upgrade Microsoft SQL Server the Right Way

Posted on October 9, 2020 By blog_786 No Comments on How to Upgrade Microsoft SQL Server the Right Way

Hello and welcome to another detailed article on MSSQL. Today I will touch upon the subject of the online update of the MSSQL server from one version to another.

In today’s article, we will be upgrading Microsoft SQL Server 2014 to SQL Server 2017.

As with any upgrade, we first need to have a pre-upgrade checklist with all the tasks that need to be done before the upgrade itself. That way, we can make sure we haven’t missed anything and most likely things will go wrong (something always goes wrong).

So, since we’re probably going to use Windows Server 2012 R2 with our SQL 2014 installation, here’s the “list”:

  • Windows Updates
  • .NET Framework 4.6 .1
  • KB2919355
  • Free Space
  • Data Migration Assistant

Now let’s see what each step does. The first step, of course, is to make sure you have all Windows updates. This will also include SQL 2014 Service Packs. Service Pack 3 is recommended. Next, we need to make sure we have .NET 4.6.1 installed.

Again, if you’ve run Windows Updates, the .NET Framework will most likely be installed. Next, we need to make sure KB2919355 is also installed. The next step should be generally best practice, but always make sure you have at least 100 GB of free space on your partitions before performing any updates on your servers.

Now the last step is also the beginning of the whole update process. Running the Data Migration Assistant will analyze our SQL and database installation and suggest the best way to upgrade to 2017.

To download the Data Migration Assistant, follow this link:

https: //www.microsoft.com/en-us/download/details.asps? id = 53595

Now let’s get this SQL Server up and running and start installing the DMA and getting an assessment of our environment. Please note that my installation is in a test lab and is not a production environment.

Upgrade SQL Server to the new version

So let’s get started with the update!

I followed the link above and downloaded the Data Transfer Assistant. Now let’s go through the installation steps and make our assessment.

How to Upgrade Microsoft SQL Server the Right Way

Click Next, then on the next screen, accept the terms and click Next.

How to Upgrade Microsoft SQL Server the Right Way

On the following screens, just click Install and make sure you check the Run box after the installation is complete.

Once the installer has finished the whole process, we will move on to this beautiful toolbar with a nice welcome message. You know the type of welcome messages from Microsoft that become the horror of our nightmares as they always remind us of failed migrations, long hours in the office, etc. Well, let’s move on.

How to Upgrade Microsoft SQL Server the Right Way

Now let’s start by clicking the “+” button and choosing a migration script. As soon as you press this button, a new blade will appear with some parameters.

How to Upgrade Microsoft SQL Server the Right Way

As you can see, I select Assessment, enter any project name (mine is 2014-2017, as this is what we are trying to achieve), and I set the source and target server type to SQL Server, since all we are going to do is inline update.

Now let’s press the Create button.

How to Upgrade Microsoft SQL Server the Right Way

Once we click “Create”, we will be presented with three options to choose from. Check out compatibility issues, which will be our only choice for this update.

Do not select the New Feature Recommendations checkbox as we are not interested in this at this time. The third option is applicable in other scenarios in older versions of SQL and is also greyed out as it does not apply to our scenario.

After we click Next , we will be taken to the screen where we need to connect to the server we have chosen to update. Since we are updating the server we are connected to, we will select localhost as the server and be sure to check “Trusted Server Certificate” to avoid getting nasty errors that the name is not trusted in the domain, and so on.

How to Upgrade Microsoft SQL Server the Right Way

Then we click Connect and if a connection is established we will be presented with a list of all databases in that SQL instance. In my case, I have a test vpm database that we will be using when evaluating.

How to Upgrade Microsoft SQL Server the Right Way

Now we click Add and then Start Assessment.

How to Upgrade Microsoft SQL Server the Right Way

Now we will wait for the end of the exam.

How to Upgrade Microsoft SQL Server the Right Way

Now that the assessment is complete and we see a green check mark next to our database, we can upgrade to SQL Server 2017 knowing nothing breaks and full compatibility.

How to Upgrade Microsoft SQL Server the Right Way

It’s time to start the update process.

I have installed a SQL 2017 ISO image on my machine. Now we just run the normal installation and select Upgrade from a previous version of SQL Server.

How to Upgrade Microsoft SQL Server the Right Way

We can enter a serial number or select “Score” depending on our current needs.

How to Upgrade Microsoft SQL Server the Right Way

Then we make sure we are working on the correct instance.

How to Upgrade Microsoft SQL Server the Right Way

On the next page, we have the option to select and deselect the features that we want to update.

How to Upgrade Microsoft SQL Server the Right Way

On the next screens, we just click Next until we get to the update process, wait for it to complete, and we’re done!

How to Upgrade Microsoft SQL Server the Right Way

This is it! Thank you for taking the time to read this detailed article on how to properly upgrade SQL Server!

Share this:

  • Twitter
  • Facebook
How-To Tags:How to Upgrade Microsoft SQL Server the Right Way, Upgrade SQL Server to the new version

Post navigation

Previous Post: VMware Troubleshooting: Network Drop Issue
Next Post: Desired State Configuration in PowerShell

Related Posts

  • How To Know If Your School-Issued Laptop Has Spyware Installed How-To
  • How To Add A Business To Apple Maps How-To
  • How can I open an audible app for my computer? How-To
  • How to Get Tidal Outside Supported Countries  How-To
  • Easily Way To Track Your Monthly Broadband Usage How-To
  • How to Create Gifs From YouTube Videos How-To

Leave a Reply Cancel reply

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

Archives

  • October 2023
  • September 2023
  • August 2023
  • July 2023
  • June 2023
  • May 2023
  • April 2023
  • November 2022
  • September 2022
  • August 2022
  • July 2022
  • June 2022
  • May 2022
  • April 2022
  • March 2022
  • February 2022
  • January 2022
  • December 2021
  • November 2021
  • October 2021
  • September 2021
  • August 2021
  • March 2021
  • October 2020
  • September 2020
  • August 2020
  • July 2020
  • June 2020
  • May 2020
  • April 2020
  • March 2020
  • December 2019
  • July 2019
  • May 2019
  • April 2019
  • January 2019
  • December 2018
  • November 2018
  • October 2018
  • September 2018
  • August 2018

Categories

  • AI Tools & Guides
  • Amazon Web Services
  • Apple Watch
  • Computer Tips
  • Cool Websites
  • Featured Posts
  • Free Software Downloads
  • Gadgets
  • Gaming
  • General Software
  • Google Software/Tips
  • Hardware
  • Help Desk
  • How-To
  • iOS
  • iPad
  • iPhone
  • islamic Books
  • Linux
  • Linux Tips
  • Mac OS X
  • macOS
  • MS Office Tips
  • Networking
  • Office Tips
  • OS X
  • Product Reviews
  • Reviews
  • Safari
  • Smart Home
  • Smartphones
  • Software Reviews
  • technology
  • text
  • Tools Review
  • Troubleshooting
  • Tutorials
  • Uncategorized
  • Urdu Books PDF
  • Web Site Tips
  • Windows
  • Windows 10
  • Windows 7
  • Windows XP Tips
  • Wordpress
  • How to Watch Netflix in 1080p on Chrome and FireFox
  • cat5 vs cat5e vs cat6 vs cat6a vs cat7 – Which Ethernet Cable to Use?
  • 15 Best Legal Torrenting Sites to Download Content Safely
  • Review of the ReMarkable 2.0 tablet with Type Folio keyboard
  • Flixable Helps You Find the Best Movies and TV shows on Netflix
DMCA.com Protection Status

Recent Posts

  • 6 Simple Hacks To Access Blocked Websites
  • How to Watch Netflix in 1080p on Chrome and FireFox
  • cat5 vs cat5e vs cat6 vs cat6a vs cat7 Which Ethernet Cable to Use?
  • 15 Best Legal Torrenting Sites to Download Content Safely
  • Review of the ReMarkable 2.0 tablet with Type Folio keyboard

Recent Comments

  1. Flixable Helps You Find the Best Movies and TV shows on Netflix on SmartDNS vs VPN “What’s the Difference?”
  2. 5 Sites That Are Like Audible, But Free on Top 4 Amazon Price Tracker Tools
  3. 5 Sites That Are Like Audible, But Free on 14 Best Free Audiobooks on Audible – 2022
  4. How to Reduce PNG File Size of a Photo on How to Convert a Screenshot to a Jpeg on a Mac
  5. 3 Sites like YouTube to Earn Money With Your Videos on Here are the Top 10 highest paid YouTubers of 2013
  • All Firestick Remote Shortcuts You Should Know About How-To
  • 10 Chrome Extensions to Supercharge Your Netflix Experience How-To
  • The 6 Best Sites for Fantasy Baseball Cool Websites
  • The male army height weight chart 2018

    The army height weight chart only for male or man in 2018. For more information visit : Army Maximum Body Fat Standards for Men Age 17-20 = 20 %

  • 6 Best Apps for Automated Social Media Posting Reviews
  • The Best MacOS Automator Scripts You Should Have Installed OS X
  • How to Set Alarms and Timers on your Mac Tutorials
  • Link Cells Between Sheets and Workbooks In Excel MS Office Tips

Copyright © 2023 How To Blog.

Powered by PressBook News WordPress theme

Go to mobile version