Weâre happy to announce that the update policy SQL Server 2025 for Azure SQL Managed Instance is now generally available (GA). SQL Server 2025 update policy contains all the latest SQL engine innovation while retaining database portability to the recent major release of SQL Server.
Update policy is an instance configuration option that provides flexibility and allows you to choose between instant access to the latest SQL engine features and fixed SQL engine feature set corresponding to 2022 and 2025 major releases of SQL Server. Regardless of the update policy chosen, you continue to benefit from Azure SQL platform innovation. New features and capabilities not related to the SQL engine â everything that makes Azure SQL Managed Instance a true PaaS service â are successively delivered to your Azure SQL Managed Instance resources.
Whatâs new in SQL Server 2025 update policy
In short, instances with update policy SQL Server 2025 benefit from all the SQL engine features that were gradually added to the Always-up-to-date policy over the past few years and are not available in the SQL Server 2022 update policy. Letâs name few most notable features, with complete list available in the update policy documentation:
- Optimized locking
- Mirroring in Fabric
- Regular expression functions
- Vector data type and functions
- JSON data type and aggregate functions
- Invoking HTTP REST endpoints
- Manual (copy-only) backup to immutable Azure Blob Storage
- Change Event Streaming (private preview)
Update policy for each modernization strategy
Always-up-to-date is a âperpetualâ update policy. It has no end of lifetime and brings new SQL engine features to instances as soon as they are available in Azure. It enables you to always be at the forefront - to quickly adopt new yet production-ready SQL engine features, benefit from them in everyday operations and keep a competitive edge without waiting for the next major release of SQL Server.
In contrast, update policies SQL Server 2025 and SQL Server 2022 contain fixed sets of SQL engine features corresponding to the respective releases of SQL Server. Theyâre optimized to fulfill regulatory compliance, contractual, or other requirements for database/workload portability from managed instance to SQL Server. Over time, they get security patches, fixes, and incremental functional improvements in form of Cumulative Updates, but not new SQL engine features. They also have limited lifetime, aligned with the period of mainstream support of SQL Server releases. As the end of mainstream support for the update policy approaches, you should upgrade instances to a newer policy. Instances will be automatically upgraded to the next more recent update policy at the end of mainstream support of their existing update policy.
Best practices with the Update policy feature
- Plan for the end of lifetime of SQL Server 2022 update policy if youâre using it today, and upgrade to a newer policy on your terms before automatic upgrade kicks in. Choose between Always-up-to-date and SQL Server 2025 update policy.
- Make sure to add update policy configuration to your deployment templates and scripts, so that you donât rely on service defaults that may change in the future.
- Be aware that using some of the newly introduced features may require changing the database compatibility level. Consult feature documentation for details.
Whatâs coming next
SQL Server 2025 will become the default update policy in Azure portal during March 2026.
Future versions of REST API, PowerShell and CLI will also have the default value changed to SQL Server 2025 for the âdatabase formatâ parameter which corresponds to the instanceâs update policy.
SQL Server 2022 policy will reach end of lifetime on January 11, 2028 when the mainstream support for SQL Server 2022 ends. Plan timely and change the update policy of your instances before that date.
Summary
Update policy SQL Server 2025 for Azure SQL Managed Instance is now generally available. It brings the same set of SQL engine features that exist in the new SQL Server 2025. Consider it if you have regulatory compliance, contractual, or other reasons for database/workload portability from Azure SQL Managed Instance to SQL Server 2025. Otherwise, use the Always-up-to-date policy which always provides the latest features and benefits available to Azure SQL Managed Instance.
If your instances are currently configured with SQL Server 2022 update policy, update them to a newer policy before the end of mainstream support.
For more details visit Update policy documentation. To stay up to date with the latest feature additions to Azure SQL Managed Instance, subscribe to the Azure SQL video channel, subscribe to the Azure SQL Blog feed, or bookmark Whatâs new in Azure SQL Managed Instance article with regular updates.