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:

• properties.preferredEnclaveType

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:

• properties.isLedgerOn

Updated:

• sku.apiVersion - Added values: '2021-02-01-preview' - Removed values: '2020-11-01-preview'

2020-11-01-preview

Added:

• properties.requestedBackupStorageRedundancy

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:

• properties.sourceResourceId
• properties.storageAccountType

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