Microsoft.Azure.Management.Sql 1.7.0-preview

Azure SQL Management SDK library

This is a prerelease version of Microsoft.Azure.Management.Sql.
There is a newer prerelease version of this package available.
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" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add Microsoft.Azure.Management.Sql --version 1.7.0-preview
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

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

GitHub repositories (4+)

Showing the top 4 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.
Mimetis/Dotmim.Sync
A brand new database synchronization, multi platform, multi databases, developed on top of .Net Standard 2.0. https://dotmimsync.readthedocs.io/
microsoft/sqltoolsservice
SQL Tools API service that provides SQL Server data management capabilities.

Version History

Version Downloads Last updated
1.43.0-preview 1,534 6/18/2020
1.42.0-preview 4,242 5/20/2020
1.41.0-preview 26,129 3/13/2020
1.40.0-preview 2,421 3/3/2020
1.38.0-preview 750 2/29/2020
1.37.0-preview 13,191 11/15/2019
1.36.0-preview 13,688 9/23/2019
1.35.0-preview 1,768 9/6/2019
1.34.0-preview 17,147 9/3/2019
1.33.0-preview 12,702 7/22/2019
1.32.0-preview 175 7/16/2019
1.31.0-preview 27,194 4/29/2019
1.29.0-preview 3,820 4/3/2019
1.28.0-preview 14,249 2/13/2019
1.27.0-preview 2,829 1/29/2019
1.25.0-preview 9,668 12/19/2018
1.24.0-preview 30,785 11/26/2018
1.23.0-preview 385 11/15/2018
1.22.0-preview 39,875 10/31/2018
1.21.0-preview 268 10/24/2018
1.20.2-preview 234 11/2/2018
1.20.1-preview 1,422 9/28/2018
1.20.0-preview 508 9/11/2018
1.19.0-preview 2,834 8/1/2018
1.18.1-preview 528 10/27/2018
1.18.0-preview 26,393 6/21/2018
1.17.0-preview 916 6/18/2018
1.16.0-preview 3,060 5/24/2018
1.15.0-preview 3,015 4/19/2018
1.14.0-preview 390 4/18/2018
1.13.1-preview 450 4/23/2018
1.13.0-preview 9,288 3/19/2018
1.12.0-preview 7,924 2/20/2018
1.11.0-preview 9,269 1/12/2018
1.10.0-preview 3,222 11/17/2017
1.9.0-preview 496 11/10/2017
1.8.0-preview 21,884 10/26/2017
1.7.0-preview 8,008 9/27/2017
1.6.0-preview 12,572 7/7/2017
1.5.0-preview 89,168 6/12/2017
1.3.0-preview 11,669 4/25/2017
1.2.0-preview 6,574 3/23/2017
1.1.0-preview 1,233 3/3/2017
0.55.1-prerelease 5,637 3/23/2017
0.55.0-prerelease 4,422 3/3/2017
0.54.0-prerelease 2,246 2/21/2017
0.53.0-prerelease 2,010 2/16/2017
0.52.0-prerelease 534 2/9/2017
0.51.0-prerelease 16,371 12/5/2016
0.50.0-prerelease 19,969 8/22/2016
0.49.0-prerelease 18,205 8/4/2016
0.48.0-prerelease 2,977 7/19/2016
0.47.0-prerelease 2,485 6/17/2016
0.46.0-prerelease 18,170 4/1/2016
0.45.0-prerelease 3,565 2/25/2016
0.44.0-prerelease 965 2/23/2016
0.43.0-prerelease 5,894 12/14/2015
0.42.0-prerelease 442 12/8/2015
0.41.0-prerelease 2,658 11/6/2015
0.40.0-prerelease 451 11/3/2015
0.39.0-prerelease 3,171 10/13/2015
0.38.0-prerelease 4,568 9/9/2015
0.37.0-prerelease 1,265 8/24/2015
0.36.0-prerelease 699 8/13/2015
0.35.0-prerelease 531 8/11/2015
0.34.0-prerelease 824 7/31/2015
0.33.0-prerelease 470 7/31/2015
0.32.0-prerelease 936 7/29/2015
0.31.0-prerelease 427 7/28/2015
0.30.0-prerelease 425 7/27/2015
0.29.0-prerelease 1,772 6/20/2015
0.28.0-prerelease 516 6/17/2015
0.26.0-prerelease 997 5/14/2015
0.25.0-prerelease 692 5/4/2015
0.22.0-prerelease 623 4/29/2015
0.21.0-prerelease 473 4/20/2015
0.20.0-prerelease 889 3/25/2015
0.19.0-prerelease 418 3/18/2015
0.18.0-prerelease 574 3/5/2015
0.17.0-prerelease 1,288 2/19/2015
0.16.2-prerelease 1,354 2/4/2015
0.16.1-prerelease 507 1/30/2015
0.16.0-prerelease 1,222 1/8/2015
0.15.0-prerelease 519 1/6/2015
0.14.3-prerelease 955 11/25/2014
0.14.2-prerelease 609 11/11/2014
0.14.1-prerelease 929 11/3/2014
0.14.0-prerelease 1,400 10/31/2014
0.12.0-prerelease 3,338 9/15/2014
0.11.1-prerelease 1,273 9/4/2014
0.11.0-prerelease 857 8/19/2014
0.10.0-prerelease 467 8/8/2014
0.9.1-prerelease 438 8/5/2014
0.9.0-prerelease 491 7/10/2014
Show less