farmer icon indicating copy to clipboard operation
farmer copied to clipboard

Serverless Azure SQL Tier

Open Nemeczek opened this issue 4 years ago • 4 comments

Hi,

Is possible to create serverless Azure SQL Server? I do have an issue trying to backtrack Farmer DbSku back to the Azure SQL sku.

The SKU I am looking for in ARM is: "GP_S_Gen5_1" https://docs.microsoft.com/en-us/azure/azure-sql/database/resource-limits-vcore-single-databases image


Is it currently available? Or it is good PR candidate?

Nemeczek avatar Jun 22 '20 08:06 Nemeczek

This would be a great PR candidate - currently Farmer only supports the original DTU model. I'm not sure what's involved in this - if it's just about adding a new SKU or if this impacts things that the current model already supports e.g. elastic pools etc.

I would suggest the first step would be to identify what the differences are with the templates that are currently generated.

isaacabraham avatar Jun 22 '20 11:06 isaacabraham

Objectively, this is really important.

Limp-monkey avatar Jun 23 '20 21:06 Limp-monkey

I'm sure this can be added - best place to start is putting an example ARM template of the general purpose model and comparing with the DTU model.

isaacabraham avatar Jun 24 '20 08:06 isaacabraham

@isaacabraham I will look into it during the weekend. I do have ARM templates because we are using serverless quite heavily for any development environments. Terraform also does not support it :P

Nemeczek avatar Jun 24 '20 20:06 Nemeczek

Closing as fixed by #935

ninjarobot avatar Mar 16 '23 12:03 ninjarobot