page_type	languages	products	extensions
sample	csharp	azure	services platforms Sql dotnet

Getting started on managing SQL server DNS aliases in C#

Azure SQL sample for managing SQL Server DNS Aliases.

• Create two SQL Servers "test" and "production", each with an empty database.
• Create a new table and insert some expected values into each database.
• Create a SQL Server DNS Alias to the "test" SQL database.
• Query the "test" SQL database via the DNS alias and print the result.
• Use the SQL Server DNS alias to acquire the "production" SQL database.
• Query the "production" SQL database via the DNS alias and print the result.
• Delete the SQL Servers

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-server-dns-aliases.git

cd sql-database-dotnet-manage-sql-server-dns-aliases

dotnet build

bin\Debug\net452\ManageSqlServerDnsAliases.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 opencode@microsoft.com with any additional questions or comments.