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

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