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 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/

Read more about the GitHub Usage information on our documentation.

Version History

Version Downloads Last updated
1.37.0-preview 3,672 11/15/2019
1.36.0-preview 10,047 9/23/2019
1.35.0-preview 883 9/6/2019
1.34.0-preview 6,112 9/3/2019
1.33.0-preview 8,380 7/22/2019
1.32.0-preview 121 7/16/2019
1.31.0-preview 21,020 4/29/2019
1.29.0-preview 3,764 4/3/2019
1.28.0-preview 12,153 2/13/2019
1.27.0-preview 2,767 1/29/2019
1.25.0-preview 6,542 12/19/2018
1.24.0-preview 26,103 11/26/2018
1.23.0-preview 298 11/15/2018
1.22.0-preview 26,753 10/31/2018
1.21.0-preview 202 10/24/2018
1.20.2-preview 174 11/2/2018
1.20.1-preview 875 9/28/2018
1.20.0-preview 445 9/11/2018
1.19.0-preview 2,299 8/1/2018
1.18.1-preview 481 10/27/2018
1.18.0-preview 25,193 6/21/2018
1.17.0-preview 621 6/18/2018
1.16.0-preview 2,605 5/24/2018
1.15.0-preview 2,926 4/19/2018
1.14.0-preview 328 4/18/2018
1.13.1-preview 385 4/23/2018
1.13.0-preview 6,814 3/19/2018
1.12.0-preview 6,118 2/20/2018
1.11.0-preview 8,147 1/12/2018
1.10.0-preview 3,133 11/17/2017
1.9.0-preview 437 11/10/2017
1.8.0-preview 15,695 10/26/2017
1.7.0-preview 7,029 9/27/2017
1.6.0-preview 10,520 7/7/2017
1.5.0-preview 87,693 6/12/2017
1.3.0-preview 11,004 4/25/2017
1.2.0-preview 6,012 3/23/2017
1.1.0-preview 1,143 3/3/2017
0.55.1-prerelease 4,634 3/23/2017
0.55.0-prerelease 2,449 3/3/2017
0.54.0-prerelease 2,018 2/21/2017
0.53.0-prerelease 1,935 2/16/2017
0.52.0-prerelease 469 2/9/2017
0.51.0-prerelease 13,585 12/5/2016
0.50.0-prerelease 18,927 8/22/2016
0.49.0-prerelease 17,170 8/4/2016
0.48.0-prerelease 2,901 7/19/2016
0.47.0-prerelease 2,163 6/17/2016
0.46.0-prerelease 16,028 4/1/2016
0.45.0-prerelease 3,390 2/25/2016
0.44.0-prerelease 905 2/23/2016
0.43.0-prerelease 4,394 12/14/2015
0.42.0-prerelease 379 12/8/2015
0.41.0-prerelease 2,232 11/6/2015
0.40.0-prerelease 388 11/3/2015
0.39.0-prerelease 2,626 10/13/2015
0.38.0-prerelease 4,317 9/9/2015
0.37.0-prerelease 1,190 8/24/2015
0.36.0-prerelease 627 8/13/2015
0.35.0-prerelease 461 8/11/2015
0.34.0-prerelease 591 7/31/2015
0.33.0-prerelease 406 7/31/2015
0.32.0-prerelease 878 7/29/2015
0.31.0-prerelease 345 7/28/2015
0.30.0-prerelease 356 7/27/2015
0.29.0-prerelease 1,700 6/20/2015
0.28.0-prerelease 453 6/17/2015
0.26.0-prerelease 932 5/14/2015
0.25.0-prerelease 630 5/4/2015
0.22.0-prerelease 548 4/29/2015
0.21.0-prerelease 403 4/20/2015
0.20.0-prerelease 825 3/25/2015
0.19.0-prerelease 356 3/18/2015
0.18.0-prerelease 506 3/5/2015
0.17.0-prerelease 1,213 2/19/2015
0.16.2-prerelease 1,266 2/4/2015
0.16.1-prerelease 446 1/30/2015
0.16.0-prerelease 1,149 1/8/2015
0.15.0-prerelease 445 1/6/2015
0.14.3-prerelease 892 11/25/2014
0.14.2-prerelease 535 11/11/2014
0.14.1-prerelease 867 11/3/2014
0.14.0-prerelease 1,323 10/31/2014
0.12.0-prerelease 3,275 9/15/2014
0.11.1-prerelease 1,199 9/4/2014
0.11.0-prerelease 787 8/19/2014
0.10.0-prerelease 403 8/8/2014
0.9.1-prerelease 378 8/5/2014
0.9.0-prerelease 428 7/10/2014
Show less