Using SQL Server 2016 Upgrade Advisor



1. Launch Upgrade Advisor and select the option to ANALYZE AND MIGRATE TO SQL SERVER

Figure 1: Upgrade Advisor Splash Screen
  1. Migrate to Azure SQL Database
  2. Run in-memory OLTP and ColumnStore advisor
  3. Run stretch database advisor
  4. Analyze and Migrate to SQL Server

2. Connect to the desired instance

Figure 2: Select Instance

3. Select the desired database(s)

Figure 3: Select Database

4. Run the analyzer

Figure 4: Analyze Database

5. Analysis is complete

Figure 5: Complete Analysis

6. Review the results and export the report

Figure 6: Review Issues

7. Choose your preferred file type and click EXPORT

Figure 7: Export Results



Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store


Awesome blog focused on databases and Microsoft, .NET and cloud technologies.