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

Getting started on managing SQL server DNS aliases in C#

Primary LanguageC#MIT LicenseMIT

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.