Hi,
I’ve this config for setting up an SQL elastic pool on a Azure SQL server:
https://registry.terraform.io/providers/hashicorp/azurerm/latest/docs/resources/mssql_elasticpool
resource "azurerm_mssql_elasticpool" "pool" {
name = "pool-${var.client_name}-01"
resource_group_name = azurerm_resource_group.rg.name
location = azurerm_resource_group.rg.location
server_name = azurerm_sql_server.sqlserver.name
license_type = "LicenseIncluded"
max_size_gb = 100
sku {
name = "StandardPool"
tier = "Standard"
capacity = 50
}
per_database_settings {
min_capacity = 0
max_capacity = 50
}
}
at each terraform apply it continuously updates
# azurerm_mssql_elasticpool.pool will be updated in-place
~ resource "azurerm_mssql_elasticpool" "pool" {
id = "/subscriptions/[...]"
+ license_type = "LicenseIncluded"
name = "pool-name"
tags = {}
# (6 unchanged attributes hidden)
# (2 unchanged blocks hidden)
}
any hint to fix this extra update?
Regards,
Sylvain.