Automate Azure SQL edition (from Standard to Basic)

Question

Hello, I'm trying to figure it out how to change Azure SQL tier using automation. During the day I will use Standard S0 and during the night I want to reduce to Basic. My question is about parameter perflevel. Edition -> "Basic" PerfLevel -> [EmptyString] ?

Answer 1

Solved!

Perflevel must be: "Basic"

Edition: "Basic"

Answer 2

Hi @Felipe silveira , welcome to Microsoft QnA forum.

You can set the perfLevel as any of these S0, S1, S2, S3, P1, P2, P3 etc. You can find the complete list below. Again as per edition we need to select these.

Resource limits for single databases using the DTU purchasing model - Azure SQL Database

Please let us know if this helps.

----------

If answer helps, please mark it 'Accept Answer'

Answer 3

Hi @AnuragSharma-MSFT, thanks for the answer.

But my doubt is how to set perflevel of basic tier. I try to leave field empty but doesn't work.

Answer 4

I receive this erros from the job log:

Cannot validate argument on parameter 'ServiceObjectiveName'. The argument is null or empty. Provide an argument that is not null or empty, and then try the command again. At Set-AzureSqlDatabaseEdition:71 char:71 + + CategoryInfo : InvalidData: (:) [Get-AzureSqlDatabaseServiceObjective], ParameterBindingValidationException + FullyQualifiedErrorId : ParameterArgumentValidationError,Microsoft.WindowsAzure.Commands.SqlDatabase.Database.Cmdl et.GetAzureSqlDatabaseServiceObjective