Azure SQL Database (20) using SQL Server Upgrade Advisor

Windows Azure Platform Family of articles Catalog

　　

　　In the previous section, we briefly introduced the Azure Stretch Database

Azure SQL Database Stretch Database Overview

This section describes how to use SQL Server Upgrade Advisor to evaluate the relevant data tables for a local SQL server 2016 database and whether you can migrate to Azure SQL Stretch.

Prerequisites for the content of this section:

(1) SQL Server 2016

　　https://www.microsoft.com/zh-cn/evalcenter/evaluate-sql-server-2016

(2) SQL Server Upgrade Advisor

　　https://www.microsoft.com/en-us/download/details.aspx?id=48119

(3) Sample Database

　　https://www.microsoft.com/en-us/download/details.aspx?id=49502

　　(4) SQL Server Management Studio

　　http://go.microsoft.com/fwlink/?LinkID=824938

(1) First we install SQL Server 2016 in local Windows 10

(2) Installing SQL Server Upgrade Advisor

(3) This database will be ADVENTUREWORKS2016CTP3 and restored in local SQL Server 2016

1. Then we run SQL Server Upgrade Advisor

2. Click Scneadios,run Stretch Database Advisor, such as:

　　

　　

3. Then click Select Database to Analyze, then select the appropriate databases and login options, such as:

　　

　　

4. Click Connect, then select the database to be analyzed, here we choose ADVENTUREWORKS2016CTP3

　　

　　5. Once the database is selected, we can run it for analysis. Such as:

　　

　　

6. After the operation is complete, the advisor will tell us the results of the analysis data sheet. Such as:

　　

, the red exclamation mark indicates that the table could not be migrated to Azure Stretch Database, which could cause compatibility issues.

For the limitations of Azure Stretch database, refer to:

　　https://azure.microsoft.com/en-us/documentation/articles/sql-server-stretch-database-limitations/

7. Of course, we can also find that some tables can be migrated directly to Azure Stretch database, such as sales.ordertraking

　　

In the next section, we'll show you how to migrate sales.ordertraking to Azure SQL Stretch database in detail.

　　

Azure SQL Database (20) using SQL Server Upgrade Advisor