54 lines
1.6 KiB
Terraform
54 lines
1.6 KiB
Terraform
|
|
resource "azurerm_mssql_server" "sql_server" {
|
|
name = var.sql_server_name
|
|
resource_group_name = var.resource_group_name
|
|
location = var.location
|
|
version = "12.0"
|
|
administrator_login = "4dm1n157r470r" # terraform docs
|
|
administrator_login_password = var.sql_admin_password
|
|
}
|
|
|
|
resource "azurerm_mssql_database" "oltp_database" {
|
|
name = var.oltp_database_name
|
|
server_id = azurerm_mssql_server.sql_server.id
|
|
collation = "SQL_Latin1_General_CP1_CI_AS"
|
|
license_type = "LicenseIncluded" # tbc, developer?
|
|
sku_name = "S0" # az sql db list-editions -l uksouth -o table
|
|
storage_account_type = "Local"
|
|
geo_backup_enabled = false
|
|
|
|
tags = {
|
|
volatile = true
|
|
}
|
|
|
|
|
|
lifecycle {
|
|
# prevent_destroy = true
|
|
prevent_destroy = false
|
|
# it should actually be true, so data is safe
|
|
# however our sandbox environment should be
|
|
# ripped out completely.
|
|
}
|
|
}
|
|
|
|
resource "azurerm_mssql_database" "olap_database" {
|
|
name = var.olap_database_name
|
|
server_id = azurerm_mssql_server.sql_server.id
|
|
collation = "SQL_Latin1_General_CP1_CI_AS"
|
|
license_type = "LicenseIncluded" # tbc, developer?
|
|
sku_name = "S0" # az sql db list-editions -l uksouth -o table
|
|
storage_account_type = "Local"
|
|
geo_backup_enabled = false
|
|
|
|
tags = {
|
|
volatile = true
|
|
}
|
|
|
|
lifecycle {
|
|
# prevent_destroy = true
|
|
prevent_destroy = false
|
|
# it should actually be true, so data is safe
|
|
# however our sandbox environment should be
|
|
# ripped out completely.
|
|
}
|
|
} |