Contents
What is the default compatibility level for Azure SQL databases?
150
As of November 2019, in Azure SQL Database, the default compatibility level is 150 for newly created databases. Microsoft does not update Database Compatibility Level for existing databases. It is up to customers to do at their own discretion.
What is SQL database compatibility level?
Database compatibility level defines how SQL Server uses certain features. Specifically, it causes them to act like a given version of SQL Server, which is typically done to provide some level of backward compatibility.
How do I check SQL compatibility?
Using SQL Server Management Studio Right-click the database, and then click Properties. The Database Properties dialog box opens. In the Select a page pane, click Options. The current compatibility level is displayed in the Compatibility level list box.
How do I check SQL compatibility level?
What are the limitations of Azure SQL?
Basic SQL Azure limitations. SQL Azure offers two kinds of databases, Web Edition and Business Edition. The former can scale up to 5 GB; the latter, 50 GB.
How to change database compatibility level in SQL Server?
To view or change the compatibility level of a database After connecting to the appropriate instance of the SQL Server Database Engine, in Object Explorer, click the server name. Expand Databases, and, depending on the database, either select a user database or expand System Databases and select a system database. Right-click the database, and then click Properties.
How do I change the compatibility level in SQL Server?
It’s really simple to change the database compatibility level. In SQL Server Management Studio (SSMS), right-click on the database name, select Properties, select the Options node, click on the drop-down next to Compatibility level and select the level that matches your SQL Server.
What is a database compatibility level?
Compatibility Level. The compatibility level of a database dictates how certain language elements of the database function as it relates to an earlier version of SQL Server.