/// <summary> /// Checks whether the server is applicable for threat detection /// </summary> private bool IsRightServerVersionForThreatDetection(string resourceGroupName, string serverName) { AzureSqlServerCommunicator dbCommunicator = new AzureSqlServerCommunicator(Context); Management.Sql.Models.Server server = dbCommunicator.Get(resourceGroupName, serverName); return(server.Version == "12.0"); }
/// <summary> /// Checks whether the server is applicable for dynamic data masking /// </summary> private bool IsRightServerVersionForDataMasking(string resourceGroupName, string serverName, string clientId) { AzureSqlServerCommunicator dbCommunicator = new AzureSqlServerCommunicator(Context); Management.Sql.Models.Server server = dbCommunicator.Get(resourceGroupName, serverName, clientId); return(server.Version == "12.0"); }
/// <summary> /// Convert a Management.Sql.LegacySdk.Models.Server to AzureSqlDatabaseServerModel /// </summary> /// <param name="resourceGroupName">The resource group the server is in</param> /// <param name="resp">The management client server response to convert</param> /// <returns>The converted server model</returns> private static AzureSqlServerModel CreateServerModelFromResponse(Management.Sql.Models.Server resp) { AzureSqlServerModel server = new AzureSqlServerModel(); // Extract the resource group name from the ID. // ID is in the form: // /subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/rgName/providers/Microsoft.Sql/servers/serverName string[] segments = resp.Id.Split('/'); server.ResourceGroupName = segments[4]; server.ServerName = resp.Name; server.ServerVersion = resp.Version; server.SqlAdministratorLogin = resp.AdministratorLogin; server.Location = resp.Location; server.Tags = TagsConversionHelper.CreateTagDictionary(TagsConversionHelper.CreateTagHashtable(resp.Tags), false); server.Identity = resp.Identity; server.FullyQualifiedDomainName = resp.FullyQualifiedDomainName; server.ResourceId = resp.Id; server.MinimalTlsVersion = resp.MinimalTlsVersion; server.PublicNetworkAccess = resp.PublicNetworkAccess; server.RestrictOutboundNetworkAccess = resp.RestrictOutboundNetworkAccess; server.Administrators = resp.Administrators; if (server.Administrators != null && server.Administrators.AdministratorType == null) { server.Administrators.AdministratorType = "ActiveDirectory"; } server.PrimaryUserAssignedIdentityId = resp.PrimaryUserAssignedIdentityId; server.KeyId = resp.KeyId; server.FederatedClientId = resp.FederatedClientId; return(server); }
/// <summary> /// Convert a Management.Sql.LegacySdk.Models.Server to AzureSqlDatabaseServerModel /// </summary> /// <param name="resourceGroupName">The resource group the server is in</param> /// <param name="resp">The management client server response to convert</param> /// <returns>The converted server model</returns> private static AzureSqlServerModel CreateServerModelFromResponse(Management.Sql.Models.Server resp) { AzureSqlServerModel server = new AzureSqlServerModel(); // Extract the resource group name from the ID. // ID is in the form: // /subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/rgName/providers/Microsoft.Sql/servers/serverName string[] segments = resp.Id.Split('/'); server.ResourceGroupName = segments[4]; server.ServerName = resp.Name; server.ServerVersion = resp.Version; server.SqlAdministratorLogin = resp.AdministratorLogin; server.Location = resp.Location; server.Tags = TagsConversionHelper.CreateTagDictionary(TagsConversionHelper.CreateTagHashtable(resp.Tags), false); server.Identity = resp.Identity; return(server); }
/// <summary> /// Convert a Management.Sql.LegacySdk.Models.Server to AzureSqlDatabaseServerModel /// </summary> /// <param name="resourceGroupName">The resource group the server is in</param> /// <param name="resp">The management client server response to convert</param> /// <returns>The converted server model</returns> private static AzureSqlServerModel CreateServerModelFromResponse(string resourceGroupName, Management.Sql.Models.Server resp) { AzureSqlServerModel server = new AzureSqlServerModel(); server.ResourceGroupName = resourceGroupName; server.ServerName = resp.Name; server.ServerVersion = resp.Version; server.SqlAdministratorLogin = resp.AdministratorLogin; server.Location = resp.Location; server.Tags = TagsConversionHelper.CreateTagDictionary(TagsConversionHelper.CreateTagHashtable(resp.Tags), false); return(server); }
/// <summary> /// Convert a Management.Sql.Models.Server to AzureSqlDatabaseServerModel /// </summary> /// <param name="resourceGroupName">The resource group the server is in</param> /// <param name="resp">The management client server response to convert</param> /// <returns>The converted server model</returns> private static AzureSqlServerModel CreateServerModelFromResponse(string resourceGroupName, Management.Sql.Models.Server resp) { AzureSqlServerModel server = new AzureSqlServerModel(); server.ResourceGroupName = resourceGroupName; server.ServerName = resp.Name; server.ServerVersion = resp.Properties.Version; server.SqlAdministratorLogin = resp.Properties.AdministratorLogin; server.Location = resp.Location; return(server); }
/// <summary> /// Creates or updates a Azure Sql Database SErver /// </summary> public Management.Sql.Models.Server CreateOrUpdate(string resourceGroupName, string serverName, string clientRequestId, Management.Sql.Models.Server parameters) { return(GetCurrentSqlClient(clientRequestId).Servers.CreateOrUpdate(resourceGroupName, serverName, parameters)); }