Change log for deployment of Microsoft.Sql resource types

This article summarizes the changes between API versions for Microsoft.Sql. It only covers resource types that are available during deployment. For details about the properties that changed, select the resource type

2014-04-01

New	Updated
servers
servers/administrators
servers/advisors
servers/auditingPolicies
servers/communicationLinks
servers/connectionPolicies
servers/databases
servers/databases/advisors
servers/databases/auditingPolicies
servers/databases/connectionPolicies
servers/databases/dataMaskingPolicies
servers/databases/dataMaskingPolicies/rules
servers/databases/extensions
servers/databases/geoBackupPolicies
servers/databases/replicationLinks
servers/databases/securityAlertPolicies
servers/databases/serviceTierAdvisors
servers/databases/transparentDataEncryption
servers/disasterRecoveryConfiguration
servers/elasticPools
servers/elasticPools/databases
servers/firewallRules
servers/recommendedElasticPools
servers/recommendedElasticPools/databases
servers/recoverableDatabases
servers/restorableDroppedDatabases
servers/serviceObjectives

2015-05-01-preview

New	Updated
locations/usages	servers
managedInstances	servers/firewallRules
servers/databases/advisors/recommendedActions
servers/databases/auditingSettings
servers/databases/automaticTuning
servers/databases/syncGroups
servers/databases/syncGroups/syncMembers
servers/encryptionProtector
servers/failoverGroups
servers/keys
servers/syncAgents
servers/virtualNetworkRules
virtualClusters

2015-05-01

No new or updated resource types.

2017-03-01-preview

New	Updated
locations/longTermRetentionServers/longTermRetentionDatabases/longTermRetentionBackups	servers/databases
managedInstances/administrators
managedInstances/databases
managedInstances/databases/backupShortTermRetentionPolicies
managedInstances/databases/securityAlertPolicies
managedInstances/restorableDroppedDatabases
managedInstances/restorableDroppedDatabases/backupShortTermRetentionPolicies
managedInstances/securityAlertPolicies
servers/auditingSettings
servers/automaticTuning
servers/databases/backupLongTermRetentionPolicies
servers/databases/dataWarehouseUserActivities
servers/databases/extendedAuditingSettings
servers/databases/restorePoints
servers/databases/schemas/tables/columns/sensitivityLabels
servers/databases/vulnerabilityAssessments
servers/databases/vulnerabilityAssessments/rules/baselines
servers/dnsAliases
servers/extendedAuditingSettings
servers/jobAgents
servers/jobAgents/credentials
servers/jobAgents/jobs
servers/jobAgents/jobs/executions
servers/jobAgents/jobs/executions/steps
servers/jobAgents/jobs/executions/steps/targets
servers/jobAgents/jobs/steps
servers/jobAgents/jobs/versions
servers/jobAgents/jobs/versions/steps
servers/jobAgents/targetGroups
servers/securityAlertPolicies

2017-10-01-preview

New	Updated
locations/instanceFailoverGroups	servers/databases
managedInstances/databases/vulnerabilityAssessments	servers/elasticPools
managedInstances/databases/vulnerabilityAssessments/rules/baselines
managedInstances/databases/vulnerabilityAssessments/scans
managedInstances/encryptionProtector
managedInstances/keys
managedInstances/recoverableDatabases
servers/databases/backupShortTermRetentionPolicies
servers/databases/vulnerabilityAssessments/scans

2018-06-01-preview

New	Updated
instancePools	servers/databases/securityAlertPolicies
locations/longTermRetentionManagedInstances/longTermRetentionDatabases/longTermRetentionManagedInstanceBackups
managedInstances/databases/backupLongTermRetentionPolicies
managedInstances/databases/restoreDetails
managedInstances/databases/schemas
managedInstances/databases/schemas/tables
managedInstances/databases/schemas/tables/columns
managedInstances/databases/schemas/tables/columns/sensitivityLabels
managedInstances/operations
managedInstances/vulnerabilityAssessments
servers/databases/schemas
servers/databases/schemas/tables
servers/databases/schemas/tables/columns
servers/privateEndpointConnections
servers/privateLinkResources
servers/vulnerabilityAssessments

2019-06-01-preview

New	Updated
servers/databases/workloadGroups	servers
servers/databases/workloadGroups/workloadClassifiers	servers/administrators
	servers/databases
	servers/databases/syncGroups
	servers/databases/syncGroups/syncMembers

2020-02-02-preview

New	Updated
locations/deletedServers	managedInstances
locations/serverTrustGroups	managedInstances/databases
locations/timeZones	managedInstances/databases/schemas/tables
managedInstances/azureADOnlyAuthentications	managedInstances/databases/schemas/tables/columns/sensitivityLabels
managedInstances/databases/queries	managedInstances/securityAlertPolicies
managedInstances/databases/transparentDataEncryption	servers/auditingSettings
managedInstances/privateEndpointConnections	servers/databases
managedInstances/privateLinkResources	servers/databases/replicationLinks
managedInstances/sqlAgent	servers/databases/schemas/tables
servers/azureADOnlyAuthentications	servers/databases/schemas/tables/columns/sensitivityLabels
servers/devOpsAuditingSettings	servers/databases/securityAlertPolicies
	servers/databases/syncGroups
	servers/databases/transparentDataEncryption
	servers/extendedAuditingSettings
	servers/restorableDroppedDatabases
	servers/securityAlertPolicies

2020-08-01-preview

New	Updated
	managedInstances/encryptionProtector
	servers
	servers/databases
	servers/elasticPools
	servers/encryptionProtector

2020-11-01-preview

New	Updated
	managedInstances
	managedInstances/keys
	servers
	servers/databases
	servers/keys

2021-02-01-preview

New	Updated
servers/databases/ledgerDigestUploads	servers
servers/outboundFirewallRules	servers/databases
	servers/databases/backupShortTermRetentionPolicies

2021-05-01-preview

New	Updated
managedInstances/distributedAvailabilityGroups	managedInstances
managedInstances/serverTrustCertificates	servers/databases
	servers/databases/extensions
	servers/privateEndpointConnections

2021-08-01-preview

New	Updated
servers/ipv6FirewallRules	servers/elasticPools

2021-11-01-preview

New	Updated
managedInstances/dnsAliases	servers/auditingSettings
managedInstances/endpointCertificates	servers/databases/auditingSettings
servers/advancedThreatProtectionSettings	servers/databases/extendedAuditingSettings
servers/databases/advancedThreatProtectionSettings	servers/elasticPools
	servers/extendedAuditingSettings

2021-11-01

No new or updated resource types.

2022-02-01-preview

New	Updated
managedInstances/advancedThreatProtectionSettings	managedInstances/databases
managedInstances/databases/advancedThreatProtectionSettings	servers/devOpsAuditingSettings
managedInstances/dtc
servers/databases/sqlVulnerabilityAssessments
servers/databases/sqlVulnerabilityAssessments/baselines
servers/databases/sqlVulnerabilityAssessments/baselines/rules
servers/databases/sqlVulnerabilityAssessments/scans
servers/databases/sqlVulnerabilityAssessments/scans/scanResults
servers/sqlVulnerabilityAssessments

2022-05-01-preview

New	Updated
locations/managedDatabaseMoveOperationResults	locations/instanceFailoverGroups
	managedInstances/databases
	managedInstances/distributedAvailabilityGroups
	managedInstances/dtc
	servers/databases

2022-08-01-preview

New	Updated
managedInstances/databases/ledgerDigestUploads	managedInstances/databases
managedInstances/serverConfigurationOptions	servers
managedInstances/startStopSchedules	servers/databases
	servers/elasticPools

2022-11-01-preview

New	Updated
servers/networkSecurityPerimeterConfigurations	managedInstances

2023-02-01-preview

New	Updated
	managedInstances
	managedInstances/databases/schemas/tables/columns/sensitivityLabels
	servers
	servers/databases
	servers/databases/schemas/tables/columns/sensitivityLabels
	servers/failoverGroups

2023-05-01-preview

New	Updated
servers/jobAgents/privateEndpoints	instancePools
	managedInstances
	servers/databases/backupLongTermRetentionPolicies
	servers/elasticPools
	servers/failoverGroups
	servers/jobAgents

2023-08-01-preview

New	Updated
	managedInstances
	managedInstances/distributedAvailabilityGroups

2023-08-01

New	Updated
	managedInstances

2024-05-01-preview

New	Updated
instancePools/operations	managedInstances

2024-11-01-preview

New	Updated
	managedInstances
	managedInstances/databases
	servers
	servers/databases
	servers/databases/transparentDataEncryption
	servers/encryptionProtector
	servers/keys

2025-01-01

New	Updated
	instancePools
	instancePools/operations
	locations/deletedServers
	locations/instanceFailoverGroups
	locations/longTermRetentionManagedInstances/longTermRetentionDatabases/longTermRetentionManagedInstanceBackups
	locations/longTermRetentionServers/longTermRetentionDatabases/longTermRetentionBackups
	locations/managedDatabaseMoveOperationResults
	locations/serverTrustGroups
	locations/timeZones
	locations/usages
	managedInstances
	managedInstances/administrators
	managedInstances/azureADOnlyAuthentications
	managedInstances/databases
	managedInstances/databases/backupLongTermRetentionPolicies
	managedInstances/databases/backupShortTermRetentionPolicies
	managedInstances/databases/ledgerDigestUploads
	managedInstances/databases/queries
	managedInstances/databases/restoreDetails
	managedInstances/databases/schemas
	managedInstances/databases/schemas/tables
	managedInstances/databases/schemas/tables/columns
	managedInstances/databases/schemas/tables/columns/sensitivityLabels
	managedInstances/databases/securityAlertPolicies
	managedInstances/databases/transparentDataEncryption
	managedInstances/databases/vulnerabilityAssessments
	managedInstances/databases/vulnerabilityAssessments/rules/baselines
	managedInstances/databases/vulnerabilityAssessments/scans
	managedInstances/distributedAvailabilityGroups
	managedInstances/dnsAliases
	managedInstances/dtc
	managedInstances/encryptionProtector
	managedInstances/endpointCertificates
	managedInstances/keys
	managedInstances/operations
	managedInstances/privateEndpointConnections
	managedInstances/privateLinkResources
	managedInstances/recoverableDatabases
	managedInstances/restorableDroppedDatabases
	managedInstances/restorableDroppedDatabases/backupShortTermRetentionPolicies
	managedInstances/serverConfigurationOptions
	managedInstances/serverTrustCertificates
	managedInstances/sqlAgent
	managedInstances/vulnerabilityAssessments
	servers
	servers/administrators
	servers/advisors
	servers/auditingSettings
	servers/automaticTuning
	servers/azureADOnlyAuthentications
	servers/connectionPolicies
	servers/databases
	servers/databases/advisors
	servers/databases/advisors/recommendedActions
	servers/databases/auditingSettings
	servers/databases/automaticTuning
	servers/databases/backupLongTermRetentionPolicies
	servers/databases/backupShortTermRetentionPolicies
	servers/databases/dataMaskingPolicies
	servers/databases/dataMaskingPolicies/rules
	servers/databases/dataWarehouseUserActivities
	servers/databases/extendedAuditingSettings
	servers/databases/extensions
	servers/databases/geoBackupPolicies
	servers/databases/ledgerDigestUploads
	servers/databases/replicationLinks
	servers/databases/restorePoints
	servers/databases/schemas
	servers/databases/schemas/tables
	servers/databases/schemas/tables/columns
	servers/databases/schemas/tables/columns/sensitivityLabels
	servers/databases/syncGroups
	servers/databases/syncGroups/syncMembers
	servers/databases/transparentDataEncryption
	servers/databases/vulnerabilityAssessments
	servers/databases/vulnerabilityAssessments/rules/baselines
	servers/databases/vulnerabilityAssessments/scans
	servers/databases/workloadGroups
	servers/databases/workloadGroups/workloadClassifiers
	servers/dnsAliases
	servers/elasticPools
	servers/encryptionProtector
	servers/extendedAuditingSettings
	servers/failoverGroups
	servers/jobAgents
	servers/jobAgents/credentials
	servers/jobAgents/jobs
	servers/jobAgents/jobs/executions
	servers/jobAgents/jobs/executions/steps
	servers/jobAgents/jobs/executions/steps/targets
	servers/jobAgents/jobs/steps
	servers/jobAgents/jobs/versions
	servers/jobAgents/jobs/versions/steps
	servers/jobAgents/privateEndpoints
	servers/jobAgents/targetGroups
	servers/keys
	servers/networkSecurityPerimeterConfigurations
	servers/outboundFirewallRules
	servers/privateEndpointConnections
	servers/privateLinkResources
	servers/recoverableDatabases
	servers/restorableDroppedDatabases
	servers/syncAgents
	servers/virtualNetworkRules
	servers/vulnerabilityAssessments
	virtualClusters

2025-02-01-preview

New	Updated
	managedInstances/dtc
	servers/databases
	servers/databases/syncGroups
	servers/databases/syncGroups/syncMembers
	servers/elasticPools

Feedback

Was this page helpful?

Last updated on 2026-04-20