| author | MikeRayMSFT |
|---|---|
| ms.author | mikeray |
| ms.reviewer | randolphwest |
| ms.date | 05/19/2025 |
| ms.topic | include |
| ms.custom | ignite-2023 |
The following table identifies features available by SQL Server version:
| Feature availability based on SQL Server version | 2012 2014 |
2016 2017 2019 |
2022 | 2025 |
|---|---|---|---|---|
| Azure pay-as-you-go billing | Yes | Yes | Yes | Yes |
| Best practices assessment | Yes | Yes | Yes | Yes |
| Migration assessment | Yes | Yes | Yes | Yes |
| Database migration | LRS only | LRS & MI link | LRS & MI link | LRS & MI link |
| Detailed inventory | Yes | Yes | Yes | Yes |
| Microsoft Entra ID authentication for SQL Server | No | No | Yes | Yes |
| Microsoft Defender for Cloud | Yes | Yes | Yes | Yes |
| Microsoft Purview: DevOps policies | No | No | Yes | No |
| Microsoft Purview: data owner policies (preview) | No | No | Yes | No |
| Automated backups to local storage (preview) | Yes | Yes | Yes | Yes |
| Point-in-time-restore (preview) | Yes | Yes | Yes | Yes |
| Automatic updates | Yes 1 | Yes | Yes | Yes |
| Failover cluster instances | Yes | Yes | Yes | Yes |
| Always On availability groups | Yes | Yes | Yes | Yes |
| Monitoring (preview) | No | Yes 2 | Yes | Yes |
| Client connection summary | No | Yes 2 | Yes | Yes |
| Operate with least privilege | Yes | Yes | Yes | Yes |
1 Requires subscription to Extended Security Updates (ESU) enabled by Azure Arc for [!INCLUDE sssql11-md].
2 Requires [!INCLUDE sssql16-md] SP1 or later versions. For more information, see prerequisites.