| Name | Version |
|---|---|
| terraform | >=0.13 |
| azurerm | >=4.0.0 |
| Name | Version |
|---|---|
| azurerm | >=4.0.0 |
No modules.
| Name | Type |
|---|---|
| azurerm_mssql_database.mssql_database | resource |
| Name | Description | Type | Default | Required |
|---|---|---|---|---|
| auto_pause_delay_in_minutes | (Optional) Time in minutes after which database is automatically paused. A value of -1 means that automatic pause is disabled. This property is only settable for Serverless databases. | number |
null |
no |
| collation | (Optional) Specifies the collation of the database. Changing this forces a new resource to be created. | string |
"SQL_Latin1_General_CP1_CI_AS" |
no |
| create_mode | (Optional) The create mode of the database. Possible values are Copy, Default, OnlineSecondary, PointInTimeRestore, Recovery, Restore, RestoreExternalBackup, RestoreExternalBackupSecondary, RestoreLongTermRetentionBackup and Secondary. Mutually exclusive with import. Changing this forces a new resource to be created. Defaults to Default. | string |
"Default" |
no |
| license_type | (Optional) Specifies the license type applied to this database. Possible values are LicenseIncluded and BasePrice. | string |
"LicenseIncluded" |
no |
| max_size_gb | (Optional) The max size of the database in gigabytes. | number |
250 |
no |
| name | (Required) The name of the Microsoft SQL Server. This needs to be globally unique within Azure. Changing this forces a new resource to be created. | string |
n/a | yes |
| read_scale | (Optional) If enabled, connections that have application intent set to readonly in their connection string may be routed to a readonly secondary replica. This property is only settable for Premium and Business Critical databases. | bool |
true |
no |
| server_id | (Required) The id of the MS SQL Server on which to create the database. Changing this forces a new resource to be created. | string |
n/a | yes |
| sku_name | (Optional) Specifies the name of the SKU used by the database. For example, GP_S_Gen5_2,HS_Gen4_1,BC_Gen5_2, ElasticPool, Basic,S0, P2 ,DW100c, DS100. Changing this from the HyperScale service tier to another service tier will create a new resource. | string |
"P2" |
no |
| tags | (Optional) A mapping of tags to assign to the resource. | map(any) |
{} |
no |
| Name | Description |
|---|---|
| id | The ID of the MS SQL Database. |
| name | The Name of the MS SQL Database. |