Introduction to Global Azure SQL Server replica feature configuration

Introduction to Global Azure SQL Server replica feature configuration

In our previous articles, we introduced the backup, Recovery, Export, import, and other related features of global Azure SQL Server, and today we present a look at Global Azure SQL Server Database copy function, in fact, speaking of a copy of two words, the implication is backup, in the global Azure SQL Server copy configuration is actually the same as backup and export, import works like, The copy is a copy of the entire schema of the running global Azure SQL Server database, and then the replicated schema information is run on the specified SQL Server server, so it is relatively well understood, see the following

We still use the original environment to demonstrate, open the database----click Copy

650) this.width=650; "title=" clip_image002 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "border=" 0 "alt = "clip_image002" src= "http://s3.51cto.com/wyfs02/M02/79/06/wKiom1aE9i2Sq1iEAABtIzwVmrk266.jpg" height= "317"/> And then

Then define the database name--à and then select the target server, and we define the option to create a new SQL Serer database

650) this.width=650; "title=" clip_image004 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "border=" 0 "alt = "clip_image004" src= "http://s3.51cto.com/wyfs02/M02/79/06/wKiom1aE9i6B37giAAB_IcP2t4U374.jpg" height= "418"/>

Define a new SQL Server database server

650) this.width=650; "title=" clip_image006 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "border=" 0 "alt = "clip_image006" src= "http://s3.51cto.com/wyfs02/M00/79/04/wKioL1aE9k2wtq_FAACQMv3AufA231.jpg" height= "425"/>

Once defined, we click OK

650) this.width=650; "title=" clip_image008 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "border=" 0 "alt = "clip_image008" src= "http://s3.51cto.com/wyfs02/M00/79/06/wKiom1aE9jSQbAKPAABq3BKSx9g608.jpg" height= "417"/>

Prompt to start creating a new server

650) this.width=650; "title=" clip_image010 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "border=" 0 "alt = "clip_image010" src= "http://s3.51cto.com/wyfs02/M01/79/06/wKiom1aE9jXDdwyFAAB5n8g-kHA753.jpg" height= "344"/>

The new database copy is already working

650) this.width=650; "title=" clip_image012 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "border=" 0 "alt = "clip_image012" src= "http://s3.51cto.com/wyfs02/M01/79/04/wKioL1aE9lWjV2NEAABVcRthMZo217.jpg" height= "211"/>

We define the firewall to allow the specified address to connect

650) this.width=650; "title=" clip_image014 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "border=" 0 "alt = "clip_image014" src= "http://s3.51cto.com/wyfs02/M02/79/04/wKioL1aE9lXTbN4rAABiE3dFYsI457.jpg" height= "303"/>

We connect through SQL Server Manage Studio;

After the connection, the view data structure is the same as the original.

650) this.width=650; "title=" clip_image016 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image016 "src=" http://s3.51cto.com/wyfs02/M02/79/04/wKioL1aE9lrzcjSoAAClswNSo7Y470.jpg "height=" 373 "/>

This article from "Gao Wenrong" blog, declined reprint!

Introduction to Global Azure SQL Server replica feature configuration