4

I've connected to couple of Azure SQL Servers (those are hosting few Azure SQL Databases on them) in SSMS Object Explorer and see that version is 12.0.2000.8

select @@Version shows below:

Microsoft SQL Azure (RTM) - 12.0.2000.8 Feb 20 2021 17:51:58 Copyright (C) 2019 Microsoft Corporation

Object Explorer

For comparison, my other box is SQL Server 2017 and version it shows is 14.0.3370.1

I expected to see Azure SQL Servers as 15.0.something (correspond to SQL Server 2019), but they seem to correspond to SQL Server 2014 (version 12)

Questions:

Weren't Azure SQL Servers supposed to upgrade automatically to latest version ?
How can I upgrade them to version 15 manually ?

Aleksey Vitsko
  • 6,148
  • 5
  • 39
  • 70

1 Answers1

10

Azure SQL Database is automatically updated, but it uses a different version numbering scheme from “box” SQL Server. It went from “11” to “12” several years ago during a major breaking change, and will stay on “12” indefinitely.

It always has the latest features and fixes for the SQL Server engine and is ahead of SQL Server 2019. By the time a new version of SQL Server is released, the code has been running in production in Azure SQL Database for a long time.

You control the database compatibility level of your databases to opt-in to breaking changes and query optimizer upgrades. The database compatibility levels map to the major releases of SQL Server. Over time the default compatibility level for new Azure SQL Databases increases up as new compatibility levels are introduced.

David Browne - Microsoft
  • 49,000
  • 3
  • 53
  • 102