Azure SQL Server outdated version – how can I upgrade it to current version?

All we need is an easy explanation of the problem, so here it is.

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

Azure SQL Server outdated version - how can I upgrade it to current version?

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 ?

How to solve :

I know you bored from this bug, So we are here to help you! Take a deep breath and look at the explanation of your problem. We have many solutions to this problem, But we recommend you to use the first method because it is tested & true method that will 100% work for you.

Method 1

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.

Note: Use and implement method 1 because this method fully tested our system.
Thank you 🙂

All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0

Leave a Reply