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

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/tables/columns/sensitivityLabels
managedInstances/operations
managedInstances/vulnerabilityAssessments
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/columns/sensitivityLabels
managedInstances/azureADOnlyAuthentications	managedInstances/securityAlertPolicies
managedInstances/databases/queries	servers/auditingSettings
managedInstances/databases/schemas	servers/databases
managedInstances/databases/schemas/tables	servers/databases/replicationLinks
managedInstances/databases/schemas/tables/columns	servers/databases/schemas/tables/columns/sensitivityLabels
managedInstances/databases/transparentDataEncryption	servers/databases/securityAlertPolicies
managedInstances/privateEndpointConnections	servers/databases/syncGroups
managedInstances/privateLinkResources	servers/databases/transparentDataEncryption
managedInstances/sqlAgent	servers/extendedAuditingSettings
servers/azureADOnlyAuthentications	servers/restorableDroppedDatabases
servers/databases/schemas	servers/securityAlertPolicies
servers/databases/schemas/tables
servers/databases/schemas/tables/columns
servers/devOpsAuditingSettings

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

2024-05-01-preview

New	Updated
instancePools/operations