Microsoft.Azure.Management.Sql
1.7.0-preview
Azure SQL Management SDK library
See the version list below for details.
Install-Package Microsoft.Azure.Management.Sql -Version 1.7.0-preview
dotnet add package Microsoft.Azure.Management.Sql --version 1.7.0-preview
<PackageReference Include="Microsoft.Azure.Management.Sql" Version="1.7.0-preview" />
paket add Microsoft.Azure.Management.Sql --version 1.7.0-preview
#r "nuget: Microsoft.Azure.Management.Sql, 1.7.0-preview"
// Install Microsoft.Azure.Management.Sql as a Cake Addin
#addin nuget:?package=Microsoft.Azure.Management.Sql&version=1.7.0-preview&prerelease
// Install Microsoft.Azure.Management.Sql as a Cake Tool
#tool nuget:?package=Microsoft.Azure.Management.Sql&version=1.7.0-preview&prerelease
Release Notes
Disclaimer:
We were using a slightly unorthodox convention for some operation ids. Some resource operations were “nested” inside others, e.g. blob auditing policies was nested inside databases as in client.Databases.GetBlobAuditingPolicies(..) instead of the flattened ARM standard client.DatabaseBlobAuditingPolicies.Get(…).
This convention has lead to some inconsistencies, makes some APIs difficult to find, and is at odds with future APIs. For example if we wanted to implement listing db audit policies by server, continuing the current convention would be client.Databases.ListBlobAuditingPoliciesByServer(..) which makes much less sense than the ARM standard which would be client.DatabaseBlobAuditingPolicies.ListByServer(…)`.
In order to resolve this and provide a good path moving forward, we have renamed the inconsistent operations to follow the ARM standard. This is an unfortunate breaking change, but it’s best to do now while the SDK is still in preview and since most of these operations were only recently added.
Breaking changes:
- SqlManagementClient.Database.GetBackupLongTermRetentionPolicy -> SqlManagementClient.BackupLongTermRetentionPolicies.Get
- SqlManagementClient.Database.CreateOrUpdateBackupLongTermRetentionPolicy -> SqlManagementClient.BackupLongTermRetentionPolicies.CreateOrUpdate
- SqlManagementClient.Servers.CreateBackupLongTermRetentionVault -> SqlManagementClient.BackupLongTermRetentionVaults.CreateOrUpdate
- SqlManagementClient.Servers.GetBackupLongTermRetentionVault -> SqlManagementClient.BackupLongTermRetentionVaults.Get
- SqlManagementClient.Database.ListRestorePoints -> SqlManagementClient.RestorePoints.ListByDatabase
- SqlManagementClient.Servers.CreateOrUpdateConnectionPolicy -> SqlManagementClient.ServerConnectionPolicies.CreateOrUpdate
- SqlManagementClient.Servers.GetConnectionPolicy -> SqlManagementClient.ServerConnectionPolicies.Get
- SqlManagementClient.Databases.CreateOrUpdateDataMaskingPolicy -> SqlManagementClient.DataMaskingPolicies.CreateOrUpdate
- SqlManagementClient.Databases.GetDataMaskingPolicy -> SqlManagementClient.DataMaskingPolicies.Get
- SqlManagementClient.Databases.CreateOrUpdateDataMaskingRule -> SqlManagementClient.DataMaskingRules.CreateOrUpdate
- SqlManagementClient.Databases.GetDataMaskingRule -> SqlManagementClient.DataMaskingRules.Get
- SqlManagementClient.Databases.ListDataMaskingRules -> SqlManagementClient.DataMaskingRules.ListByDatabase
- SqlManagementClient.Databases.GetThreatDetectionPolicy -> SqlManagementClient.DatabaseThreatDetectionPolicies.Get
- SqlManagementClient.Databases.CreateOrUpdateThreatDetectionPolicy -> SqlManagementClient.DatabaseThreatDetectionPolicies.CreateOrUpdate
- SqlManagementClient.Databases.CreateOrUpdateGeoBackupPolicy -> SqlManagementClient.GeoBackupPolicies.CreateOrUpdate
- SqlManagementClient.Databases.GetGeoBackupPolicy -> SqlManagementClient.GeoBackupPolicies.Get
- SqlManagementClient.Databases.ListGeoBackupPolicies -> SqlManagementClient.GeoBackupPolicies.ListByDatabase
- SqlManagementClient.Databases.DeleteReplicationLink -> SqlManagementClient.ReplicationLinks.Delete
- SqlManagementClient.Databases.GetReplicationLink -> SqlManagementClient.ReplicationLinks.Get
- SqlManagementClient.Databases.FailoverReplicationLink -> SqlManagementClient.ReplicationLinks.Failover
- SqlManagementClient.Databases.FailoverReplicationLinkAllowDataLoss -> SqlManagementClient.ReplicationLinks.FailoverAllowDataLoss
- SqlManagementClient.Databases.ListReplicationLinks -> SqlManagementClient.ReplicationLinks.ListByDatabase
- SqlManagementClient.ServerAzureADAdministrators.List -> SqlManagementClient.ServerAzureADAdministrators.ListByServer
- SqlManagementClient.Servers.GetServiceObjective -> SqlManagementClient.ServiceObjectives.Get
- SqlManagementClient.Servers.ListServiceObjectives -> SqlManagementClient.ServiceObjectives.ListByServer
- SqlManagementClient.ElasticPools.ListActivity -> SqlManagementClient.ElasticPoolActivities.ListByElasticPool
- SqlManagementClient.ElasticPools.ListDatabaseActivity -> SqlManagementClient.ElasticPoolDatabaseActivities.ListByElasticPool
- SqlManagementClient.ElasticPools.GetDatabase -> SqlManagementClient.Databases.GetByElasticPool
- SqlManagementClient.ElasticPools.ListDatabases -> SqlManagementClient.Databases.ListByElasticPool
- SqlManagementClient.RecommendedElasticPools.GetDatabases -> SqlManagementClient.Databases.GetByRecommendedElasticPool
- SqlManagementClient.RecommendedElasticPools.ListDatabases -> SqlManagementClient.Databases.ListByRecommendedElasticPool
- SqlManagementClient.Databases.GetServiceTierAdvisor -> SqlManagementClient.ServiceTierAdvisors.Get
- SqlManagementClient.Databases.ListServiceTierAdvisors -> SqlManagementClient.ServiceTierAdvisors.ListByDatabase
- SqlManagementClient.Databases.CreateOrUpdateTransparentDataEncryptionConfiguration -> SqlManagementClient.TransparentDataEncryptions.CreateOrUpdate
- SqlManagementClient.Databases.GetTransparentDataEncryptionConfiguration -> SqlManagementClient.TransparentDataEncryptions.Get
- SqlManagementClient.Databases.ListTransparentDataEncryptionActivity -> SqlManagementClient.TransparentDataEncryptionActivities.ListByConfiguration
- SqlManagementClient.Servers.ListUsages -> SqlManagementClient.ServerUsages.ListByServer
- SqlManagementClient.Databases.ListUsages -> SqlManagementClient.DatabaseUsages.ListByDatabase
- SqlManagementClient.Databases.GetBlobAuditingPolicy -> SqlManagementClient.DatabaseBlobAuditingPolicies.Get
- SqlManagementClient.Databases.CreateOrUpdateBlobAuditingPolicy -> SqlManagementClient.DatabaseBlobAuditingPolicies.CreateOrUpdate
- SqlManagementClient.Servers.ListEncryptionProtectors, -> SqlManagementClient.EncryptionProtectors.ListByServer
- SqlManagementClient.Servers.GetEncryptionProtector -> SqlManagementClient.EncryptionProtectors.Get
- SqlManagementClient.Servers.CreateOrUpdateEncryptionProtector -> SqlManagementClient.EncryptionProtectors.CreateOrUpdate
Features:
- Added server connection policy support
- Added .Update() for Server, Database, and ElasticPool
- Added support for Data Sync
- Added support for getting and canceling in-progress database update operations
- client.Operations.List() now returnes a full list of operations and not a limited subset
Dependencies
-
.NETFramework 4.5.2
- Microsoft.Rest.ClientRuntime (>= 2.3.10 && < 3.0.0)
- Microsoft.Rest.ClientRuntime.Azure (>= 3.3.10 && < 4.0.0)
- Newtonsoft.Json (>= 6.0.8)
-
.NETStandard 1.4
- Microsoft.Rest.ClientRuntime (>= 2.3.10 && < 3.0.0)
- Microsoft.Rest.ClientRuntime.Azure (>= 3.3.10 && < 4.0.0)
- NETStandard.Library (>= 1.6.1)
- Newtonsoft.Json (>= 9.0.1)
- System.Net.Http (>= 4.3.0)
Used By
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories (3)
Showing the top 3 popular GitHub repositories that depend on Microsoft.Azure.Management.Sql:
Repository | Stars |
---|---|
Azure/azure-powershell
Microsoft Azure PowerShell
|
|
Azure/azure-sdk-for-net
This repository is for active development of the Azure SDK for .NET. For consumers of the SDK we recommend visiting our public developer docs at https://docs.microsoft.com/en-us/dotnet/azure/ or our versioned developer docs at https://azure.github.io/azure-sdk-for-net.
|
|
microsoft/sqltoolsservice
SQL Tools API service that provides SQL Server data management capabilities.
|
Version History
Version | Downloads | Last updated |
---|---|---|
1.50.0-preview | 968 | 3/15/2021 |
1.48.0-preview | 16,718 | 12/19/2020 |
1.47.0-preview | 3,653 | 11/3/2020 |
1.46.0-preview | 2,503 | 10/30/2020 |
1.45.0-preview | 5,172 | 10/9/2020 |
1.44.2-preview | 23,310 | 9/9/2020 |
1.44.1-preview | 1,196 | 9/2/2020 |
1.44.0-preview | 5,170 | 8/24/2020 |
1.43.0-preview | 21,639 | 6/18/2020 |
1.42.0-preview | 10,276 | 5/20/2020 |
1.41.0-preview | 268,449 | 3/13/2020 |
1.40.0-preview | 2,596 | 3/3/2020 |
1.38.0-preview | 872 | 2/29/2020 |
1.37.0-preview | 14,067 | 11/15/2019 |
1.36.0-preview | 22,375 | 9/23/2019 |
1.35.0-preview | 3,949 | 9/6/2019 |
1.34.0-preview | 21,117 | 9/3/2019 |
1.33.0-preview | 16,863 | 7/22/2019 |
1.32.0-preview | 294 | 7/16/2019 |
1.31.0-preview | 33,180 | 4/29/2019 |
1.29.0-preview | 3,935 | 4/3/2019 |
1.28.0-preview | 18,762 | 2/13/2019 |
1.27.0-preview | 3,031 | 1/29/2019 |
1.25.0-preview | 15,092 | 12/19/2018 |
1.24.0-preview | 35,011 | 11/26/2018 |
1.23.0-preview | 677 | 11/15/2018 |
1.22.0-preview | 69,773 | 10/31/2018 |
1.21.0-preview | 469 | 10/24/2018 |
1.20.2-preview | 412 | 11/2/2018 |
1.20.1-preview | 2,330 | 9/28/2018 |
1.20.0-preview | 824 | 9/11/2018 |
1.19.0-preview | 3,759 | 8/1/2018 |
1.18.1-preview | 706 | 10/27/2018 |
1.18.0-preview | 28,111 | 6/21/2018 |
1.17.0-preview | 1,464 | 6/18/2018 |
1.16.0-preview | 3,794 | 5/24/2018 |
1.15.0-preview | 3,299 | 4/19/2018 |
1.14.0-preview | 571 | 4/18/2018 |
1.13.1-preview | 650 | 4/23/2018 |
1.13.0-preview | 12,589 | 3/19/2018 |
1.12.0-preview | 10,415 | 2/20/2018 |
1.11.0-preview | 10,386 | 1/12/2018 |
1.10.0-preview | 3,444 | 11/17/2017 |
1.9.0-preview | 683 | 11/10/2017 |
1.8.0-preview | 26,953 | 10/26/2017 |
1.7.0-preview | 9,266 | 9/27/2017 |
1.6.0-preview | 15,438 | 7/7/2017 |
1.5.0-preview | 90,262 | 6/12/2017 |
1.3.0-preview | 12,807 | 4/25/2017 |
1.2.0-preview | 7,621 | 3/23/2017 |
1.1.0-preview | 1,468 | 3/3/2017 |
0.55.1-prerelease | 7,194 | 3/23/2017 |
0.55.0-prerelease | 6,435 | 3/3/2017 |
0.54.0-prerelease | 2,786 | 2/21/2017 |
0.53.0-prerelease | 2,237 | 2/16/2017 |
0.52.0-prerelease | 717 | 2/9/2017 |
0.51.0-prerelease | 22,194 | 12/5/2016 |
0.50.0-prerelease | 22,375 | 8/22/2016 |
0.49.0-prerelease | 19,080 | 8/4/2016 |
0.48.0-prerelease | 3,180 | 7/19/2016 |
0.47.0-prerelease | 2,735 | 6/17/2016 |
0.46.0-prerelease | 22,653 | 4/1/2016 |
0.45.0-prerelease | 3,984 | 2/25/2016 |
0.44.0-prerelease | 1,146 | 2/23/2016 |
0.43.0-prerelease | 8,184 | 12/14/2015 |
0.42.0-prerelease | 620 | 12/8/2015 |
0.41.0-prerelease | 3,048 | 11/6/2015 |
0.40.0-prerelease | 632 | 11/3/2015 |
0.39.0-prerelease | 4,245 | 10/13/2015 |
0.38.0-prerelease | 5,932 | 9/9/2015 |
0.37.0-prerelease | 1,460 | 8/24/2015 |
0.36.0-prerelease | 886 | 8/13/2015 |
0.35.0-prerelease | 707 | 8/11/2015 |
0.34.0-prerelease | 1,046 | 7/31/2015 |
0.33.0-prerelease | 645 | 7/31/2015 |
0.32.0-prerelease | 1,125 | 7/29/2015 |
0.31.0-prerelease | 605 | 7/28/2015 |
0.30.0-prerelease | 605 | 7/27/2015 |
0.29.0-prerelease | 1,943 | 6/20/2015 |
0.28.0-prerelease | 703 | 6/17/2015 |
0.26.0-prerelease | 1,188 | 5/14/2015 |
0.25.0-prerelease | 870 | 5/4/2015 |
0.22.0-prerelease | 812 | 4/29/2015 |
0.21.0-prerelease | 661 | 4/20/2015 |
0.20.0-prerelease | 1,070 | 3/25/2015 |
0.19.0-prerelease | 586 | 3/18/2015 |
0.18.0-prerelease | 767 | 3/5/2015 |
0.17.0-prerelease | 1,489 | 2/19/2015 |
0.16.2-prerelease | 1,643 | 2/4/2015 |
0.16.1-prerelease | 709 | 1/30/2015 |
0.16.0-prerelease | 1,416 | 1/8/2015 |
0.15.0-prerelease | 718 | 1/6/2015 |
0.14.3-prerelease | 1,146 | 11/25/2014 |
0.14.2-prerelease | 798 | 11/11/2014 |
0.14.1-prerelease | 1,126 | 11/3/2014 |
0.14.0-prerelease | 1,587 | 10/31/2014 |
0.12.0-prerelease | 3,533 | 9/15/2014 |
0.11.1-prerelease | 1,466 | 9/4/2014 |
0.11.0-prerelease | 1,046 | 8/19/2014 |
0.10.0-prerelease | 654 | 8/8/2014 |
0.9.1-prerelease | 629 | 8/5/2014 |
0.9.0-prerelease | 681 | 7/10/2014 |