Azure SQL Database (20) using SQL Server Upgrade Advisor

Source: Internet
Author: User
Tags how to use sql server how to use sql management studio sql server management sql server management studio

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.