Skip to content

JamesWoolfenden/terraform-azurerm-sql

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

61 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

terraform-azurerm-sql

Build Status Latest Release GitHub tag (latest SemVer) Terraform Version Infrastructure Tests pre-commit checkov Infrastructure Tests

This is module to help you deploy SQL ON AZURE.

Usage

Add module.sql.tf to your Terraform code:

module "sql" {
  source         = "JamesWoolfenden/sql/azure"
  version        = "0.0.2"
  resource_group = azurerm_resource_group.examplea
  database_name  = "mydatabase"
}

Supply values for your resource and database name, other values have defaults which can be over ridden.


This project is 100% Open Source and licensed under the APACHE2.

Requirements

No requirements.

Providers

Name Version
azurerm n/a
random n/a

Modules

No modules.

Resources

Name Type
azurerm_key_vault.example resource
azurerm_key_vault_access_policy.client resource
azurerm_key_vault_access_policy.storage resource
azurerm_key_vault_key.example resource
azurerm_mssql_database_extended_auditing_policy.example resource
azurerm_mssql_server_security_alert_policy.example resource
azurerm_mssql_server_vulnerability_assessment.example resource
azurerm_sql_active_directory_administrator.example resource
azurerm_sql_database.examplea resource
azurerm_sql_server.examplea resource
azurerm_storage_account.examplea resource
azurerm_storage_account_customer_managed_key.key resource
azurerm_storage_account_network_rules.store resource
azurerm_storage_container.examplea resource
random_password.examplea resource
azurerm_client_config.current data source

Inputs

Name Description Type Default Required
account_replication_type n/a string "LRS" no
account_tier n/a string "standard" no
administrator_login_password n/a string "" no
audit_retention_in_days Retention period for Audit logs in days number 90 no
common_tags This is to help you add tags to your cloud objects map(any) n/a yes
database_name n/a string n/a yes
default_action describe your variable string "Deny" no
email_addresses n/a list(any) n/a yes
key_vault n/a string "mykeyvault" no
log_analytics_workspace n/a any n/a yes
resource_group Object that contains resource group details any n/a yes
soft_delete_retention_days n/a number 14 no
sql n/a map
{
"administrator_login": "sqlman",
"minimum_tls_version": "1.2",
"name": "mymssqlserver",
"public_network_access_enabled": false,
"version": "12.0"
}
no
sql_server n/a string n/a yes

Outputs

Name Description
database n/a
server n/a
storage n/a

Related Projects

Check out these related projects.

References

For additional context, refer to some of these links.

Help

Got a question?

File a GitHub issue.

Contributing

Bug Reports & Feature Requests

Please use the issue tracker to report any bugs or file feature requests.

Copyrights

Copyright © 2019-2021 James Woolfenden

License

License

See LICENSE for full details.

Licensed to the Apache Software Foundation (ASF) under one or more contributor license agreements. See the NOTICE file distributed with this work for additional information regarding copyright ownership. The ASF licenses this file to you under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at

https://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License.

Contributors

James Woolfenden
James Woolfenden