API version change log for deployment of Microsoft.Sql/servers/databases

This article describes the properties that changed in each API version for microsoft.sql/servers/databases. It only covers properties that are available during deployments.

2024-05-01-preview

No properties added, updated or removed.

2023-08-01-preview

No properties added, updated or removed.

2023-05-01-preview

No properties added, updated or removed.

2023-02-01-preview

Updated:

• DatabaseProperties: Added property 'encryptionProtectorAutoRotation'
• DatabaseProperties: Added property 'freeLimitExhaustionBehavior'
• DatabaseProperties: Added property 'useFreeLimit'

2022-11-01-preview

No properties added, updated or removed.

2022-08-01-preview

Added:

• DatabaseKey
• DatabasePropertiesKeys

Updated:

• DatabaseProperties: Added property 'availabilityZone'
• DatabaseProperties: Added property 'encryptionProtector'
• DatabaseProperties: Added property 'keys'
• DatabaseProperties: Added property 'manualCutover'
• DatabaseProperties: Added property 'performCutover'

2022-05-01-preview

Updated:

• DatabaseProperties: Added property 'preferredEnclaveType'

2022-02-01-preview

No properties added, updated or removed.

2021-11-01

No properties added, updated or removed.

2021-11-01-preview

No properties added, updated or removed.

2021-08-01-preview

No properties added, updated or removed.

2021-05-01-preview

Added:

• DatabaseIdentity
• DatabaseIdentityUserAssignedIdentities
• DatabaseUserIdentity

Updated:

• DatabaseProperties: Added property 'federatedClientId'
• DatabaseProperties: Added property 'sourceResourceId'
• Microsoft.Sql/servers/databases: Added property 'identity'

2021-02-01-preview

Updated:

• DatabaseProperties: Added property 'isInfraEncryptionEnabled'
• DatabaseProperties: Added property 'isLedgerOn'

2020-11-01-preview

Updated:

• DatabaseProperties: Added property 'currentBackupStorageRedundancy'
• DatabaseProperties: Added property 'requestedBackupStorageRedundancy'
• DatabaseProperties: Removed property 'storageAccountType'

2020-08-01-preview

Updated:

• DatabaseProperties: Added property 'highAvailabilityReplicaCount'
• DatabaseProperties: Added property 'maintenanceConfigurationId'
• DatabaseProperties: Added property 'secondaryType'
• DatabaseProperties: Removed property 'readReplicaCount'

2020-02-02-preview

Updated:

• DatabaseProperties: Removed property 'sourceResourceId'

2019-06-01-preview

Updated:

• DatabaseProperties: Added property 'sourceResourceId'
• DatabaseProperties: Added property 'storageAccountType'

2017-10-01-preview

Updated:

• DatabaseProperties: Added property 'autoPauseDelay'
• DatabaseProperties: Added property 'currentSku'
• DatabaseProperties: Added property 'earliestRestoreDate'
• DatabaseProperties: Added property 'licenseType'
• DatabaseProperties: Added property 'maxLogSizeBytes'
• DatabaseProperties: Added property 'minCapacity'
• DatabaseProperties: Added property 'pausedDate'
• DatabaseProperties: Added property 'readReplicaCount'
• DatabaseProperties: Added property 'readScale'
• DatabaseProperties: Added property 'requestedServiceObjectiveName'
• DatabaseProperties: Added property 'resumedDate'
• Microsoft.Sql/servers/databases: Added property 'managedBy'

2017-03-01-preview

Added:

• Sku

Updated:

• DatabaseProperties: Added property 'catalogCollation'
• DatabaseProperties: Added property 'currentServiceObjectiveName'
• DatabaseProperties: Added property 'elasticPoolId'
• DatabaseProperties: Added property 'longTermRetentionBackupResourceId'
• DatabaseProperties: Added property 'recoverableDatabaseId'
• DatabaseProperties: Added property 'recoveryServicesRecoveryPointId'
• DatabaseProperties: Added property 'restorableDroppedDatabaseId'
• DatabaseProperties: Removed property 'containmentState'
• DatabaseProperties: Removed property 'currentServiceObjectiveId'
• DatabaseProperties: Removed property 'earliestRestoreDate'
• DatabaseProperties: Removed property 'edition'
• DatabaseProperties: Removed property 'elasticPoolName'
• DatabaseProperties: Removed property 'readScale'
• DatabaseProperties: Removed property 'recommendedIndex'
• DatabaseProperties: Removed property 'recoveryServicesRecoveryPointResourceId'
• DatabaseProperties: Removed property 'requestedServiceObjectiveId'
• DatabaseProperties: Removed property 'requestedServiceObjectiveName'
• DatabaseProperties: Removed property 'serviceLevelObjective'
• DatabaseProperties: Removed property 'serviceTierAdvisors'
• DatabaseProperties: Removed property 'transparentDataEncryption'
• Microsoft.Sql/servers/databases: Added property 'sku'

2014-04-01

Oldest version tracked in change log