Create a Standard Database in SQL Azure with PowerShell

Question

Cannot find any references for creating a Standard or Premium database in SQL Azure with PowerShell. The preview feature is enabled for the account.

Update

Error message when trying to create a Standard database:

"Invalid value provided for parameter EDITION. Please provide a value that is valid on server version 1.0."

drquinn · Accepted Answer · 2014-05-22 20:06:50Z

1

It seems 2 key pieces were missing. The Service Objective and specifying the version on SQL server creation. The server version defaults to 1.0 (only for Web and Business) while 2.0 is required (for Standard or Premium). And a separate Service Objective object needs to be created for Standard or Premium.

$newSqlServer = New-AzureSqlDatabaseServer -Location $location -AdministratorLogin $login -AdministratorLoginPassword $password -Version "2.0"

$sqlContext = New-AzureSqlDatabaseServerContext -ServerName $newSqlServer.ServerName -Credential $credential

$S2 = Get-AzureSqlDatabaseServiceObjective $sqlContext -ServiceObjectiveName "S2"

New-AzureSqlDatabase -ServerName $newSqlServer.ServerName -DatabaseName $databaseName -Edition "Standard" -MaxSizeGB 10 -Collation "SQL_Latin1_General_CP1_CI_AS" -ServiceObjective $S2

answered May 22, 2014 at 20:06

drquinn

4774 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Frode F. · Accepted Answer · 2014-05-19 19:30:40Z

0

A simple google search gives you New-AzureSqlDatabase. Also found a sample here: How to create Windows Azure SQL Database - MSDN Blogs. Modified sample:

#Guessing you already have a db server
$cred = Get-Credential
$ctx = New-AzureSqlDatabaseServerContext -ServerName "<servername>" -Credential $cred

New-AzureSqlDatabase $ctx -DatabaseName "<dbname>" -MaxSizeGB 1 -Edition Standard 
-Collation "SQL_Latin1_General_CP1_CI_AS"

Update: The help documentation on TechNet for New-AzureSqlDatabase says Standard and Premium are available too.

-Edition

The edition for the SQL Database. Acceptable values are Web, Business, Basic, Standard, and Premium. The default value is Web.

edited May 19, 2014 at 19:30

answered May 17, 2014 at 9:37

Frode F.

55.4k9 gold badges104 silver badges118 bronze badges

2 Comments

drquinn Over a year ago

Should have been more clear. There are plenty of references for creating a Web or Business database. Your command will not work for Standard or Premium.

Frode F. Over a year ago

Unfortunately I can't test it myself. Maybe it's wrong, but I trust the official documentation. See quote in updated answer.

Umachandar - Microsoft · Accepted Answer · 2014-05-21 22:40:04Z

Currently, we support following API for creating database with service tier/performance level:

T-SQL
PS cmdlets
REST API

The level of support however differs between these APIs.

T-SQL 1. Supports specifying edition/service level only 2. Performance level will default to the lowest one for the service tier

PS cmdlet/REST API 1. Supports all options - service tiers & performance levels

Also, in current preview we support the new service tiers only on newly created servers. This means if you have existing server they will not have the ability to create new service tiers like Basic/Standard.

We are looking at relaxing these restrictions in the future. Link below has details:

http://msdn.microsoft.com/library/azure/dn369872.aspx

Collectives™ on Stack Overflow

Create a Standard Database in SQL Azure with PowerShell

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related