snippetModerate
Azure SQL Server outdated version - how can I upgrade it to current version?
Viewed 0 times
cansqlversionazurecurrenthowserverupgradeoutdated
Problem
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
Microsoft SQL Azure (RTM) - 12.0.2000.8 Feb 20 2021 17:51:58 Copyright (C) 2019 Microsoft Corporation
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 ?
select @@Version shows below:Microsoft SQL Azure (RTM) - 12.0.2000.8 Feb 20 2021 17:51:58 Copyright (C) 2019 Microsoft Corporation
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 ?
Solution
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.
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.
Context
StackExchange Database Administrators Q#290557, answer score: 10
Revisions (0)
No revisions yet.