1

I am trying to create an ARM templates for Azure SQL DB deployment. I started by exporting template for an existing Azure sql database which was created and configured from portal. However I see quite a few fields which look a bit unfamiliar to me on usage - examples provided below:

a. kind
b. serviceLevelObjective
c. currentServiceObjectiveId
d. requestedServiceObjectiveId
e. containmentState
f. readScale

Is there any place where I can find information on what each of these properties/keys means and what are the valid values against these so that I know how to use these?

Improve this question

1 Answer 1

Reset to default
1

Your best bet is Azure Rest API Reference it has got examples and definitions for parameters.
Also, you don't need all of those, you can just use a "regular" way of creating Azure SQL stuff defined here.

Also, MSDN reference: https://msdn.microsoft.com/en-us/library/azure/mt163685.aspx

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

5 Comments

Thanks for the links. Yes agree I can use the simple template. But by looking into the exported template I feel I might lose out on a number of settings if I use the simple template instead. Hence the requirement to understand what the keys mean. For instance I cannot find what the containmentState enumeration values mean. I see mostly 2 being used - does it mean fully/partially/none? Also what could be the meaning of System and System2 for databaseedition? These are just some examples. Without any definitive guidance I find it very difficult to effectively create the template. Any help?
what the point of using those if you don't understand them? And no, I cannot offer any help beyond this, I've never bothered to figure out what all of those parameters mean. Basic template was always fine for everybody... @shaswatapal
Well well someone seems pretty annoyed for some reason. "Basic template was always fine for everybody" => I beg to disagree. You cannot generalize to hide your limitations. But thanks again for attempting to answer. PS: On second thought perhaps I should have been more specific on my earlier statement "Without any definitive guidance I find it very difficult to effectively create the template" => I meant guidance from microsoft, perhaps you felt I meant there was guidance lacking in your response - your response was clear on the limitation that was there in the provided answer
all the resources are in front of you, if you can't make sense out of those, well. I can't help you.
Thank you for your help, really appreciate. I would like to keep the question open for any other expert as this doesn't unfortunately solve my problem - attribute it to my level of incompetence :(.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.