Compatibility level 130 for Azure SQL Database V12


On an Azure SQL Database V12 server, the maximum compatibility level for a database is 130. This same maximum applies on Microsoft SQL Server 2016 (currently at pre-release CTP3). A new database on SQL Database V12 is set to level 120, but you can increase its level to 130. On V12, compatibility level 130 is currently supported as preview, and not yet as generally available. An upgrade of a V11 database to V12 will not alter its compatibility level, although you can alter the level manually. For details about the effects of 130, 120, and other levels, see ALTER DATABASE Compatibility Level (Transact-SQL).


Learn and build with $200 in credit, and keep going for free


Visual Studio

订阅者每年可获得高达 $1800 的 Azure 服务



加入 BizSpark 计划并获得免费的 Azure 服务