Terraform-provider-azurerm: azurerm_sql_firewall_rule and azurerm_sql_virtual_network_rule

[TPPWC]

Hi there,

it looks like the azurerm-sql resources are moved to azurerm-mssql. How about azurerm_sql_firewall_rule and azurerm_sql_virtual_network_rule, will these moved to azurerm-mssql as well?

kr

tom

[yupwei68]

Hi @TPPWC , thanks for opening this issue. We'll create new resources for azurerm_mssql_firewall_rule and azurerm_mssql_virtual_network_rule when there is a service version upgrade. Currently, there is no version upgrade for these two service. And you could use the resources in mssql and sql in mixed.

[ilmax]

it would also be nice to include the ability to remove the firewall rule that allows access to all azure resources, my current workaround for it is via local-exec + az cli command but it would be way better to be able to express in terraform terms.

[yupwei68]

@ilmax You could remove the firewall rule by importing an existing azurerm_sql_firewall_rule by its resource id, then destroy this resource. The import command is like:

terraform import azurerm_sql_firewall_rule.rule1 /subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/myresourcegroup/providers/Microsoft.Sql/servers/myserver/firewallRules/rule1