Updating sql server 2016 r2
Someone, somewhere, wants to know why they should take a perfectly good system that runs just fine and make a bunch of changes.
You may be using software from a third-party vendor that has strict requirements about which version of SQL Server you can use.
So, if you've decided to make the jump to SQL Server 2016, what's the best way to ensure a fast and smooth upgrade?
There are two basic strategies for upgrading to the new release: Each method has its advantages and disadvantages.
Plus, in many instances, you'll also be implementing a new version of Windows Server, something that requires a new operating system license.
When you are planning an upgrade to a new version of SQL Server, it is not always obvious what obstacles you might encounter during the actual upgrade.
First, you can download the Upgrade Advisor Preview 1 from here: This will download an MSI, which is a standard installer that will load the application onto your machine.For those folks running SQL Server 2000 instances (yes we KNOW you still exist) you are not able to upgrade directly to SQL Server 2016 without first upgrading to an intermediary version.Starting with SQL Server 2012 licensing is done per-core, not per-socket.As this is beta software, I suggest testing this in a virtual machine or non-production, non-critical workstation.Once installed, you will find "Microsoft SQL Server 2016 Upgrade Advisor" in your Start menu.