CODEWITHSUNDEEP
azureazure-sql-databaseazure-data-factory
DC07
DC07

Reputation: 303

Azure SQL DB scaling with API

Im using a ADF web activity to scale up/down my azure sql db.

Works perfectly with this code:

{"sku":{"name":"GP_Gen4_4","tier":"GeneralPurpose"},"location":"West Europe"}

However, this doesnt include the azure hybrid benifit saving.

Based on the below link maybe it's something like this

{“sku”:
{“name”:”GP_Gen4_4″,”tier”:”GeneralPurpose”}
,”licenseType”:
{“BasePrice”:”SOMETHING_HERE”,”LicenseIncluded “:”SOMETHING_HERE”}
,”location”:”West Europe”
}

however I'm not sure the values to put?

https://learn.microsoft.com/en-gb/rest/api/sql/databases/update#databaselicensetype

Upvotes: 1

Views: 932

Answers (1)

Jay Gong
Jay Gong

Reputation: 23782

Based on the rest api document, the licenseType need to be defined in the properties object,not in the sku object.

enter image description here

Refer to the example provided in above link,it should be something like:

{
  "sku": {
    "name": "S1",
    "tier": "Standard"
  },
  "properties": {
    "licenseType": {
        "BasePrice":"<>",
        "LicenseIncluded":"<>"
    }
  },
  "location": "southeastasia"
}

Upvotes: 1

Related Questions