Shulou(Shulou.com)05/31 Report--

This article mainly introduces the database SQL Azure how to migrate to the local SQL Server, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let Xiaobian take you to understand.

Use the SQLAzureMW tool to migrate SQL Database to local SQL Server. The requirement is the SQL Server2014 version and is not supported for SQL Server2008.

The methods are as follows:

First, select a Server on Azure and create our target database under it. If you need to display Chinese characters in the database without garbled code, please select "Chinese_PRC_CI_AS" as the collation:

Open SQL Server Management Studio (SSMS) and connect to the Server of the local source database and the Server of the target database on Azure, respectively. Our goal is to migrate the local n_db1 database to the n_db2 database on Azure:

When we open the software, our goal is to migrate (import and export) the database, so select the "database" item of "analyze and migrate"

In the "Target Server" column, when migrating to Azure SQL Database, if the Server of the target database on Azure is V11, then we select "SQL Database". If the Server of the target database on Azure is V12, then select "the latest service version of SQL database (Section 12)":

(figure 1)

For the Server version of the target database on Azure, we can query it on Portal:

In figure 1, we click next, log in to the local server, click Connect, select the n_db1 database, and click next:

When you see the following figure, please click the advanced options to set it. In the "generate Table / data" column in "Table / View options", select "Table structure and data", and click OK, otherwise it will be incomplete during migration:

Go all the way, click next, select "Yes", and click next when the SQL script is generated successfully:

Here is the selection of SQL Server and Database on Azure (please note how the user name is written and specify the target database in the Database column):

Get the results of the above picture and exit.

We went back to SSMS to look at the target database on the Azure that we migrated to, and found that the files in the source database n_db1 have been migrated to the target database n_db2 on Azure:

Thank you for reading this article carefully. I hope the article "how to migrate database SQL Azure to local SQL Server" shared by the editor will be helpful to you. At the same time, I also hope you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.