Share via

Azure PaaS Version

Prasenna Kannan 436 Reputation points
2020-10-13T08:34:14.147+00:00

Hello,

I have installed Azure SQL Single Database (PaaS) - Single Database.

When I run the SELECT @@version query in the query window, I'm getting the below version

Microsoft SQL Azure (RTM) - 12.0.2000.8 Sep 11 2020 22:32:15 Copyright (C) 2019 Microsoft Corporation - This version resolves to SQL Server 2014.

Is this the default version? Can I upgrade?

Thanks,

Prasenna

Azure SQL Database
0 comments
Accepted answer
  1. Prasenna Kannan 436 Reputation points
    2020-10-13T10:08:21.377+00:00

    @Vaibhav Chaudhari : Thanks!

    Is it possible to update version in Azure SQL DB - PaaS. Versioning upgrades are maintained by Microsoft, isn't it?

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Vaibhav Chaudhari 38,726 Reputation points
    2020-10-13T08:57:46.157+00:00

    Yes, that's the latest and right version. You may check the DB compatibility version and update it to latest or lower version if required. Versions in Azure SQL DB is different and tricky.

    Below blog should help in understanding it - http://davebland.com/azure-sql-db-and-version

    Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav

    1 person found this answer helpful.
    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.