Using SQL Server 2016 Upgrade Advisor

PREREQUISITES

PROCEDURE

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