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.
2023-05-01-preview
Updated:
- sku.apiVersion - Added values: '2023-05-01-preview' - Removed values: '2023-02-01-preview'
2023-02-01-preview
Added:
- properties.encryptionProtectorAutoRotation
- properties.freeLimitExhaustionBehavior
- properties.useFreeLimit
Updated:
- sku.apiVersion - Added values: '2023-02-01-preview' - Removed values: '2022-11-01-preview'
2022-11-01-preview
Updated:
- sku.apiVersion - Added values: '2022-11-01-preview' - Removed values: '2022-08-01-preview'
2022-08-01-preview
Added:
- properties.availabilityZone
- properties.encryptionProtector
- properties.keys
- properties.keys.{customized property}
- properties.manualCutover
- properties.performCutover
Updated:
- sku.apiVersion - Added values: '2022-08-01-preview' - Removed values: '2022-05-01-preview'
2022-05-01-preview
Added:
Updated:
- sku.apiVersion - Added values: '2022-05-01-preview' - Removed values: '2022-02-01-preview'
2022-02-01-preview
Updated:
- properties.secondaryType - Added values: 'Standby'
- sku.apiVersion - Added values: '2022-02-01-preview' - Removed values: '2021-11-01'
2021-11-01
Updated:
- sku.apiVersion - Added values: '2021-11-01' - Removed values: '2021-11-01-preview'
2021-11-01-preview
Updated:
- sku.apiVersion - Added values: '2021-11-01-preview' - Removed values: '2021-08-01-preview'
2021-08-01-preview
Updated:
- sku.apiVersion - Added values: '2021-08-01-preview' - Removed values: '2021-05-01-preview'
2021-05-01-preview
Added:
- identity
- identity.type
- identity.userAssignedIdentities
- identity.userAssignedIdentities.{customized property}
- properties.federatedClientId
- properties.sourceResourceId
Updated:
- properties.requestedBackupStorageRedundancy - Added values: 'GeoZone'
- sku.apiVersion - Added values: '2021-05-01-preview' - Removed values: '2021-02-01-preview'
2021-02-01-preview
Added:
Updated:
- sku.apiVersion - Added values: '2021-02-01-preview' - Removed values: '2020-11-01-preview'
2020-11-01-preview
Added:
Removed:
- properties.storageAccountType
Updated:
- sku.apiVersion - Added values: '2020-11-01-preview' - Removed values: '2020-08-01-preview'
2020-08-01-preview
Added:
- properties.highAvailabilityReplicaCount
- properties.maintenanceConfigurationId
- properties.secondaryType
Removed:
- properties.readReplicaCount
Updated:
- sku.apiVersion - Added values: '2020-08-01-preview' - Removed values: '2020-02-02-preview'
2020-02-02-preview
Removed:
- properties.sourceResourceId
Updated:
- sku.apiVersion - Added values: '2020-02-02-preview' - Removed values: '2019-06-01-preview'
2019-06-01-preview
Added:
Updated:
- sku.apiVersion - Added values: '2019-06-01-preview' - Removed values: '2017-10-01-preview'
2017-10-01-preview
Added:
- properties.autoPauseDelay
- properties.licenseType
- properties.minCapacity
- properties.readReplicaCount
- properties.readScale
Updated:
- sku.apiVersion - Added values: '2017-10-01-preview' - Removed values: '2017-03-01-preview'
2017-03-01-preview
Added:
- sku
- sku.capacity
- sku.family
- sku.name
- sku.size
- sku.tier
- properties.catalogCollation
- properties.elasticPoolId
- properties.longTermRetentionBackupResourceId
- properties.recoverableDatabaseId
- properties.recoveryServicesRecoveryPointId
- properties.restorableDroppedDatabaseId
Removed:
- properties.edition
- properties.elasticPoolName
- properties.readScale
- properties.recoveryServicesRecoveryPointResourceId
- properties.requestedServiceObjectiveId
- properties.requestedServiceObjectiveName
Updated:
- properties.createMode - Added values: 'RestoreExternalBackup' 'RestoreExternalBackupSecondary' 'Secondary' - Removed values: 'NonReadableSecondary'
- properties.sampleName - Added values: 'WideWorldImportersFull' 'WideWorldImportersStd'
2014-04-01
Oldest version tracked in change log