How to Upgrade SQL Azure Database to V12

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

  1. 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’

  2. 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.

Powered by WordPress.com.

Up ↑

%d bloggers like this: