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