This module manages an Azure SQL database including its server and the needed firewall rule
Instantiate the module by calling it from Terraform like this:
module "azure-basics" {
source = "dodevops/azuresql/azure"
version = "<version>"
}
The following requirements are needed by this module:
-
terraform (>=1.0.0)
-
azurerm (>=3.0.0)
The following providers are used by this module:
- azurerm (>=3.0.0)
No modules.
The following resources are used by this module:
- azurerm_mssql_database.azuresqldb (resource)
- azurerm_mssql_database_extended_auditing_policy.azuresql-audit-policy (resource)
- azurerm_mssql_firewall_rule.azure-sql-enable-access-firewall (resource)
- azurerm_mssql_server.azuresqldbsrv (resource)
- azurerm_storage_account.azuresql-audit-storage-account (resource)
The following input variables are required:
Description: Password for the SQL server administrator login
Type: string
Description: Azure location to use
Type: string
Description: Three letter project key
Type: string
Description: Azure Resource Group to use
Type: string
Description: Which SKU to use - see https://registry.terraform.io/providers/hashicorp/azurerm/latest/docs/resources/mssql_database#sku_name
Type: string
Description: Stage for this ip
Type: string
The following input variables are optional (have default values):
Description: Enable audit of database access and usage
Type: bool
Default: true
Description: Whether or not public network access is allowed for this server
Type: bool
Default: false
Description: SQL server version to use
Type: string
Default: "12.0"
Description: suffix for special databases
Type: string
Default: ""
The following outputs are exported:
Description: n/a
Description: n/a
Description: n/a
Use the terraform module tools to check and generate the documentation by running
docker run -v "$PWD":/terraform ghcr.io/dodevops/terraform-module-tools:latest