Share via

Find the Sql Server Version and the EOL of the version

GeethaThatipatri-MSFT 29,017 Reputation points Microsoft Employee
2024-07-19T20:07:47.26+00:00

We received an email from our cloud team that the support for the Azure Sql Server v12 will be stopped by 9th July 2024. Could you please confirm if that is true. If yes , what is the next available version and what should be our next steps to upgrade.

PS - Based on common issues that we have seen from customers and other sources, we are posting these questions to help the Azure community.

Azure SQL Database
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. GeethaThatipatri-MSFT 29,017 Reputation points Microsoft Employee
    2024-07-19T20:09:25.8566667+00:00

    Greeting!

    Azure SQL Database and Azure SQL Managed Instance are always using the latest SQL Server engine available, which right now is the last version of SQL Server 2022.  

    This is documented here: https://learn.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview   .

    Azure SQL Database is always running on the latest stable version of the SQL Server database engine and patched OS with 99.99% availability .

    Azure SQL Database is based on the latest stable version of the Microsoft SQL Server database engine. You can use advanced query processing features, such as high-performance in-memory technologies and intelligent query processing. .

    In fact, the newest capabilities of SQL Server are released first to SQL Database, and then to SQL Server itself. You get the newest SQL Server capabilities with no overhead for patching or upgrading, tested across millions of databases    

    But In Azure SQL PaaS services we don't report the same version/build.   We currently report version "12.0.2000.8" (v12). This is done mainly to preserve backwards compatibility with the previous Azure SQL Database version (v11), and also, the versioning does not follow the same line as the SQL Server Box Product versions. Azure SQL Database has its own version line and we are in v12 now.   The version and ProductVersion properties are returning the correct value (12.0.2000.8).

    Regards

    Geetha

    0 comments