Microsoft Azure SDK for Python

This is the Microsoft Azure SQL Management Client Library. This package has been tested with Python 2.7, 3.5, 3.6, 3.7 and 3.8. For a more complete view of Azure libraries, see the azure sdk python release.

Usage

To learn how to use this package, see the quickstart guide

For docs and references, see Python SDK References Code samples for this package can be found at SQL Management on docs.microsoft.com. Additional code samples for different Azure services are available at Samples Repo

Provide Feedback

If you encounter any bugs or have suggestions, please file an issue in the Issues section of the project.

Release History

3.0.1 (2021-07-15)

Bugfixes

• Fix default setting for blob_auditing_policy_name

3.0.0 (2021-06-18)

Features

• Model Server has a new parameter federated_client_id
• Model Server has a new parameter restrict_outbound_network_access
• Model ServerUpdate has a new parameter federated_client_id
• Model ServerUpdate has a new parameter restrict_outbound_network_access
• Model BackupShortTermRetentionPolicy has a new parameter diff_backup_interval_in_hours

Breaking changes

• Operation ReplicationLinksOperations.get has a new signature

2.1.0 (2021-05-24)

• Add resource identity

2.0.0 (2021-05-13)

Features

• Model LongTermRetentionBackup has a new parameter requested_backup_storage_redundancy
• Model LongTermRetentionBackup has a new parameter backup_storage_redundancy
• Model ManagedInstanceKey has a new parameter auto_rotation_enabled
• Model ManagedInstanceEncryptionProtector has a new parameter auto_rotation_enabled
• Model Database has a new parameter is_infra_encryption_enabled
• Model Database has a new parameter is_ledger_on
• Model Database has a new parameter secondary_type
• Model Database has a new parameter current_backup_storage_redundancy
• Model Database has a new parameter high_availability_replica_count
• Model Database has a new parameter maintenance_configuration_id
• Model Database has a new parameter requested_backup_storage_redundancy
• Model ReplicationLink has a new parameter link_type
• Model ServerUpdate has a new parameter primary_user_assigned_identity_id
• Model ServerUpdate has a new parameter administrators
• Model ServerUpdate has a new parameter identity
• Model ServerUpdate has a new parameter key_id
• Model ServerUpdate has a new parameter workspace_feature
• Model DatabaseUpdate has a new parameter is_infra_encryption_enabled
• Model DatabaseUpdate has a new parameter is_ledger_on
• Model DatabaseUpdate has a new parameter secondary_type
• Model DatabaseUpdate has a new parameter current_backup_storage_redundancy
• Model DatabaseUpdate has a new parameter high_availability_replica_count
• Model DatabaseUpdate has a new parameter maintenance_configuration_id
• Model DatabaseUpdate has a new parameter requested_backup_storage_redundancy
• Model ManagedInstance has a new parameter primary_user_assigned_identity_id
• Model ManagedInstance has a new parameter administrators
• Model ManagedInstance has a new parameter key_id
• Model ManagedInstance has a new parameter zone_redundant
• Model ManagedInstance has a new parameter private_endpoint_connections
• Model ServerKey has a new parameter auto_rotation_enabled
• Model ExtendedServerBlobAuditingPolicy has a new parameter is_devops_audit_enabled
• Model ServiceObjectiveCapability has a new parameter supported_maintenance_configurations
• Model EncryptionProtector has a new parameter auto_rotation_enabled
• Model FirewallRuleListResult has a new parameter next_link
• Model ManagedInstanceUpdate has a new parameter primary_user_assigned_identity_id
• Model ManagedInstanceUpdate has a new parameter administrators
• Model ManagedInstanceUpdate has a new parameter identity
• Model ManagedInstanceUpdate has a new parameter key_id
• Model ManagedInstanceUpdate has a new parameter private_endpoint_connections
• Model ManagedInstanceUpdate has a new parameter zone_redundant
• Model ElasticPoolUpdate has a new parameter maintenance_configuration_id
• Model SyncMember has a new parameter private_endpoint_name
• Model ElasticPool has a new parameter maintenance_configuration_id
• Model ManagedInstanceVcoresCapability has a new parameter supported_maintenance_configurations
• Model ManagedInstanceLongTermRetentionBackup has a new parameter backup_storage_redundancy
• Model ServerSecurityAlertPolicy has a new parameter system_data
• Model ManagedInstanceEditionCapability has a new parameter supported_storage_capabilities
• Model ManagedInstanceEditionCapability has a new parameter zone_redundant
• Model ServerBlobAuditingPolicy has a new parameter is_devops_audit_enabled
• Model ElasticPoolPerformanceLevelCapability has a new parameter supported_maintenance_configurations
• Model RestorableDroppedDatabase has a new parameter backup_storage_redundancy
• Model RestorableDroppedDatabase has a new parameter tags
• Model RestorableDroppedDatabase has a new parameter sku
• Model RestorableDroppedDatabase has a new parameter elastic_pool_id
• Model DatabaseSecurityAlertPolicy has a new parameter creation_time
• Model DatabaseSecurityAlertPolicy has a new parameter system_data
• Model SyncGroup has a new parameter conflict_logging_retention_in_days
• Model SyncGroup has a new parameter private_endpoint_name
• Model SyncGroup has a new parameter sku
• Model SyncGroup has a new parameter enable_conflict_logging
• Model VirtualClusterUpdate has a new parameter maintenance_configuration_id
• Model PrivateLinkResourceProperties has a new parameter required_zone_names
• Model VirtualCluster has a new parameter maintenance_configuration_id
• Model ManagedServerSecurityAlertPolicy has a new parameter system_data
• Model DatabaseUsage has a new parameter type
• Model DatabaseUsage has a new parameter id
• Model Server has a new parameter primary_user_assigned_identity_id
• Model Server has a new parameter key_id
• Model Server has a new parameter administrators
• Model Server has a new parameter workspace_feature
• Model SensitivityLabel has a new parameter column_name
• Model SensitivityLabel has a new parameter schema_name
• Model SensitivityLabel has a new parameter managed_by
• Model SensitivityLabel has a new parameter table_name
• Added operation VirtualClustersOperations.update_dns_servers
• Added operation ServersOperations.begin_import_database
• Added operation DatabasesOperations.list_inaccessible_by_server
• Added operation FirewallRulesOperations.replace
• Added operation ReplicationLinksOperations.list_by_server
• Added operation SensitivityLabelsOperations.update
• Added operation ManagedInstancesOperations.list_by_managed_instance
• Added operation ManagedDatabaseSensitivityLabelsOperations.update
• Added operation LongTermRetentionBackupsOperations.begin_update
• Added operation LongTermRetentionBackupsOperations.begin_copy
• Added operation LongTermRetentionBackupsOperations.begin_copy_by_resource_group
• Added operation LongTermRetentionBackupsOperations.begin_update_by_resource_group
• Added operation group DatabaseSchemasOperations
• Added operation group DatabaseExtensionsOperations
• Added operation group ManagedInstancePrivateEndpointConnectionsOperations
• Added operation group DeletedServersOperations
• Added operation group ManagedDatabaseTablesOperations
• Added operation group MaintenanceWindowOptionsOperations
• Added operation group DatabaseSecurityAlertPoliciesOperations
• Added operation group ServerTrustGroupsOperations
• Added operation group ManagedInstanceAzureADOnlyAuthenticationsOperations
• Added operation group SqlAgentOperations
• Added operation group TimeZonesOperations
• Added operation group ManagedInstancePrivateLinkResourcesOperations
• Added operation group RecommendedSensitivityLabelsOperations
• Added operation group DatabaseTablesOperations
• Added operation group ServerAdvisorsOperations
• Added operation group ManagedDatabaseSecurityEventsOperations
• Added operation group ServerOperationsOperations
• Added operation group DatabaseAdvisorsOperations
• Added operation group DatabaseColumnsOperations
• Added operation group DataWarehouseUserActivitiesOperations
• Added operation group OutboundFirewallRulesOperations
• Added operation group ManagedDatabaseSchemasOperations
• Added operation group DatabaseRecommendedActionsOperations
• Added operation group LongTermRetentionPoliciesOperations
• Added operation group ManagedDatabaseQueriesOperations
• Added operation group ManagedDatabaseRecommendedSensitivityLabelsOperations
• Added operation group ManagedDatabaseTransparentDataEncryptionOperations
• Added operation group ServerDevOpsAuditSettingsOperations
• Added operation group OperationsHealthOperations
• Added operation group LedgerDigestUploadsOperations
• Added operation group MaintenanceWindowsOperations
• Added operation group ManagedDatabaseColumnsOperations

Breaking changes

• Operation RestorableDroppedDatabasesOperations.get has a new signature
• Operation ReplicationLinksOperations.get has a new signature
• Parameter old_server_dns_alias_id of model ServerDnsAliasAcquisition is now required
• Operation SensitivityLabelsOperations.list_recommende