How to Upgrade SQL Azure Database to V12

Posted on Updated on

Before upgrading we should check the the current SQL Azure version. Connect to your SQL Azure server and execute the following command to get the version and other information.

image

I got the below results

image Note the version shows 11.0.9229.2, considering the major version number  (in this case 11) we know that this SQL Azure Server is V11.

In order to get the full upgrade information see this web site, and the article describes the relation between exact version number and V terminology. (portion of the article below)

A.1 Version clarification

This document concerns the upgrade of Microsoft Azure SQL Database from version V11 to V12. More formally the version numbers are close to the following two values, as reported by the T-SQL statement SELECT @@version; :

  • 11.0.9228.18 (V11)
  • 12.0.2000.8 (or a bit higher, V12)

Upgrading

You can upgrade the SQL Azure server to V12 (meaning the version 12.0.2000.8 or higher) from the new Azure Portal. (http://portal.azure.com)

View this article for the step by step upgrading for the process with screenshots

Advertisements

3 thoughts on “How to Upgrade SQL Azure Database to V12

    Lubomir said:
    April 22, 2015 at 1:11 PM

    Thanks for the info, now I was able to upgrade it, perfect.
    If someone would like to save some time, here is the same script from the picture above for copy:
    select serverproperty(‘productversion’) as ‘Version’,
    serverproperty(‘productlevel’) as ‘ReleaseName’, serverproperty(‘edition’) as ‘Edition’

    Vishala said:
    November 25, 2015 at 8:03 PM

    Very useful article!!! Can you please let me know if Upgrade can be done using Azure POwershell Cmdlets . I am using Azure Powershell 0.9.8V

Comments are closed.