Updating sql server 2016

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.As this is beta software, I suggest testing this in a virtual machine or non-production, non-critical workstation.

After CU 2 for SQL Server 2016 is released you'll need to navigate to the Microsoft Windows Update Catalog to download CU1.

However Microsoft always recommends downloading, testing, and applying the latest CUs, Service Packs, and Hotfixes for SQL Server 2016.

There are two basic strategies for upgrading to the new release: Each method has its advantages and disadvantages.

People who prefer the clean upgrade appreciate that it eliminates the registry and system corruption that eventually creeps into all Windows installations.

Download the latest version of the Visual Studio add-in (for both 3.5, 4.0 and SQLite) from Visual Studio Market Place Follow me on Twitter: @Erik EJ Add-in version 4.4 - November 2015 - Modern look and improved Visual Studio integration* SQL Server Compact Toolbox 4.4 For similar functionality in SQL Server Management Studio and from a command line, use my SQL Compact Scripting Utility Project on Code Plex.