Use SSMs 2014 to migrate your on-premises databases to Azure SQL database

Source: Internet
Author: User
Tags management studio sql server management sql server management studio sql server management studio 2014

The process of migrating the on-premises database to Azure SQL database using SQL Server Management Studio 2014 is straightforward, and in SSMS2014, there is a task option to deploy the database to Windows Azure SQL Database ":

Use this option to migrate one-click to Azure SQL Database. However, recently due to recent changes in Azure, the database types supported by Azure do not match the types of databases in SSMS2014, and the entire migration process will die on the steps to create the database in Azue. In the international version of Azure, both Web and bussiness database types are not supported, and in the Chinese version of Azure, both types are expiring, but the types of databases in SMSS2014 do not provide options other than these. Therefore, the route "deploy database to Windows Azure SQL" is not available for the time being.

Another way to do this is to save the local database file to Azure blog and then import it in Azure SQL database, with the following summary steps:

1. In SSMS2014, select the database to be migrated, select Export data-tier application, and save the file as a. dacpac file.

2. In Visual Studio 2015, open the Server Explorer pane, connect Azure to your Azure subscription, then create a storage account, create a blog, create a container, and then upload the exported. dacpac file to the container.

3. In the Azure Portal, create a new SQL Database and select Import.

Of course, if it is in the international version of Azure, 1th 2nd step can be combined into one step, will be data file. Dacpac is directly exported and saved to azure storage, and in the Chinese version of Azure, its default resource-oriented login.windows.net, so without modification, You cannot log on directly to the Azue and save the. Dacpac to Azure storage.

Use SSMs 2014 to migrate your on-premises databases to Azure SQL database

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.