| author | MikeRayMSFT | |
|---|---|---|
| ms.author | mikeray | |
| ms.reviewer | randolphwest | |
| ms.date | 11/26/2025 | |
| ms.topic | include | |
| ms.custom |
|
The following table identifies features available by [!INCLUDE ssnoversion-md] edition:
::: moniker range="<=sql-server-ver16 || <=sql-server-linux-ver16"
| Feature | Enterprise | Standard | Web | Express | Developer | Evaluation |
|---|---|---|---|---|---|---|
| Azure pay-as-you-go billing | Yes | Yes | Not applicable | Not applicable | Not applicable | Not applicable |
| Best practices assessment | Yes | Yes | Yes | Yes | Yes | Yes |
| Migration readiness | Yes | Yes | Yes | Yes | Yes | Yes |
| Database migration | LRS and MI link |
LRS and MI link |
LRS only | LRS only | LRS and MI link |
LRS only |
| Detailed inventory | Yes | Yes | Yes | Yes | Yes | Yes |
| Microsoft Entra authentication | Yes | Yes | Yes | Yes | Yes | Yes |
| Microsoft Defender for Cloud | Yes | Yes | Yes | Yes 1 | Yes | Yes |
| Microsoft Purview: Govern using DevOps and data owner policies | Yes | Yes | Yes | Yes | Yes | Yes |
| Automated backups to local storage (preview) | Yes | Yes | Yes | Yes | Yes | Yes |
| Point-in-time restore | Yes | Yes | Yes | Yes | Yes | Yes |
| Automatic updates | Yes | Yes | Yes | Yes | Yes | Yes |
| Failover cluster instances | Yes | Yes | Not applicable | Not applicable | Yes | Not applicable |
| Always On availability groups | Yes | Yes | Not applicable | Not applicable | Yes | Not applicable |
| Monitoring (preview) | Yes | Yes | No | No | No | No |
| Client connection summary | Yes | Yes | Yes | Yes | Yes | Yes |
| Operate with least privilege | Yes | Yes | Yes | Yes | Yes | Yes |
1 Express LocalDB isn't supported.
::: moniker-end
::: moniker range=">=sql-server-ver17 || >=sql-server-linux-ver17"
| Feature | Enterprise 1 | Standard 1 | Express | Evaluation |
|---|---|---|---|---|
| Azure pay-as-you-go billing | Yes | Yes | Not applicable | Not applicable |
| Best practices assessment | Yes | Yes | Yes | Yes |
| Migration readiness (preview) | Yes | Yes | Yes | Yes |
| Detailed inventory | Yes | Yes | Yes | Yes |
| Microsoft Entra authentication | Yes | Yes | Yes | Yes |
| Microsoft Defender for Cloud | Yes | Yes | Yes 2 | Yes |
| Microsoft Purview: Govern using DevOps and data owner policies | Yes | Yes | Yes | Yes |
| Automated backups to local storage (preview) | Yes | Yes | Yes | Yes |
| Point-in-time restore | Yes | Yes | Yes | Yes |
| Automatic updates | Yes | Yes | Yes | Yes |
| Failover cluster instances | Yes | Yes | Not applicable | Not applicable |
| Always On availability groups | Yes | Yes | Not applicable | Not applicable |
| Monitoring (preview) | Yes | Yes | No | No |
| Client connection summary | Yes | Yes | Yes | Yes |
| Operate with least privilege | Yes | Yes | Yes | Yes |
1 SQL Server 2025 (17.x) introduces separate Enterprise Developer and Standard Developer editions of SQL Server.
2 Express LocalDB isn't supported.
::: moniker-end