Azure SQL Managed Instance Update policy and compatibility

Ryan Suarez 20 Reputation points
2026-07-28T15:48:25.5666667+00:00

We are looking to migrate the database of one of our on-prem apps to an Azure SQL Managed Instance that has its update policy set to "SQL Server 2025". However, the supported databases for the application is listed as "Microsoft SQL Server 2017 to 2022". The Microsoft Learn docs does state that "SQL Managed Instance supports backward compatibility to SQL Server 2008 databases".

Is Azure SQL Managed Instance with update policy set to "SQL Server 2025" compatible with "Microsoft SQL Server 2022"?

Azure SQL Database
0 comments No comments

Answer accepted by question author
Christos Panagiotidis 3,551 Reputation points
2026-07-28T16:00:47.7033333+00:00

Azure SQL Managed Instance with the SQL Server 2025 update policy is not equivalent to SQL Server 2022. The policy aligns its internal database format and engine features with SQL Server 2025. Running older databases reflects backward compatibility; it does not prove that an application certified only for SQL Server 2017–2022 is vendor-supported.

For production, choose the SQL Server 2022 update policy—the default—unless the vendor explicitly certifies the 2025 policy. Migrate a copy, retain database compatibility level 160 if the application expects SQL Server 2022 query-processing behavior, and run regression, upgrade, and performance tests.

Compatibility level 160 controls T-SQL and query-processing behavior; it does not turn a 2025-policy Managed Instance into SQL Server 2022. Changing from the 2025 policy back to 2022 is unsupported because the internal-format upgrade is permanent. If the instance is already on 2025, create a separate 2022-policy instance and migrate there when vendor support is required.

Was this answer helpful?

1 person found this answer helpful.
0 comments No comments

0 additional answers

Sort by: Oldest

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.