Difference between azurerm_mssql_server and azurerm_sql_server resources?

There are 2 resource types available

azurerm_sql_server (https://www.terraform.io/docs/providers/azurerm/r/sql_server.html)
and
azurerm_mssql_server (https://www.terraform.io/docs/providers/azurerm/r/mssql_server.html)

When I provision resource in Azure using above 2 resource types, I get similar resources in Azure. Also parameters and evrything is almost same in the above 2 resources.

Why why are they 2 separate resource names in Terraform ?

2 Likes

I had the same question and after a bit of search, it appeared that the azurerm_mssql_server is the newer version and azurerm_sql_server is not being updated. See this link - https://github.com/terraform-providers/terraform-provider-azurerm/issues/6502.