page_type	languages	products	extensions
sample	csharp	azure	services platforms Sql dotnet

Getting started on managing SQL databases across regions in C#

Azure Storage sample for managing SQL Database -

• Create 3 SQL Servers in different region.
• Create a master database in master SQL Server.
• Create 2 more SQL Servers in different azure regions
• Create secondary read only databases in these server with source as database in server created in step 1.
• Create 5 virtual networks in different regions.
• Create one VM in each of the virtual network.
• Update all three databases to have firewall rules with range of each of the virtual network.

Running this Sample

To run this sample:

Set the environment variable AZURE_AUTH_LOCATION with the full path for an auth file. See how to create an auth file.

git clone https://github.com/Azure-Samples/sql-database-dotnet-manage-sql-databases-across-regions.git

cd sql-database-dotnet-manage-sql-databases-across-regions

dotnet build

bin\Debug\net452\ManageSqlDatabasesAcrossDifferentDataCenters.exe

More information

Azure Management Libraries for C# Azure .Net Developer Center If you don't have a Microsoft Azure subscription you can get a FREE trial account here

---

This project has adopted the Microsoft Open Source Code of Conduct. For more information see the Code of Conduct FAQ or contact [email protected] with any additional questions or comments.