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

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 intended 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.
Mimetis/Dotmim.Sync
A brand new database synchronization, multi platform, multi databases, developed on top of .Net Standard 2.0. https://mimetis.github.io/Dotmim.Sync/

Version History

Version Downloads Last updated
1.37.0-preview 174 11/15/2019
1.36.0-preview 6,983 9/23/2019
1.35.0-preview 766 9/6/2019
1.34.0-preview 5,559 9/3/2019
1.33.0-preview 7,716 7/22/2019
1.32.0-preview 103 7/16/2019
1.31.0-preview 19,770 4/29/2019
1.29.0-preview 3,745 4/3/2019
1.28.0-preview 11,725 2/13/2019
1.27.0-preview 2,750 1/29/2019
1.25.0-preview 6,058 12/19/2018
1.24.0-preview 25,250 11/26/2018
1.23.0-preview 277 11/15/2018
1.22.0-preview 24,555 10/31/2018
1.21.0-preview 188 10/24/2018
1.20.2-preview 159 11/2/2018
1.20.1-preview 797 9/28/2018
1.20.0-preview 417 9/11/2018
1.19.0-preview 2,216 8/1/2018
1.18.1-preview 466 10/27/2018
1.18.0-preview 25,047 6/21/2018
1.17.0-preview 564 6/18/2018
1.16.0-preview 2,482 5/24/2018
1.15.0-preview 2,872 4/19/2018
1.14.0-preview 295 4/18/2018
1.13.1-preview 353 4/23/2018
1.13.0-preview 6,562 3/19/2018
1.12.0-preview 5,719 2/20/2018
1.11.0-preview 7,902 1/12/2018
1.10.0-preview 3,100 11/17/2017
1.9.0-preview 410 11/10/2017
1.8.0-preview 14,201 10/26/2017
1.7.0-preview 6,873 9/27/2017
1.6.0-preview 10,047 7/7/2017
1.5.0-preview 87,256 6/12/2017
1.3.0-preview 10,878 4/25/2017
1.2.0-preview 5,912 3/23/2017
1.1.0-preview 1,111 3/3/2017
0.55.1-prerelease 4,458 3/23/2017
0.55.0-prerelease 1,933 3/3/2017
0.54.0-prerelease 1,933 2/21/2017
0.53.0-prerelease 1,910 2/16/2017
0.52.0-prerelease 445 2/9/2017
0.51.0-prerelease 13,098 12/5/2016
0.50.0-prerelease 18,699 8/22/2016
0.49.0-prerelease 16,932 8/4/2016
0.48.0-prerelease 2,876 7/19/2016
0.47.0-prerelease 2,109 6/17/2016
0.46.0-prerelease 15,505 4/1/2016
0.45.0-prerelease 3,361 2/25/2016
0.44.0-prerelease 878 2/23/2016
0.43.0-prerelease 4,306 12/14/2015
0.42.0-prerelease 353 12/8/2015
0.41.0-prerelease 2,169 11/6/2015
0.40.0-prerelease 363 11/3/2015
0.39.0-prerelease 2,430 10/13/2015
0.38.0-prerelease 4,075 9/9/2015
0.37.0-prerelease 1,163 8/24/2015
0.36.0-prerelease 590 8/13/2015
0.35.0-prerelease 434 8/11/2015
0.34.0-prerelease 558 7/31/2015
0.33.0-prerelease 379 7/31/2015
0.32.0-prerelease 851 7/29/2015
0.31.0-prerelease 318 7/28/2015
0.30.0-prerelease 329 7/27/2015
0.29.0-prerelease 1,674 6/20/2015
0.28.0-prerelease 427 6/17/2015
0.26.0-prerelease 906 5/14/2015
0.25.0-prerelease 604 5/4/2015
0.22.0-prerelease 521 4/29/2015
0.21.0-prerelease 376 4/20/2015
0.20.0-prerelease 798 3/25/2015
0.19.0-prerelease 329 3/18/2015
0.18.0-prerelease 480 3/5/2015
0.17.0-prerelease 1,187 2/19/2015
0.16.2-prerelease 1,239 2/4/2015
0.16.1-prerelease 420 1/30/2015
0.16.0-prerelease 1,124 1/8/2015
0.15.0-prerelease 420 1/6/2015
0.14.3-prerelease 867 11/25/2014
0.14.2-prerelease 509 11/11/2014
0.14.1-prerelease 842 11/3/2014
0.14.0-prerelease 1,298 10/31/2014
0.12.0-prerelease 3,250 9/15/2014
0.11.1-prerelease 1,174 9/4/2014
0.11.0-prerelease 762 8/19/2014
0.10.0-prerelease 378 8/8/2014
0.9.1-prerelease 353 8/5/2014
0.9.0-prerelease 403 7/10/2014
Show less