Azure Classic

v5.19.0 published on Friday, Sep 16, 2022 by Pulumi

Database

Manages a MS SQL Database.

Example Usage

using System.Collections.Generic;
using Pulumi;
using Azure = Pulumi.Azure;

return await Deployment.RunAsync(() => 
{
    var exampleResourceGroup = new Azure.Core.ResourceGroup("exampleResourceGroup", new()
    {
        Location = "West Europe",
    });

    var exampleAccount = new Azure.Storage.Account("exampleAccount", new()
    {
        ResourceGroupName = exampleResourceGroup.Name,
        Location = exampleResourceGroup.Location,
        AccountTier = "Standard",
        AccountReplicationType = "LRS",
    });

    var exampleServer = new Azure.MSSql.Server("exampleServer", new()
    {
        ResourceGroupName = exampleResourceGroup.Name,
        Location = exampleResourceGroup.Location,
        Version = "12.0",
        AdministratorLogin = "4dm1n157r470r",
        AdministratorLoginPassword = "4-v3ry-53cr37-p455w0rd",
    });

    var test = new Azure.MSSql.Database("test", new()
    {
        ServerId = exampleServer.Id,
        Collation = "SQL_Latin1_General_CP1_CI_AS",
        LicenseType = "LicenseIncluded",
        MaxSizeGb = 4,
        ReadScale = true,
        SkuName = "S0",
        ZoneRedundant = true,
        Tags = 
        {
            { "foo", "bar" },
        },
    });

});
package main

import (
	"github.com/pulumi/pulumi-azure/sdk/v5/go/azure/core"
	"github.com/pulumi/pulumi-azure/sdk/v5/go/azure/mssql"
	"github.com/pulumi/pulumi-azure/sdk/v5/go/azure/storage"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		exampleResourceGroup, err := core.NewResourceGroup(ctx, "exampleResourceGroup", &core.ResourceGroupArgs{
			Location: pulumi.String("West Europe"),
		})
		if err != nil {
			return err
		}
		_, err = storage.NewAccount(ctx, "exampleAccount", &storage.AccountArgs{
			ResourceGroupName:      exampleResourceGroup.Name,
			Location:               exampleResourceGroup.Location,
			AccountTier:            pulumi.String("Standard"),
			AccountReplicationType: pulumi.String("LRS"),
		})
		if err != nil {
			return err
		}
		exampleServer, err := mssql.NewServer(ctx, "exampleServer", &mssql.ServerArgs{
			ResourceGroupName:          exampleResourceGroup.Name,
			Location:                   exampleResourceGroup.Location,
			Version:                    pulumi.String("12.0"),
			AdministratorLogin:         pulumi.String("4dm1n157r470r"),
			AdministratorLoginPassword: pulumi.String("4-v3ry-53cr37-p455w0rd"),
		})
		if err != nil {
			return err
		}
		_, err = mssql.NewDatabase(ctx, "test", &mssql.DatabaseArgs{
			ServerId:      exampleServer.ID(),
			Collation:     pulumi.String("SQL_Latin1_General_CP1_CI_AS"),
			LicenseType:   pulumi.String("LicenseIncluded"),
			MaxSizeGb:     pulumi.Int(4),
			ReadScale:     pulumi.Bool(true),
			SkuName:       pulumi.String("S0"),
			ZoneRedundant: pulumi.Bool(true),
			Tags: pulumi.StringMap{
				"foo": pulumi.String("bar"),
			},
		})
		if err != nil {
			return err
		}
		return nil
	})
}
package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.azure.core.ResourceGroup;
import com.pulumi.azure.core.ResourceGroupArgs;
import com.pulumi.azure.storage.Account;
import com.pulumi.azure.storage.AccountArgs;
import com.pulumi.azure.mssql.Server;
import com.pulumi.azure.mssql.ServerArgs;
import com.pulumi.azure.mssql.Database;
import com.pulumi.azure.mssql.DatabaseArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;

public class App {
    public static void main(String[] args) {
        Pulumi.run(App::stack);
    }

    public static void stack(Context ctx) {
        var exampleResourceGroup = new ResourceGroup("exampleResourceGroup", ResourceGroupArgs.builder()        
            .location("West Europe")
            .build());

        var exampleAccount = new Account("exampleAccount", AccountArgs.builder()        
            .resourceGroupName(exampleResourceGroup.name())
            .location(exampleResourceGroup.location())
            .accountTier("Standard")
            .accountReplicationType("LRS")
            .build());

        var exampleServer = new Server("exampleServer", ServerArgs.builder()        
            .resourceGroupName(exampleResourceGroup.name())
            .location(exampleResourceGroup.location())
            .version("12.0")
            .administratorLogin("4dm1n157r470r")
            .administratorLoginPassword("4-v3ry-53cr37-p455w0rd")
            .build());

        var test = new Database("test", DatabaseArgs.builder()        
            .serverId(exampleServer.id())
            .collation("SQL_Latin1_General_CP1_CI_AS")
            .licenseType("LicenseIncluded")
            .maxSizeGb(4)
            .readScale(true)
            .skuName("S0")
            .zoneRedundant(true)
            .tags(Map.of("foo", "bar"))
            .build());

    }
}
import pulumi
import pulumi_azure as azure

example_resource_group = azure.core.ResourceGroup("exampleResourceGroup", location="West Europe")
example_account = azure.storage.Account("exampleAccount",
    resource_group_name=example_resource_group.name,
    location=example_resource_group.location,
    account_tier="Standard",
    account_replication_type="LRS")
example_server = azure.mssql.Server("exampleServer",
    resource_group_name=example_resource_group.name,
    location=example_resource_group.location,
    version="12.0",
    administrator_login="4dm1n157r470r",
    administrator_login_password="4-v3ry-53cr37-p455w0rd")
test = azure.mssql.Database("test",
    server_id=example_server.id,
    collation="SQL_Latin1_General_CP1_CI_AS",
    license_type="LicenseIncluded",
    max_size_gb=4,
    read_scale=True,
    sku_name="S0",
    zone_redundant=True,
    tags={
        "foo": "bar",
    })
import * as pulumi from "@pulumi/pulumi";
import * as azure from "@pulumi/azure";

const exampleResourceGroup = new azure.core.ResourceGroup("exampleResourceGroup", {location: "West Europe"});
const exampleAccount = new azure.storage.Account("exampleAccount", {
    resourceGroupName: exampleResourceGroup.name,
    location: exampleResourceGroup.location,
    accountTier: "Standard",
    accountReplicationType: "LRS",
});
const exampleServer = new azure.mssql.Server("exampleServer", {
    resourceGroupName: exampleResourceGroup.name,
    location: exampleResourceGroup.location,
    version: "12.0",
    administratorLogin: "4dm1n157r470r",
    administratorLoginPassword: "4-v3ry-53cr37-p455w0rd",
});
const test = new azure.mssql.Database("test", {
    serverId: exampleServer.id,
    collation: "SQL_Latin1_General_CP1_CI_AS",
    licenseType: "LicenseIncluded",
    maxSizeGb: 4,
    readScale: true,
    skuName: "S0",
    zoneRedundant: true,
    tags: {
        foo: "bar",
    },
});
resources:
  exampleResourceGroup:
    type: azure:core:ResourceGroup
    properties:
      location: West Europe
  exampleAccount:
    type: azure:storage:Account
    properties:
      resourceGroupName: ${exampleResourceGroup.name}
      location: ${exampleResourceGroup.location}
      accountTier: Standard
      accountReplicationType: LRS
  exampleServer:
    type: azure:mssql:Server
    properties:
      resourceGroupName: ${exampleResourceGroup.name}
      location: ${exampleResourceGroup.location}
      version: 12.0
      administratorLogin: 4dm1n157r470r
      administratorLoginPassword: 4-v3ry-53cr37-p455w0rd
  test:
    type: azure:mssql:Database
    properties:
      serverId: ${exampleServer.id}
      collation: SQL_Latin1_General_CP1_CI_AS
      licenseType: LicenseIncluded
      maxSizeGb: 4
      readScale: true
      skuName: S0
      zoneRedundant: true
      tags:
        foo: bar

Create a Database Resource

new Database(name: string, args: DatabaseArgs, opts?: CustomResourceOptions);
@overload
def Database(resource_name: str,
             opts: Optional[ResourceOptions] = None,
             auto_pause_delay_in_minutes: Optional[int] = None,
             collation: Optional[str] = None,
             create_mode: Optional[str] = None,
             creation_source_database_id: Optional[str] = None,
             elastic_pool_id: Optional[str] = None,
             geo_backup_enabled: Optional[bool] = None,
             ledger_enabled: Optional[bool] = None,
             license_type: Optional[str] = None,
             long_term_retention_policy: Optional[DatabaseLongTermRetentionPolicyArgs] = None,
             maintenance_configuration_name: Optional[str] = None,
             max_size_gb: Optional[int] = None,
             min_capacity: Optional[float] = None,
             name: Optional[str] = None,
             read_replica_count: Optional[int] = None,
             read_scale: Optional[bool] = None,
             recover_database_id: Optional[str] = None,
             restore_dropped_database_id: Optional[str] = None,
             restore_point_in_time: Optional[str] = None,
             sample_name: Optional[str] = None,
             server_id: Optional[str] = None,
             short_term_retention_policy: Optional[DatabaseShortTermRetentionPolicyArgs] = None,
             sku_name: Optional[str] = None,
             storage_account_type: Optional[str] = None,
             tags: Optional[Mapping[str, str]] = None,
             threat_detection_policy: Optional[DatabaseThreatDetectionPolicyArgs] = None,
             transparent_data_encryption_enabled: Optional[bool] = None,
             zone_redundant: Optional[bool] = None)
@overload
def Database(resource_name: str,
             args: DatabaseArgs,
             opts: Optional[ResourceOptions] = None)
func NewDatabase(ctx *Context, name string, args DatabaseArgs, opts ...ResourceOption) (*Database, error)
public Database(string name, DatabaseArgs args, CustomResourceOptions? opts = null)
public Database(String name, DatabaseArgs args)
public Database(String name, DatabaseArgs args, CustomResourceOptions options)
type: azure:mssql:Database
properties: # The arguments to resource properties.
options: # Bag of options to control resource's behavior.

name string
The unique name of the resource.
args DatabaseArgs
The arguments to resource properties.
opts CustomResourceOptions
Bag of options to control resource's behavior.
resource_name str
The unique name of the resource.
args DatabaseArgs
The arguments to resource properties.
opts ResourceOptions
Bag of options to control resource's behavior.
ctx Context
Context object for the current deployment.
name string
The unique name of the resource.
args DatabaseArgs
The arguments to resource properties.
opts ResourceOption
Bag of options to control resource's behavior.
name string
The unique name of the resource.
args DatabaseArgs
The arguments to resource properties.
opts CustomResourceOptions
Bag of options to control resource's behavior.
name String
The unique name of the resource.
args DatabaseArgs
The arguments to resource properties.
options CustomResourceOptions
Bag of options to control resource's behavior.

Database Resource Properties

To learn more about resource properties and how to use them, see Inputs and Outputs in the Architecture and Concepts docs.

Inputs

The Database resource accepts the following input properties:

ServerId string

The id of the MS SQL Server on which to create the database. Changing this forces a new resource to be created.

AutoPauseDelayInMinutes int

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 General Purpose Serverless databases.

Collation string

Specifies the collation of the database. Changing this forces a new resource to be created.

CreateMode string

The create mode of the database. Possible values are Copy, Default, OnlineSecondary, PointInTimeRestore, Recovery, Restore, RestoreExternalBackup, RestoreExternalBackupSecondary, RestoreLongTermRetentionBackup and Secondary.

CreationSourceDatabaseId string

The ID of the source database from which to create the new database. This should only be used for databases with create_mode values that use another database as reference. Changing this forces a new resource to be created.

ElasticPoolId string

Specifies the ID of the elastic pool containing this database.

GeoBackupEnabled bool

A boolean that specifies if the Geo Backup Policy is enabled.

LedgerEnabled bool

A boolean that specifies if this is a ledger database. Defaults to false. Changing this forces a new resource to be created.

LicenseType string

Specifies the license type applied to this database. Possible values are LicenseIncluded and BasePrice.

LongTermRetentionPolicy DatabaseLongTermRetentionPolicyArgs

A long_term_retention_policy block as defined below.

MaintenanceConfigurationName string

The name of the Public Maintenance Configuration window to apply to the database. Valid values include SQL_Default, SQL_EastUS_DB_1, SQL_EastUS2_DB_1, SQL_SoutheastAsia_DB_1, SQL_AustraliaEast_DB_1, SQL_NorthEurope_DB_1, SQL_SouthCentralUS_DB_1, SQL_WestUS2_DB_1, SQL_UKSouth_DB_1, SQL_WestEurope_DB_1, SQL_EastUS_DB_2, SQL_EastUS2_DB_2, SQL_WestUS2_DB_2, SQL_SoutheastAsia_DB_2, SQL_AustraliaEast_DB_2, SQL_NorthEurope_DB_2, SQL_SouthCentralUS_DB_2, SQL_UKSouth_DB_2, SQL_WestEurope_DB_2, SQL_AustraliaSoutheast_DB_1, SQL_BrazilSouth_DB_1, SQL_CanadaCentral_DB_1, SQL_CanadaEast_DB_1, SQL_CentralUS_DB_1, SQL_EastAsia_DB_1, SQL_FranceCentral_DB_1, SQL_GermanyWestCentral_DB_1, SQL_CentralIndia_DB_1, SQL_SouthIndia_DB_1, SQL_JapanEast_DB_1, SQL_JapanWest_DB_1, SQL_NorthCentralUS_DB_1, SQL_UKWest_DB_1, SQL_WestUS_DB_1, SQL_AustraliaSoutheast_DB_2, SQL_BrazilSouth_DB_2, SQL_CanadaCentral_DB_2, SQL_CanadaEast_DB_2, SQL_CentralUS_DB_2, SQL_EastAsia_DB_2, SQL_FranceCentral_DB_2, SQL_GermanyWestCentral_DB_2, SQL_CentralIndia_DB_2, SQL_SouthIndia_DB_2, SQL_JapanEast_DB_2, SQL_JapanWest_DB_2, SQL_NorthCentralUS_DB_2, SQL_UKWest_DB_2, SQL_WestUS_DB_2, SQL_WestCentralUS_DB_1, SQL_FranceSouth_DB_1, SQL_WestCentralUS_DB_2, SQL_FranceSouth_DB_2, SQL_SwitzerlandNorth_DB_1, SQL_SwitzerlandNorth_DB_2, SQL_BrazilSoutheast_DB_1, SQL_UAENorth_DB_1, SQL_BrazilSoutheast_DB_2, SQL_UAENorth_DB_2. Defaults to SQL_Default.

MaxSizeGb int

The max size of the database in gigabytes.

MinCapacity double

Minimal capacity that database will always have allocated, if not paused. This property is only settable for General Purpose Serverless databases.

Name string

The name of the MS SQL Database. Changing this forces a new resource to be created.

ReadReplicaCount int

The number of readonly secondary replicas associated with the database to which readonly application intent connections may be routed. This property is only settable for Hyperscale edition databases.

ReadScale bool

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.

RecoverDatabaseId string

The ID of the database to be recovered. This property is only applicable when the create_mode is Recovery.

RestoreDroppedDatabaseId string

The ID of the database to be restored. This property is only applicable when the create_mode is Restore.

RestorePointInTime string

Specifies the point in time (ISO8601 format) of the source database that will be restored to create the new database. This property is only settable for create_mode= PointInTimeRestore databases.

SampleName string

Specifies the name of the sample schema to apply when creating this database. Possible value is AdventureWorksLT.

ShortTermRetentionPolicy DatabaseShortTermRetentionPolicyArgs

A short_term_retention_policy block as defined below.

SkuName string

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 force a new resource to be created.

StorageAccountType string

Specifies the storage account type used to store backups for this database. Possible values are Geo, GeoZone, Local and Zone. The default value is Geo.

Tags Dictionary<string, string>

A mapping of tags to assign to the resource.

ThreatDetectionPolicy DatabaseThreatDetectionPolicyArgs

Threat detection policy configuration. The threat_detection_policy block supports fields documented below.

TransparentDataEncryptionEnabled bool

If set to true, Transparent Data Encryption will be enabled on the database. Defaults to true.

ZoneRedundant bool

Whether or not this database is zone redundant, which means the replicas of this database will be spread across multiple availability zones. This property is only settable for Premium and Business Critical databases.

ServerId string

The id of the MS SQL Server on which to create the database. Changing this forces a new resource to be created.

AutoPauseDelayInMinutes int

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 General Purpose Serverless databases.

Collation string

Specifies the collation of the database. Changing this forces a new resource to be created.

CreateMode string

The create mode of the database. Possible values are Copy, Default, OnlineSecondary, PointInTimeRestore, Recovery, Restore, RestoreExternalBackup, RestoreExternalBackupSecondary, RestoreLongTermRetentionBackup and Secondary.

CreationSourceDatabaseId string

The ID of the source database from which to create the new database. This should only be used for databases with create_mode values that use another database as reference. Changing this forces a new resource to be created.

ElasticPoolId string

Specifies the ID of the elastic pool containing this database.

GeoBackupEnabled bool

A boolean that specifies if the Geo Backup Policy is enabled.

LedgerEnabled bool

A boolean that specifies if this is a ledger database. Defaults to false. Changing this forces a new resource to be created.

LicenseType string

Specifies the license type applied to this database. Possible values are LicenseIncluded and BasePrice.

LongTermRetentionPolicy DatabaseLongTermRetentionPolicyArgs

A long_term_retention_policy block as defined below.

MaintenanceConfigurationName string

The name of the Public Maintenance Configuration window to apply to the database. Valid values include SQL_Default, SQL_EastUS_DB_1, SQL_EastUS2_DB_1, SQL_SoutheastAsia_DB_1, SQL_AustraliaEast_DB_1, SQL_NorthEurope_DB_1, SQL_SouthCentralUS_DB_1, SQL_WestUS2_DB_1, SQL_UKSouth_DB_1, SQL_WestEurope_DB_1, SQL_EastUS_DB_2, SQL_EastUS2_DB_2, SQL_WestUS2_DB_2, SQL_SoutheastAsia_DB_2, SQL_AustraliaEast_DB_2, SQL_NorthEurope_DB_2, SQL_SouthCentralUS_DB_2, SQL_UKSouth_DB_2, SQL_WestEurope_DB_2, SQL_AustraliaSoutheast_DB_1, SQL_BrazilSouth_DB_1, SQL_CanadaCentral_DB_1, SQL_CanadaEast_DB_1, SQL_CentralUS_DB_1, SQL_EastAsia_DB_1, SQL_FranceCentral_DB_1, SQL_GermanyWestCentral_DB_1, SQL_CentralIndia_DB_1, SQL_SouthIndia_DB_1, SQL_JapanEast_DB_1, SQL_JapanWest_DB_1, SQL_NorthCentralUS_DB_1, SQL_UKWest_DB_1, SQL_WestUS_DB_1, SQL_AustraliaSoutheast_DB_2, SQL_BrazilSouth_DB_2, SQL_CanadaCentral_DB_2, SQL_CanadaEast_DB_2, SQL_CentralUS_DB_2, SQL_EastAsia_DB_2, SQL_FranceCentral_DB_2, SQL_GermanyWestCentral_DB_2, SQL_CentralIndia_DB_2, SQL_SouthIndia_DB_2, SQL_JapanEast_DB_2, SQL_JapanWest_DB_2, SQL_NorthCentralUS_DB_2, SQL_UKWest_DB_2, SQL_WestUS_DB_2, SQL_WestCentralUS_DB_1, SQL_FranceSouth_DB_1, SQL_WestCentralUS_DB_2, SQL_FranceSouth_DB_2, SQL_SwitzerlandNorth_DB_1, SQL_SwitzerlandNorth_DB_2, SQL_BrazilSoutheast_DB_1, SQL_UAENorth_DB_1, SQL_BrazilSoutheast_DB_2, SQL_UAENorth_DB_2. Defaults to SQL_Default.

MaxSizeGb int

The max size of the database in gigabytes.

MinCapacity float64

Minimal capacity that database will always have allocated, if not paused. This property is only settable for General Purpose Serverless databases.

Name string

The name of the MS SQL Database. Changing this forces a new resource to be created.

ReadReplicaCount int

The number of readonly secondary replicas associated with the database to which readonly application intent connections may be routed. This property is only settable for Hyperscale edition databases.

ReadScale bool

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.

RecoverDatabaseId string

The ID of the database to be recovered. This property is only applicable when the create_mode is Recovery.

RestoreDroppedDatabaseId string

The ID of the database to be restored. This property is only applicable when the create_mode is Restore.

RestorePointInTime string

Specifies the point in time (ISO8601 format) of the source database that will be restored to create the new database. This property is only settable for create_mode= PointInTimeRestore databases.

SampleName string

Specifies the name of the sample schema to apply when creating this database. Possible value is AdventureWorksLT.

ShortTermRetentionPolicy DatabaseShortTermRetentionPolicyArgs

A short_term_retention_policy block as defined below.

SkuName string

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 force a new resource to be created.

StorageAccountType string

Specifies the storage account type used to store backups for this database. Possible values are Geo, GeoZone, Local and Zone. The default value is Geo.

Tags map[string]string

A mapping of tags to assign to the resource.

ThreatDetectionPolicy DatabaseThreatDetectionPolicyArgs

Threat detection policy configuration. The threat_detection_policy block supports fields documented below.

TransparentDataEncryptionEnabled bool

If set to true, Transparent Data Encryption will be enabled on the database. Defaults to true.

ZoneRedundant bool

Whether or not this database is zone redundant, which means the replicas of this database will be spread across multiple availability zones. This property is only settable for Premium and Business Critical databases.

serverId String

The id of the MS SQL Server on which to create the database. Changing this forces a new resource to be created.

autoPauseDelayInMinutes Integer

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 General Purpose Serverless databases.

collation String

Specifies the collation of the database. Changing this forces a new resource to be created.

createMode String

The create mode of the database. Possible values are Copy, Default, OnlineSecondary, PointInTimeRestore, Recovery, Restore, RestoreExternalBackup, RestoreExternalBackupSecondary, RestoreLongTermRetentionBackup and Secondary.

creationSourceDatabaseId String

The ID of the source database from which to create the new database. This should only be used for databases with create_mode values that use another database as reference. Changing this forces a new resource to be created.

elasticPoolId String

Specifies the ID of the elastic pool containing this database.

geoBackupEnabled Boolean

A boolean that specifies if the Geo Backup Policy is enabled.

ledgerEnabled Boolean

A boolean that specifies if this is a ledger database. Defaults to false. Changing this forces a new resource to be created.

licenseType String

Specifies the license type applied to this database. Possible values are LicenseIncluded and BasePrice.

longTermRetentionPolicy DatabaseLongTermRetentionPolicyArgs

A long_term_retention_policy block as defined below.

maintenanceConfigurationName String

The name of the Public Maintenance Configuration window to apply to the database. Valid values include SQL_Default, SQL_EastUS_DB_1, SQL_EastUS2_DB_1, SQL_SoutheastAsia_DB_1, SQL_AustraliaEast_DB_1, SQL_NorthEurope_DB_1, SQL_SouthCentralUS_DB_1, SQL_WestUS2_DB_1, SQL_UKSouth_DB_1, SQL_WestEurope_DB_1, SQL_EastUS_DB_2, SQL_EastUS2_DB_2, SQL_WestUS2_DB_2, SQL_SoutheastAsia_DB_2, SQL_AustraliaEast_DB_2, SQL_NorthEurope_DB_2, SQL_SouthCentralUS_DB_2, SQL_UKSouth_DB_2, SQL_WestEurope_DB_2, SQL_AustraliaSoutheast_DB_1, SQL_BrazilSouth_DB_1, SQL_CanadaCentral_DB_1, SQL_CanadaEast_DB_1, SQL_CentralUS_DB_1, SQL_EastAsia_DB_1, SQL_FranceCentral_DB_1, SQL_GermanyWestCentral_DB_1, SQL_CentralIndia_DB_1, SQL_SouthIndia_DB_1, SQL_JapanEast_DB_1, SQL_JapanWest_DB_1, SQL_NorthCentralUS_DB_1, SQL_UKWest_DB_1, SQL_WestUS_DB_1, SQL_AustraliaSoutheast_DB_2, SQL_BrazilSouth_DB_2, SQL_CanadaCentral_DB_2, SQL_CanadaEast_DB_2, SQL_CentralUS_DB_2, SQL_EastAsia_DB_2, SQL_FranceCentral_DB_2, SQL_GermanyWestCentral_DB_2, SQL_CentralIndia_DB_2, SQL_SouthIndia_DB_2, SQL_JapanEast_DB_2, SQL_JapanWest_DB_2, SQL_NorthCentralUS_DB_2, SQL_UKWest_DB_2, SQL_WestUS_DB_2, SQL_WestCentralUS_DB_1, SQL_FranceSouth_DB_1, SQL_WestCentralUS_DB_2, SQL_FranceSouth_DB_2, SQL_SwitzerlandNorth_DB_1, SQL_SwitzerlandNorth_DB_2, SQL_BrazilSoutheast_DB_1, SQL_UAENorth_DB_1, SQL_BrazilSoutheast_DB_2, SQL_UAENorth_DB_2. Defaults to SQL_Default.

maxSizeGb Integer

The max size of the database in gigabytes.

minCapacity Double

Minimal capacity that database will always have allocated, if not paused. This property is only settable for General Purpose Serverless databases.

name String

The name of the MS SQL Database. Changing this forces a new resource to be created.

readReplicaCount Integer

The number of readonly secondary replicas associated with the database to which readonly application intent connections may be routed. This property is only settable for Hyperscale edition databases.

readScale Boolean

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.

recoverDatabaseId String

The ID of the database to be recovered. This property is only applicable when the create_mode is Recovery.

restoreDroppedDatabaseId String

The ID of the database to be restored. This property is only applicable when the create_mode is Restore.

restorePointInTime String

Specifies the point in time (ISO8601 format) of the source database that will be restored to create the new database. This property is only settable for create_mode= PointInTimeRestore databases.

sampleName String

Specifies the name of the sample schema to apply when creating this database. Possible value is AdventureWorksLT.

shortTermRetentionPolicy DatabaseShortTermRetentionPolicyArgs

A short_term_retention_policy block as defined below.

skuName String

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 force a new resource to be created.

storageAccountType String

Specifies the storage account type used to store backups for this database. Possible values are Geo, GeoZone, Local and Zone. The default value is Geo.

tags Map<String,String>

A mapping of tags to assign to the resource.

threatDetectionPolicy DatabaseThreatDetectionPolicyArgs

Threat detection policy configuration. The threat_detection_policy block supports fields documented below.

transparentDataEncryptionEnabled Boolean

If set to true, Transparent Data Encryption will be enabled on the database. Defaults to true.

zoneRedundant Boolean

Whether or not this database is zone redundant, which means the replicas of this database will be spread across multiple availability zones. This property is only settable for Premium and Business Critical databases.

serverId string

The id of the MS SQL Server on which to create the database. Changing this forces a new resource to be created.

autoPauseDelayInMinutes number

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 General Purpose Serverless databases.

collation string

Specifies the collation of the database. Changing this forces a new resource to be created.

createMode string

The create mode of the database. Possible values are Copy, Default, OnlineSecondary, PointInTimeRestore, Recovery, Restore, RestoreExternalBackup, RestoreExternalBackupSecondary, RestoreLongTermRetentionBackup and Secondary.

creationSourceDatabaseId string

The ID of the source database from which to create the new database. This should only be used for databases with create_mode values that use another database as reference. Changing this forces a new resource to be created.

elasticPoolId string

Specifies the ID of the elastic pool containing this database.

geoBackupEnabled boolean

A boolean that specifies if the Geo Backup Policy is enabled.

ledgerEnabled boolean

A boolean that specifies if this is a ledger database. Defaults to false. Changing this forces a new resource to be created.

licenseType string

Specifies the license type applied to this database. Possible values are LicenseIncluded and BasePrice.

longTermRetentionPolicy DatabaseLongTermRetentionPolicyArgs

A long_term_retention_policy block as defined below.

maintenanceConfigurationName string

The name of the Public Maintenance Configuration window to apply to the database. Valid values include SQL_Default, SQL_EastUS_DB_1, SQL_EastUS2_DB_1, SQL_SoutheastAsia_DB_1, SQL_AustraliaEast_DB_1, SQL_NorthEurope_DB_1, SQL_SouthCentralUS_DB_1, SQL_WestUS2_DB_1, SQL_UKSouth_DB_1, SQL_WestEurope_DB_1, SQL_EastUS_DB_2, SQL_EastUS2_DB_2, SQL_WestUS2_DB_2, SQL_SoutheastAsia_DB_2, SQL_AustraliaEast_DB_2, SQL_NorthEurope_DB_2, SQL_SouthCentralUS_DB_2, SQL_UKSouth_DB_2, SQL_WestEurope_DB_2, SQL_AustraliaSoutheast_DB_1, SQL_BrazilSouth_DB_1, SQL_CanadaCentral_DB_1, SQL_CanadaEast_DB_1, SQL_CentralUS_DB_1, SQL_EastAsia_DB_1, SQL_FranceCentral_DB_1, SQL_GermanyWestCentral_DB_1, SQL_CentralIndia_DB_1, SQL_SouthIndia_DB_1, SQL_JapanEast_DB_1, SQL_JapanWest_DB_1, SQL_NorthCentralUS_DB_1, SQL_UKWest_DB_1, SQL_WestUS_DB_1, SQL_AustraliaSoutheast_DB_2, SQL_BrazilSouth_DB_2, SQL_CanadaCentral_DB_2, SQL_CanadaEast_DB_2, SQL_CentralUS_DB_2, SQL_EastAsia_DB_2, SQL_FranceCentral_DB_2, SQL_GermanyWestCentral_DB_2, SQL_CentralIndia_DB_2, SQL_SouthIndia_DB_2, SQL_JapanEast_DB_2, SQL_JapanWest_DB_2, SQL_NorthCentralUS_DB_2, SQL_UKWest_DB_2, SQL_WestUS_DB_2, SQL_WestCentralUS_DB_1, SQL_FranceSouth_DB_1, SQL_WestCentralUS_DB_2, SQL_FranceSouth_DB_2, SQL_SwitzerlandNorth_DB_1, SQL_SwitzerlandNorth_DB_2, SQL_BrazilSoutheast_DB_1, SQL_UAENorth_DB_1, SQL_BrazilSoutheast_DB_2, SQL_UAENorth_DB_2. Defaults to SQL_Default.

maxSizeGb number

The max size of the database in gigabytes.

minCapacity number

Minimal capacity that database will always have allocated, if not paused. This property is only settable for General Purpose Serverless databases.

name string

The name of the MS SQL Database. Changing this forces a new resource to be created.

readReplicaCount number

The number of readonly secondary replicas associated with the database to which readonly application intent connections may be routed. This property is only settable for Hyperscale edition databases.

readScale boolean

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.

recoverDatabaseId string

The ID of the database to be recovered. This property is only applicable when the create_mode is Recovery.

restoreDroppedDatabaseId string

The ID of the database to be restored. This property is only applicable when the create_mode is Restore.

restorePointInTime string

Specifies the point in time (ISO8601 format) of the source database that will be restored to create the new database. This property is only settable for create_mode= PointInTimeRestore databases.

sampleName string

Specifies the name of the sample schema to apply when creating this database. Possible value is AdventureWorksLT.

shortTermRetentionPolicy DatabaseShortTermRetentionPolicyArgs

A short_term_retention_policy block as defined below.

skuName string

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 force a new resource to be created.

storageAccountType string

Specifies the storage account type used to store backups for this database. Possible values are Geo, GeoZone, Local and Zone. The default value is Geo.

tags {[key: string]: string}

A mapping of tags to assign to the resource.

threatDetectionPolicy DatabaseThreatDetectionPolicyArgs

Threat detection policy configuration. The threat_detection_policy block supports fields documented below.

transparentDataEncryptionEnabled boolean

If set to true, Transparent Data Encryption will be enabled on the database. Defaults to true.

zoneRedundant boolean

Whether or not this database is zone redundant, which means the replicas of this database will be spread across multiple availability zones. This property is only settable for Premium and Business Critical databases.

server_id str

The id of the MS SQL Server on which to create the database. Changing this forces a new resource to be created.

auto_pause_delay_in_minutes int

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 General Purpose Serverless databases.

collation str

Specifies the collation of the database. Changing this forces a new resource to be created.

create_mode str

The create mode of the database. Possible values are Copy, Default, OnlineSecondary, PointInTimeRestore, Recovery, Restore, RestoreExternalBackup, RestoreExternalBackupSecondary, RestoreLongTermRetentionBackup and Secondary.

creation_source_database_id str

The ID of the source database from which to create the new database. This should only be used for databases with create_mode values that use another database as reference. Changing this forces a new resource to be created.

elastic_pool_id str

Specifies the ID of the elastic pool containing this database.

geo_backup_enabled bool

A boolean that specifies if the Geo Backup Policy is enabled.

ledger_enabled bool

A boolean that specifies if this is a ledger database. Defaults to false. Changing this forces a new resource to be created.

license_type str

Specifies the license type applied to this database. Possible values are LicenseIncluded and BasePrice.

long_term_retention_policy DatabaseLongTermRetentionPolicyArgs

A long_term_retention_policy block as defined below.

maintenance_configuration_name str

The name of the Public Maintenance Configuration window to apply to the database. Valid values include SQL_Default, SQL_EastUS_DB_1, SQL_EastUS2_DB_1, SQL_SoutheastAsia_DB_1, SQL_AustraliaEast_DB_1, SQL_NorthEurope_DB_1, SQL_SouthCentralUS_DB_1, SQL_WestUS2_DB_1, SQL_UKSouth_DB_1, SQL_WestEurope_DB_1, SQL_EastUS_DB_2, SQL_EastUS2_DB_2, SQL_WestUS2_DB_2, SQL_SoutheastAsia_DB_2, SQL_AustraliaEast_DB_2, SQL_NorthEurope_DB_2, SQL_SouthCentralUS_DB_2, SQL_UKSouth_DB_2, SQL_WestEurope_DB_2, SQL_AustraliaSoutheast_DB_1, SQL_BrazilSouth_DB_1, SQL_CanadaCentral_DB_1, SQL_CanadaEast_DB_1, SQL_CentralUS_DB_1, SQL_EastAsia_DB_1, SQL_FranceCentral_DB_1, SQL_GermanyWestCentral_DB_1, SQL_CentralIndia_DB_1, SQL_SouthIndia_DB_1, SQL_JapanEast_DB_1, SQL_JapanWest_DB_1, SQL_NorthCentralUS_DB_1, SQL_UKWest_DB_1, SQL_WestUS_DB_1, SQL_AustraliaSoutheast_DB_2, SQL_BrazilSouth_DB_2, SQL_CanadaCentral_DB_2, SQL_CanadaEast_DB_2, SQL_CentralUS_DB_2, SQL_EastAsia_DB_2, SQL_FranceCentral_DB_2, SQL_GermanyWestCentral_DB_2, SQL_CentralIndia_DB_2, SQL_SouthIndia_DB_2, SQL_JapanEast_DB_2, SQL_JapanWest_DB_2, SQL_NorthCentralUS_DB_2, SQL_UKWest_DB_2, SQL_WestUS_DB_2, SQL_WestCentralUS_DB_1, SQL_FranceSouth_DB_1, SQL_WestCentralUS_DB_2, SQL_FranceSouth_DB_2, SQL_SwitzerlandNorth_DB_1, SQL_SwitzerlandNorth_DB_2, SQL_BrazilSoutheast_DB_1, SQL_UAENorth_DB_1, SQL_BrazilSoutheast_DB_2, SQL_UAENorth_DB_2. Defaults to SQL_Default.

max_size_gb int

The max size of the database in gigabytes.

min_capacity float

Minimal capacity that database will always have allocated, if not paused. This property is only settable for General Purpose Serverless databases.

name str

The name of the MS SQL Database. Changing this forces a new resource to be created.

read_replica_count int

The number of readonly secondary replicas associated with the database to which readonly application intent connections may be routed. This property is only settable for Hyperscale edition databases.

read_scale bool

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.

recover_database_id str

The ID of the database to be recovered. This property is only applicable when the create_mode is Recovery.

restore_dropped_database_id str

The ID of the database to be restored. This property is only applicable when the create_mode is Restore.

restore_point_in_time str

Specifies the point in time (ISO8601 format) of the source database that will be restored to create the new database. This property is only settable for create_mode= PointInTimeRestore databases.

sample_name str

Specifies the name of the sample schema to apply when creating this database. Possible value is AdventureWorksLT.

short_term_retention_policy DatabaseShortTermRetentionPolicyArgs

A short_term_retention_policy block as defined below.

sku_name str

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 force a new resource to be created.

storage_account_type str

Specifies the storage account type used to store backups for this database. Possible values are Geo, GeoZone, Local and Zone. The default value is Geo.

tags Mapping[str, str]

A mapping of tags to assign to the resource.

threat_detection_policy DatabaseThreatDetectionPolicyArgs

Threat detection policy configuration. The threat_detection_policy block supports fields documented below.

transparent_data_encryption_enabled bool

If set to true, Transparent Data Encryption will be enabled on the database. Defaults to true.

zone_redundant bool

Whether or not this database is zone redundant, which means the replicas of this database will be spread across multiple availability zones. This property is only settable for Premium and Business Critical databases.

serverId String

The id of the MS SQL Server on which to create the database. Changing this forces a new resource to be created.

autoPauseDelayInMinutes Number

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 General Purpose Serverless databases.

collation String

Specifies the collation of the database. Changing this forces a new resource to be created.

createMode String

The create mode of the database. Possible values are Copy, Default, OnlineSecondary, PointInTimeRestore, Recovery, Restore, RestoreExternalBackup, RestoreExternalBackupSecondary, RestoreLongTermRetentionBackup and Secondary.

creationSourceDatabaseId String

The ID of the source database from which to create the new database. This should only be used for databases with create_mode values that use another database as reference. Changing this forces a new resource to be created.

elasticPoolId String

Specifies the ID of the elastic pool containing this database.

geoBackupEnabled Boolean

A boolean that specifies if the Geo Backup Policy is enabled.

ledgerEnabled Boolean

A boolean that specifies if this is a ledger database. Defaults to false. Changing this forces a new resource to be created.

licenseType String

Specifies the license type applied to this database. Possible values are LicenseIncluded and BasePrice.

longTermRetentionPolicy Property Map

A long_term_retention_policy block as defined below.

maintenanceConfigurationName String

The name of the Public Maintenance Configuration window to apply to the database. Valid values include SQL_Default, SQL_EastUS_DB_1, SQL_EastUS2_DB_1, SQL_SoutheastAsia_DB_1, SQL_AustraliaEast_DB_1, SQL_NorthEurope_DB_1, SQL_SouthCentralUS_DB_1, SQL_WestUS2_DB_1, SQL_UKSouth_DB_1, SQL_WestEurope_DB_1, SQL_EastUS_DB_2, SQL_EastUS2_DB_2, SQL_WestUS2_DB_2, SQL_SoutheastAsia_DB_2, SQL_AustraliaEast_DB_2, SQL_NorthEurope_DB_2, SQL_SouthCentralUS_DB_2, SQL_UKSouth_DB_2, SQL_WestEurope_DB_2, SQL_AustraliaSoutheast_DB_1, SQL_BrazilSouth_DB_1, SQL_CanadaCentral_DB_1, SQL_CanadaEast_DB_1, SQL_CentralUS_DB_1, SQL_EastAsia_DB_1, SQL_FranceCentral_DB_1, SQL_GermanyWestCentral_DB_1, SQL_CentralIndia_DB_1, SQL_SouthIndia_DB_1, SQL_JapanEast_DB_1, SQL_JapanWest_DB_1, SQL_NorthCentralUS_DB_1, SQL_UKWest_DB_1, SQL_WestUS_DB_1, SQL_AustraliaSoutheast_DB_2, SQL_BrazilSouth_DB_2, SQL_CanadaCentral_DB_2, SQL_CanadaEast_DB_2, SQL_CentralUS_DB_2, SQL_EastAsia_DB_2, SQL_FranceCentral_DB_2, SQL_GermanyWestCentral_DB_2, SQL_CentralIndia_DB_2, SQL_SouthIndia_DB_2, SQL_JapanEast_DB_2, SQL_JapanWest_DB_2, SQL_NorthCentralUS_DB_2, SQL_UKWest_DB_2, SQL_WestUS_DB_2, SQL_WestCentralUS_DB_1, SQL_FranceSouth_DB_1, SQL_WestCentralUS_DB_2, SQL_FranceSouth_DB_2, SQL_SwitzerlandNorth_DB_1, SQL_SwitzerlandNorth_DB_2, SQL_BrazilSoutheast_DB_1, SQL_UAENorth_DB_1, SQL_BrazilSoutheast_DB_2, SQL_UAENorth_DB_2. Defaults to SQL_Default.

maxSizeGb Number

The max size of the database in gigabytes.

minCapacity Number

Minimal capacity that database will always have allocated, if not paused. This property is only settable for General Purpose Serverless databases.

name String

The name of the MS SQL Database. Changing this forces a new resource to be created.

readReplicaCount Number

The number of readonly secondary replicas associated with the database to which readonly application intent connections may be routed. This property is only settable for Hyperscale edition databases.

readScale Boolean

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.

recoverDatabaseId String

The ID of the database to be recovered. This property is only applicable when the create_mode is Recovery.

restoreDroppedDatabaseId String

The ID of the database to be restored. This property is only applicable when the create_mode is Restore.

restorePointInTime String

Specifies the point in time (ISO8601 format) of the source database that will be restored to create the new database. This property is only settable for create_mode= PointInTimeRestore databases.

sampleName String

Specifies the name of the sample schema to apply when creating this database. Possible value is AdventureWorksLT.

shortTermRetentionPolicy Property Map

A short_term_retention_policy block as defined below.

skuName String

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 force a new resource to be created.

storageAccountType String

Specifies the storage account type used to store backups for this database. Possible values are Geo, GeoZone, Local and Zone. The default value is Geo.

tags Map<String>

A mapping of tags to assign to the resource.

threatDetectionPolicy Property Map

Threat detection policy configuration. The threat_detection_policy block supports fields documented below.

transparentDataEncryptionEnabled Boolean

If set to true, Transparent Data Encryption will be enabled on the database. Defaults to true.

zoneRedundant Boolean

Whether or not this database is zone redundant, which means the replicas of this database will be spread across multiple availability zones. This property is only settable for Premium and Business Critical databases.

Outputs

All input properties are implicitly available as output properties. Additionally, the Database resource produces the following output properties:

Id string

The provider-assigned unique ID for this managed resource.

Id string

The provider-assigned unique ID for this managed resource.

id String

The provider-assigned unique ID for this managed resource.

id string

The provider-assigned unique ID for this managed resource.

id str

The provider-assigned unique ID for this managed resource.

id String

The provider-assigned unique ID for this managed resource.

Look up an Existing Database Resource

Get an existing Database resource’s state with the given name, ID, and optional extra properties used to qualify the lookup.

public static get(name: string, id: Input<ID>, state?: DatabaseState, opts?: CustomResourceOptions): Database
@staticmethod
def get(resource_name: str,
        id: str,
        opts: Optional[ResourceOptions] = None,
        auto_pause_delay_in_minutes: Optional[int] = None,
        collation: Optional[str] = None,
        create_mode: Optional[str] = None,
        creation_source_database_id: Optional[str] = None,
        elastic_pool_id: Optional[str] = None,
        geo_backup_enabled: Optional[bool] = None,
        ledger_enabled: Optional[bool] = None,
        license_type: Optional[str] = None,
        long_term_retention_policy: Optional[DatabaseLongTermRetentionPolicyArgs] = None,
        maintenance_configuration_name: Optional[str] = None,
        max_size_gb: Optional[int] = None,
        min_capacity: Optional[float] = None,
        name: Optional[str] = None,
        read_replica_count: Optional[int] = None,
        read_scale: Optional[bool] = None,
        recover_database_id: Optional[str] = None,
        restore_dropped_database_id: Optional[str] = None,
        restore_point_in_time: Optional[str] = None,
        sample_name: Optional[str] = None,
        server_id: Optional[str] = None,
        short_term_retention_policy: Optional[DatabaseShortTermRetentionPolicyArgs] = None,
        sku_name: Optional[str] = None,
        storage_account_type: Optional[str] = None,
        tags: Optional[Mapping[str, str]] = None,
        threat_detection_policy: Optional[DatabaseThreatDetectionPolicyArgs] = None,
        transparent_data_encryption_enabled: Optional[bool] = None,
        zone_redundant: Optional[bool] = None) -> Database
func GetDatabase(ctx *Context, name string, id IDInput, state *DatabaseState, opts ...ResourceOption) (*Database, error)
public static Database Get(string name, Input<string> id, DatabaseState? state, CustomResourceOptions? opts = null)
public static Database get(String name, Output<String> id, DatabaseState state, CustomResourceOptions options)
Resource lookup is not supported in YAML
name
The unique name of the resulting resource.
id
The unique provider ID of the resource to lookup.
state
Any extra arguments used during the lookup.
opts
A bag of options that control this resource's behavior.
resource_name
The unique name of the resulting resource.
id
The unique provider ID of the resource to lookup.
name
The unique name of the resulting resource.
id
The unique provider ID of the resource to lookup.
state
Any extra arguments used during the lookup.
opts
A bag of options that control this resource's behavior.
name
The unique name of the resulting resource.
id
The unique provider ID of the resource to lookup.
state
Any extra arguments used during the lookup.
opts
A bag of options that control this resource's behavior.
name
The unique name of the resulting resource.
id
The unique provider ID of the resource to lookup.
state
Any extra arguments used during the lookup.
opts
A bag of options that control this resource's behavior.
The following state arguments are supported:
AutoPauseDelayInMinutes int

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 General Purpose Serverless databases.

Collation string

Specifies the collation of the database. Changing this forces a new resource to be created.

CreateMode string

The create mode of the database. Possible values are Copy, Default, OnlineSecondary, PointInTimeRestore, Recovery, Restore, RestoreExternalBackup, RestoreExternalBackupSecondary, RestoreLongTermRetentionBackup and Secondary.

CreationSourceDatabaseId string

The ID of the source database from which to create the new database. This should only be used for databases with create_mode values that use another database as reference. Changing this forces a new resource to be created.

ElasticPoolId string

Specifies the ID of the elastic pool containing this database.

GeoBackupEnabled bool

A boolean that specifies if the Geo Backup Policy is enabled.

LedgerEnabled bool

A boolean that specifies if this is a ledger database. Defaults to false. Changing this forces a new resource to be created.

LicenseType string

Specifies the license type applied to this database. Possible values are LicenseIncluded and BasePrice.

LongTermRetentionPolicy DatabaseLongTermRetentionPolicyArgs

A long_term_retention_policy block as defined below.

MaintenanceConfigurationName string

The name of the Public Maintenance Configuration window to apply to the database. Valid values include SQL_Default, SQL_EastUS_DB_1, SQL_EastUS2_DB_1, SQL_SoutheastAsia_DB_1, SQL_AustraliaEast_DB_1, SQL_NorthEurope_DB_1, SQL_SouthCentralUS_DB_1, SQL_WestUS2_DB_1, SQL_UKSouth_DB_1, SQL_WestEurope_DB_1, SQL_EastUS_DB_2, SQL_EastUS2_DB_2, SQL_WestUS2_DB_2, SQL_SoutheastAsia_DB_2, SQL_AustraliaEast_DB_2, SQL_NorthEurope_DB_2, SQL_SouthCentralUS_DB_2, SQL_UKSouth_DB_2, SQL_WestEurope_DB_2, SQL_AustraliaSoutheast_DB_1, SQL_BrazilSouth_DB_1, SQL_CanadaCentral_DB_1, SQL_CanadaEast_DB_1, SQL_CentralUS_DB_1, SQL_EastAsia_DB_1, SQL_FranceCentral_DB_1, SQL_GermanyWestCentral_DB_1, SQL_CentralIndia_DB_1, SQL_SouthIndia_DB_1, SQL_JapanEast_DB_1, SQL_JapanWest_DB_1, SQL_NorthCentralUS_DB_1, SQL_UKWest_DB_1, SQL_WestUS_DB_1, SQL_AustraliaSoutheast_DB_2, SQL_BrazilSouth_DB_2, SQL_CanadaCentral_DB_2, SQL_CanadaEast_DB_2, SQL_CentralUS_DB_2, SQL_EastAsia_DB_2, SQL_FranceCentral_DB_2, SQL_GermanyWestCentral_DB_2, SQL_CentralIndia_DB_2, SQL_SouthIndia_DB_2, SQL_JapanEast_DB_2, SQL_JapanWest_DB_2, SQL_NorthCentralUS_DB_2, SQL_UKWest_DB_2, SQL_WestUS_DB_2, SQL_WestCentralUS_DB_1, SQL_FranceSouth_DB_1, SQL_WestCentralUS_DB_2, SQL_FranceSouth_DB_2, SQL_SwitzerlandNorth_DB_1, SQL_SwitzerlandNorth_DB_2, SQL_BrazilSoutheast_DB_1, SQL_UAENorth_DB_1, SQL_BrazilSoutheast_DB_2, SQL_UAENorth_DB_2. Defaults to SQL_Default.

MaxSizeGb int

The max size of the database in gigabytes.

MinCapacity double

Minimal capacity that database will always have allocated, if not paused. This property is only settable for General Purpose Serverless databases.

Name string

The name of the MS SQL Database. Changing this forces a new resource to be created.

ReadReplicaCount int

The number of readonly secondary replicas associated with the database to which readonly application intent connections may be routed. This property is only settable for Hyperscale edition databases.

ReadScale bool

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.

RecoverDatabaseId string

The ID of the database to be recovered. This property is only applicable when the create_mode is Recovery.

RestoreDroppedDatabaseId string

The ID of the database to be restored. This property is only applicable when the create_mode is Restore.

RestorePointInTime string

Specifies the point in time (ISO8601 format) of the source database that will be restored to create the new database. This property is only settable for create_mode= PointInTimeRestore databases.

SampleName string

Specifies the name of the sample schema to apply when creating this database. Possible value is AdventureWorksLT.

ServerId string

The id of the MS SQL Server on which to create the database. Changing this forces a new resource to be created.

ShortTermRetentionPolicy DatabaseShortTermRetentionPolicyArgs

A short_term_retention_policy block as defined below.

SkuName string

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 force a new resource to be created.

StorageAccountType string

Specifies the storage account type used to store backups for this database. Possible values are Geo, GeoZone, Local and Zone. The default value is Geo.

Tags Dictionary<string, string>

A mapping of tags to assign to the resource.

ThreatDetectionPolicy DatabaseThreatDetectionPolicyArgs

Threat detection policy configuration. The threat_detection_policy block supports fields documented below.

TransparentDataEncryptionEnabled bool

If set to true, Transparent Data Encryption will be enabled on the database. Defaults to true.

ZoneRedundant bool

Whether or not this database is zone redundant, which means the replicas of this database will be spread across multiple availability zones. This property is only settable for Premium and Business Critical databases.

AutoPauseDelayInMinutes int

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 General Purpose Serverless databases.

Collation string

Specifies the collation of the database. Changing this forces a new resource to be created.

CreateMode string

The create mode of the database. Possible values are Copy, Default, OnlineSecondary, PointInTimeRestore, Recovery, Restore, RestoreExternalBackup, RestoreExternalBackupSecondary, RestoreLongTermRetentionBackup and Secondary.

CreationSourceDatabaseId string

The ID of the source database from which to create the new database. This should only be used for databases with create_mode values that use another database as reference. Changing this forces a new resource to be created.

ElasticPoolId string

Specifies the ID of the elastic pool containing this database.

GeoBackupEnabled bool

A boolean that specifies if the Geo Backup Policy is enabled.

LedgerEnabled bool

A boolean that specifies if this is a ledger database. Defaults to false. Changing this forces a new resource to be created.

LicenseType string

Specifies the license type applied to this database. Possible values are LicenseIncluded and BasePrice.

LongTermRetentionPolicy DatabaseLongTermRetentionPolicyArgs

A long_term_retention_policy block as defined below.

MaintenanceConfigurationName string

The name of the Public Maintenance Configuration window to apply to the database. Valid values include SQL_Default, SQL_EastUS_DB_1, SQL_EastUS2_DB_1, SQL_SoutheastAsia_DB_1, SQL_AustraliaEast_DB_1, SQL_NorthEurope_DB_1, SQL_SouthCentralUS_DB_1, SQL_WestUS2_DB_1, SQL_UKSouth_DB_1, SQL_WestEurope_DB_1, SQL_EastUS_DB_2, SQL_EastUS2_DB_2, SQL_WestUS2_DB_2, SQL_SoutheastAsia_DB_2, SQL_AustraliaEast_DB_2, SQL_NorthEurope_DB_2, SQL_SouthCentralUS_DB_2, SQL_UKSouth_DB_2, SQL_WestEurope_DB_2, SQL_AustraliaSoutheast_DB_1, SQL_BrazilSouth_DB_1, SQL_CanadaCentral_DB_1, SQL_CanadaEast_DB_1, SQL_CentralUS_DB_1, SQL_EastAsia_DB_1, SQL_FranceCentral_DB_1, SQL_GermanyWestCentral_DB_1, SQL_CentralIndia_DB_1, SQL_SouthIndia_DB_1, SQL_JapanEast_DB_1, SQL_JapanWest_DB_1, SQL_NorthCentralUS_DB_1, SQL_UKWest_DB_1, SQL_WestUS_DB_1, SQL_AustraliaSoutheast_DB_2, SQL_BrazilSouth_DB_2, SQL_CanadaCentral_DB_2, SQL_CanadaEast_DB_2, SQL_CentralUS_DB_2, SQL_EastAsia_DB_2, SQL_FranceCentral_DB_2, SQL_GermanyWestCentral_DB_2, SQL_CentralIndia_DB_2, SQL_SouthIndia_DB_2, SQL_JapanEast_DB_2, SQL_JapanWest_DB_2, SQL_NorthCentralUS_DB_2, SQL_UKWest_DB_2, SQL_WestUS_DB_2, SQL_WestCentralUS_DB_1, SQL_FranceSouth_DB_1, SQL_WestCentralUS_DB_2, SQL_FranceSouth_DB_2, SQL_SwitzerlandNorth_DB_1, SQL_SwitzerlandNorth_DB_2, SQL_BrazilSoutheast_DB_1, SQL_UAENorth_DB_1, SQL_BrazilSoutheast_DB_2, SQL_UAENorth_DB_2. Defaults to SQL_Default.

MaxSizeGb int

The max size of the database in gigabytes.

MinCapacity float64

Minimal capacity that database will always have allocated, if not paused. This property is only settable for General Purpose Serverless databases.

Name string

The name of the MS SQL Database. Changing this forces a new resource to be created.

ReadReplicaCount int

The number of readonly secondary replicas associated with the database to which readonly application intent connections may be routed. This property is only settable for Hyperscale edition databases.

ReadScale bool

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.

RecoverDatabaseId string

The ID of the database to be recovered. This property is only applicable when the create_mode is Recovery.

RestoreDroppedDatabaseId string

The ID of the database to be restored. This property is only applicable when the create_mode is Restore.

RestorePointInTime string

Specifies the point in time (ISO8601 format) of the source database that will be restored to create the new database. This property is only settable for create_mode= PointInTimeRestore databases.

SampleName string

Specifies the name of the sample schema to apply when creating this database. Possible value is AdventureWorksLT.

ServerId string

The id of the MS SQL Server on which to create the database. Changing this forces a new resource to be created.

ShortTermRetentionPolicy DatabaseShortTermRetentionPolicyArgs

A short_term_retention_policy block as defined below.

SkuName string

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 force a new resource to be created.

StorageAccountType string

Specifies the storage account type used to store backups for this database. Possible values are Geo, GeoZone, Local and Zone. The default value is Geo.

Tags map[string]string

A mapping of tags to assign to the resource.

ThreatDetectionPolicy DatabaseThreatDetectionPolicyArgs

Threat detection policy configuration. The threat_detection_policy block supports fields documented below.

TransparentDataEncryptionEnabled bool

If set to true, Transparent Data Encryption will be enabled on the database. Defaults to true.

ZoneRedundant bool

Whether or not this database is zone redundant, which means the replicas of this database will be spread across multiple availability zones. This property is only settable for Premium and Business Critical databases.

autoPauseDelayInMinutes Integer

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 General Purpose Serverless databases.

collation String

Specifies the collation of the database. Changing this forces a new resource to be created.

createMode String

The create mode of the database. Possible values are Copy, Default, OnlineSecondary, PointInTimeRestore, Recovery, Restore, RestoreExternalBackup, RestoreExternalBackupSecondary, RestoreLongTermRetentionBackup and Secondary.

creationSourceDatabaseId String

The ID of the source database from which to create the new database. This should only be used for databases with create_mode values that use another database as reference. Changing this forces a new resource to be created.

elasticPoolId String

Specifies the ID of the elastic pool containing this database.

geoBackupEnabled Boolean

A boolean that specifies if the Geo Backup Policy is enabled.

ledgerEnabled Boolean

A boolean that specifies if this is a ledger database. Defaults to false. Changing this forces a new resource to be created.

licenseType String

Specifies the license type applied to this database. Possible values are LicenseIncluded and BasePrice.

longTermRetentionPolicy DatabaseLongTermRetentionPolicyArgs

A long_term_retention_policy block as defined below.

maintenanceConfigurationName String

The name of the Public Maintenance Configuration window to apply to the database. Valid values include SQL_Default, SQL_EastUS_DB_1, SQL_EastUS2_DB_1, SQL_SoutheastAsia_DB_1, SQL_AustraliaEast_DB_1, SQL_NorthEurope_DB_1, SQL_SouthCentralUS_DB_1, SQL_WestUS2_DB_1, SQL_UKSouth_DB_1, SQL_WestEurope_DB_1, SQL_EastUS_DB_2, SQL_EastUS2_DB_2, SQL_WestUS2_DB_2, SQL_SoutheastAsia_DB_2, SQL_AustraliaEast_DB_2, SQL_NorthEurope_DB_2, SQL_SouthCentralUS_DB_2, SQL_UKSouth_DB_2, SQL_WestEurope_DB_2, SQL_AustraliaSoutheast_DB_1, SQL_BrazilSouth_DB_1, SQL_CanadaCentral_DB_1, SQL_CanadaEast_DB_1, SQL_CentralUS_DB_1, SQL_EastAsia_DB_1, SQL_FranceCentral_DB_1, SQL_GermanyWestCentral_DB_1, SQL_CentralIndia_DB_1, SQL_SouthIndia_DB_1, SQL_JapanEast_DB_1, SQL_JapanWest_DB_1, SQL_NorthCentralUS_DB_1, SQL_UKWest_DB_1, SQL_WestUS_DB_1, SQL_AustraliaSoutheast_DB_2, SQL_BrazilSouth_DB_2, SQL_CanadaCentral_DB_2, SQL_CanadaEast_DB_2, SQL_CentralUS_DB_2, SQL_EastAsia_DB_2, SQL_FranceCentral_DB_2, SQL_GermanyWestCentral_DB_2, SQL_CentralIndia_DB_2, SQL_SouthIndia_DB_2, SQL_JapanEast_DB_2, SQL_JapanWest_DB_2, SQL_NorthCentralUS_DB_2, SQL_UKWest_DB_2, SQL_WestUS_DB_2, SQL_WestCentralUS_DB_1, SQL_FranceSouth_DB_1, SQL_WestCentralUS_DB_2, SQL_FranceSouth_DB_2, SQL_SwitzerlandNorth_DB_1, SQL_SwitzerlandNorth_DB_2, SQL_BrazilSoutheast_DB_1, SQL_UAENorth_DB_1, SQL_BrazilSoutheast_DB_2, SQL_UAENorth_DB_2. Defaults to SQL_Default.

maxSizeGb Integer

The max size of the database in gigabytes.

minCapacity Double

Minimal capacity that database will always have allocated, if not paused. This property is only settable for General Purpose Serverless databases.

name String

The name of the MS SQL Database. Changing this forces a new resource to be created.

readReplicaCount Integer

The number of readonly secondary replicas associated with the database to which readonly application intent connections may be routed. This property is only settable for Hyperscale edition databases.

readScale Boolean

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.

recoverDatabaseId String

The ID of the database to be recovered. This property is only applicable when the create_mode is Recovery.

restoreDroppedDatabaseId String

The ID of the database to be restored. This property is only applicable when the create_mode is Restore.

restorePointInTime String

Specifies the point in time (ISO8601 format) of the source database that will be restored to create the new database. This property is only settable for create_mode= PointInTimeRestore databases.

sampleName String

Specifies the name of the sample schema to apply when creating this database. Possible value is AdventureWorksLT.

serverId String

The id of the MS SQL Server on which to create the database. Changing this forces a new resource to be created.

shortTermRetentionPolicy DatabaseShortTermRetentionPolicyArgs

A short_term_retention_policy block as defined below.

skuName String

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 force a new resource to be created.

storageAccountType String

Specifies the storage account type used to store backups for this database. Possible values are Geo, GeoZone, Local and Zone. The default value is Geo.

tags Map<String,String>

A mapping of tags to assign to the resource.

threatDetectionPolicy DatabaseThreatDetectionPolicyArgs

Threat detection policy configuration. The threat_detection_policy block supports fields documented below.

transparentDataEncryptionEnabled Boolean

If set to true, Transparent Data Encryption will be enabled on the database. Defaults to true.

zoneRedundant Boolean

Whether or not this database is zone redundant, which means the replicas of this database will be spread across multiple availability zones. This property is only settable for Premium and Business Critical databases.

autoPauseDelayInMinutes number

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 General Purpose Serverless databases.

collation string

Specifies the collation of the database. Changing this forces a new resource to be created.

createMode string

The create mode of the database. Possible values are Copy, Default, OnlineSecondary, PointInTimeRestore, Recovery, Restore, RestoreExternalBackup, RestoreExternalBackupSecondary, RestoreLongTermRetentionBackup and Secondary.

creationSourceDatabaseId string

The ID of the source database from which to create the new database. This should only be used for databases with create_mode values that use another database as reference. Changing this forces a new resource to be created.

elasticPoolId string

Specifies the ID of the elastic pool containing this database.

geoBackupEnabled boolean

A boolean that specifies if the Geo Backup Policy is enabled.

ledgerEnabled boolean

A boolean that specifies if this is a ledger database. Defaults to false. Changing this forces a new resource to be created.

licenseType string

Specifies the license type applied to this database. Possible values are LicenseIncluded and BasePrice.

longTermRetentionPolicy DatabaseLongTermRetentionPolicyArgs

A long_term_retention_policy block as defined below.

maintenanceConfigurationName string

The name of the Public Maintenance Configuration window to apply to the database. Valid values include SQL_Default, SQL_EastUS_DB_1, SQL_EastUS2_DB_1, SQL_SoutheastAsia_DB_1, SQL_AustraliaEast_DB_1, SQL_NorthEurope_DB_1, SQL_SouthCentralUS_DB_1, SQL_WestUS2_DB_1, SQL_UKSouth_DB_1, SQL_WestEurope_DB_1, SQL_EastUS_DB_2, SQL_EastUS2_DB_2, SQL_WestUS2_DB_2, SQL_SoutheastAsia_DB_2, SQL_AustraliaEast_DB_2, SQL_NorthEurope_DB_2, SQL_SouthCentralUS_DB_2, SQL_UKSouth_DB_2, SQL_WestEurope_DB_2, SQL_AustraliaSoutheast_DB_1, SQL_BrazilSouth_DB_1, SQL_CanadaCentral_DB_1, SQL_CanadaEast_DB_1, SQL_CentralUS_DB_1, SQL_EastAsia_DB_1, SQL_FranceCentral_DB_1, SQL_GermanyWestCentral_DB_1, SQL_CentralIndia_DB_1, SQL_SouthIndia_DB_1, SQL_JapanEast_DB_1, SQL_JapanWest_DB_1, SQL_NorthCentralUS_DB_1, SQL_UKWest_DB_1, SQL_WestUS_DB_1, SQL_AustraliaSoutheast_DB_2, SQL_BrazilSouth_DB_2, SQL_CanadaCentral_DB_2, SQL_CanadaEast_DB_2, SQL_CentralUS_DB_2, SQL_EastAsia_DB_2, SQL_FranceCentral_DB_2, SQL_GermanyWestCentral_DB_2, SQL_CentralIndia_DB_2, SQL_SouthIndia_DB_2, SQL_JapanEast_DB_2, SQL_JapanWest_DB_2, SQL_NorthCentralUS_DB_2, SQL_UKWest_DB_2, SQL_WestUS_DB_2, SQL_WestCentralUS_DB_1, SQL_FranceSouth_DB_1, SQL_WestCentralUS_DB_2, SQL_FranceSouth_DB_2, SQL_SwitzerlandNorth_DB_1, SQL_SwitzerlandNorth_DB_2, SQL_BrazilSoutheast_DB_1, SQL_UAENorth_DB_1, SQL_BrazilSoutheast_DB_2, SQL_UAENorth_DB_2. Defaults to SQL_Default.

maxSizeGb number

The max size of the database in gigabytes.

minCapacity number

Minimal capacity that database will always have allocated, if not paused. This property is only settable for General Purpose Serverless databases.

name string

The name of the MS SQL Database. Changing this forces a new resource to be created.

readReplicaCount number

The number of readonly secondary replicas associated with the database to which readonly application intent connections may be routed. This property is only settable for Hyperscale edition databases.

readScale boolean

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.

recoverDatabaseId string

The ID of the database to be recovered. This property is only applicable when the create_mode is Recovery.

restoreDroppedDatabaseId string

The ID of the database to be restored. This property is only applicable when the create_mode is Restore.

restorePointInTime string

Specifies the point in time (ISO8601 format) of the source database that will be restored to create the new database. This property is only settable for create_mode= PointInTimeRestore databases.

sampleName string

Specifies the name of the sample schema to apply when creating this database. Possible value is AdventureWorksLT.

serverId string

The id of the MS SQL Server on which to create the database. Changing this forces a new resource to be created.

shortTermRetentionPolicy DatabaseShortTermRetentionPolicyArgs

A short_term_retention_policy block as defined below.

skuName string

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 force a new resource to be created.

storageAccountType string

Specifies the storage account type used to store backups for this database. Possible values are Geo, GeoZone, Local and Zone. The default value is Geo.

tags {[key: string]: string}

A mapping of tags to assign to the resource.

threatDetectionPolicy DatabaseThreatDetectionPolicyArgs

Threat detection policy configuration. The threat_detection_policy block supports fields documented below.

transparentDataEncryptionEnabled boolean

If set to true, Transparent Data Encryption will be enabled on the database. Defaults to true.

zoneRedundant boolean

Whether or not this database is zone redundant, which means the replicas of this database will be spread across multiple availability zones. This property is only settable for Premium and Business Critical databases.

auto_pause_delay_in_minutes int

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 General Purpose Serverless databases.

collation str

Specifies the collation of the database. Changing this forces a new resource to be created.

create_mode str

The create mode of the database. Possible values are Copy, Default, OnlineSecondary, PointInTimeRestore, Recovery, Restore, RestoreExternalBackup, RestoreExternalBackupSecondary, RestoreLongTermRetentionBackup and Secondary.

creation_source_database_id str

The ID of the source database from which to create the new database. This should only be used for databases with create_mode values that use another database as reference. Changing this forces a new resource to be created.

elastic_pool_id str

Specifies the ID of the elastic pool containing this database.

geo_backup_enabled bool

A boolean that specifies if the Geo Backup Policy is enabled.

ledger_enabled bool

A boolean that specifies if this is a ledger database. Defaults to false. Changing this forces a new resource to be created.

license_type str

Specifies the license type applied to this database. Possible values are LicenseIncluded and BasePrice.

long_term_retention_policy DatabaseLongTermRetentionPolicyArgs

A long_term_retention_policy block as defined below.

maintenance_configuration_name str

The name of the Public Maintenance Configuration window to apply to the database. Valid values include SQL_Default, SQL_EastUS_DB_1, SQL_EastUS2_DB_1, SQL_SoutheastAsia_DB_1, SQL_AustraliaEast_DB_1, SQL_NorthEurope_DB_1, SQL_SouthCentralUS_DB_1, SQL_WestUS2_DB_1, SQL_UKSouth_DB_1, SQL_WestEurope_DB_1, SQL_EastUS_DB_2, SQL_EastUS2_DB_2, SQL_WestUS2_DB_2, SQL_SoutheastAsia_DB_2, SQL_AustraliaEast_DB_2, SQL_NorthEurope_DB_2, SQL_SouthCentralUS_DB_2, SQL_UKSouth_DB_2, SQL_WestEurope_DB_2, SQL_AustraliaSoutheast_DB_1, SQL_BrazilSouth_DB_1, SQL_CanadaCentral_DB_1, SQL_CanadaEast_DB_1, SQL_CentralUS_DB_1, SQL_EastAsia_DB_1, SQL_FranceCentral_DB_1, SQL_GermanyWestCentral_DB_1, SQL_CentralIndia_DB_1, SQL_SouthIndia_DB_1, SQL_JapanEast_DB_1, SQL_JapanWest_DB_1, SQL_NorthCentralUS_DB_1, SQL_UKWest_DB_1, SQL_WestUS_DB_1, SQL_AustraliaSoutheast_DB_2, SQL_BrazilSouth_DB_2, SQL_CanadaCentral_DB_2, SQL_CanadaEast_DB_2, SQL_CentralUS_DB_2, SQL_EastAsia_DB_2, SQL_FranceCentral_DB_2, SQL_GermanyWestCentral_DB_2, SQL_CentralIndia_DB_2, SQL_SouthIndia_DB_2, SQL_JapanEast_DB_2, SQL_JapanWest_DB_2, SQL_NorthCentralUS_DB_2, SQL_UKWest_DB_2, SQL_WestUS_DB_2, SQL_WestCentralUS_DB_1, SQL_FranceSouth_DB_1, SQL_WestCentralUS_DB_2, SQL_FranceSouth_DB_2, SQL_SwitzerlandNorth_DB_1, SQL_SwitzerlandNorth_DB_2, SQL_BrazilSoutheast_DB_1, SQL_UAENorth_DB_1, SQL_BrazilSoutheast_DB_2, SQL_UAENorth_DB_2. Defaults to SQL_Default.

max_size_gb int

The max size of the database in gigabytes.

min_capacity float

Minimal capacity that database will always have allocated, if not paused. This property is only settable for General Purpose Serverless databases.

name str

The name of the MS SQL Database. Changing this forces a new resource to be created.

read_replica_count int

The number of readonly secondary replicas associated with the database to which readonly application intent connections may be routed. This property is only settable for Hyperscale edition databases.

read_scale bool

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.

recover_database_id str

The ID of the database to be recovered. This property is only applicable when the create_mode is Recovery.

restore_dropped_database_id str

The ID of the database to be restored. This property is only applicable when the create_mode is Restore.

restore_point_in_time str

Specifies the point in time (ISO8601 format) of the source database that will be restored to create the new database. This property is only settable for create_mode= PointInTimeRestore databases.

sample_name str

Specifies the name of the sample schema to apply when creating this database. Possible value is AdventureWorksLT.

server_id str

The id of the MS SQL Server on which to create the database. Changing this forces a new resource to be created.

short_term_retention_policy DatabaseShortTermRetentionPolicyArgs

A short_term_retention_policy block as defined below.

sku_name str

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 force a new resource to be created.

storage_account_type str

Specifies the storage account type used to store backups for this database. Possible values are Geo, GeoZone, Local and Zone. The default value is Geo.

tags Mapping[str, str]

A mapping of tags to assign to the resource.

threat_detection_policy DatabaseThreatDetectionPolicyArgs

Threat detection policy configuration. The threat_detection_policy block supports fields documented below.

transparent_data_encryption_enabled bool

If set to true, Transparent Data Encryption will be enabled on the database. Defaults to true.

zone_redundant bool

Whether or not this database is zone redundant, which means the replicas of this database will be spread across multiple availability zones. This property is only settable for Premium and Business Critical databases.

autoPauseDelayInMinutes Number

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 General Purpose Serverless databases.

collation String

Specifies the collation of the database. Changing this forces a new resource to be created.

createMode String

The create mode of the database. Possible values are Copy, Default, OnlineSecondary, PointInTimeRestore, Recovery, Restore, RestoreExternalBackup, RestoreExternalBackupSecondary, RestoreLongTermRetentionBackup and Secondary.

creationSourceDatabaseId String

The ID of the source database from which to create the new database. This should only be used for databases with create_mode values that use another database as reference. Changing this forces a new resource to be created.

elasticPoolId String

Specifies the ID of the elastic pool containing this database.

geoBackupEnabled Boolean

A boolean that specifies if the Geo Backup Policy is enabled.

ledgerEnabled Boolean

A boolean that specifies if this is a ledger database. Defaults to false. Changing this forces a new resource to be created.

licenseType String

Specifies the license type applied to this database. Possible values are LicenseIncluded and BasePrice.

longTermRetentionPolicy Property Map

A long_term_retention_policy block as defined below.

maintenanceConfigurationName String

The name of the Public Maintenance Configuration window to apply to the database. Valid values include SQL_Default, SQL_EastUS_DB_1, SQL_EastUS2_DB_1, SQL_SoutheastAsia_DB_1, SQL_AustraliaEast_DB_1, SQL_NorthEurope_DB_1, SQL_SouthCentralUS_DB_1, SQL_WestUS2_DB_1, SQL_UKSouth_DB_1, SQL_WestEurope_DB_1, SQL_EastUS_DB_2, SQL_EastUS2_DB_2, SQL_WestUS2_DB_2, SQL_SoutheastAsia_DB_2, SQL_AustraliaEast_DB_2, SQL_NorthEurope_DB_2, SQL_SouthCentralUS_DB_2, SQL_UKSouth_DB_2, SQL_WestEurope_DB_2, SQL_AustraliaSoutheast_DB_1, SQL_BrazilSouth_DB_1, SQL_CanadaCentral_DB_1, SQL_CanadaEast_DB_1, SQL_CentralUS_DB_1, SQL_EastAsia_DB_1, SQL_FranceCentral_DB_1, SQL_GermanyWestCentral_DB_1, SQL_CentralIndia_DB_1, SQL_SouthIndia_DB_1, SQL_JapanEast_DB_1, SQL_JapanWest_DB_1, SQL_NorthCentralUS_DB_1, SQL_UKWest_DB_1, SQL_WestUS_DB_1, SQL_AustraliaSoutheast_DB_2, SQL_BrazilSouth_DB_2, SQL_CanadaCentral_DB_2, SQL_CanadaEast_DB_2, SQL_CentralUS_DB_2, SQL_EastAsia_DB_2, SQL_FranceCentral_DB_2, SQL_GermanyWestCentral_DB_2, SQL_CentralIndia_DB_2, SQL_SouthIndia_DB_2, SQL_JapanEast_DB_2, SQL_JapanWest_DB_2, SQL_NorthCentralUS_DB_2, SQL_UKWest_DB_2, SQL_WestUS_DB_2, SQL_WestCentralUS_DB_1, SQL_FranceSouth_DB_1, SQL_WestCentralUS_DB_2, SQL_FranceSouth_DB_2, SQL_SwitzerlandNorth_DB_1, SQL_SwitzerlandNorth_DB_2, SQL_BrazilSoutheast_DB_1, SQL_UAENorth_DB_1, SQL_BrazilSoutheast_DB_2, SQL_UAENorth_DB_2. Defaults to SQL_Default.

maxSizeGb Number

The max size of the database in gigabytes.

minCapacity Number

Minimal capacity that database will always have allocated, if not paused. This property is only settable for General Purpose Serverless databases.

name String

The name of the MS SQL Database. Changing this forces a new resource to be created.

readReplicaCount Number

The number of readonly secondary replicas associated with the database to which readonly application intent connections may be routed. This property is only settable for Hyperscale edition databases.

readScale Boolean

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.

recoverDatabaseId String

The ID of the database to be recovered. This property is only applicable when the create_mode is Recovery.

restoreDroppedDatabaseId String

The ID of the database to be restored. This property is only applicable when the create_mode is Restore.

restorePointInTime String

Specifies the point in time (ISO8601 format) of the source database that will be restored to create the new database. This property is only settable for create_mode= PointInTimeRestore databases.

sampleName String

Specifies the name of the sample schema to apply when creating this database. Possible value is AdventureWorksLT.

serverId String

The id of the MS SQL Server on which to create the database. Changing this forces a new resource to be created.

shortTermRetentionPolicy Property Map

A short_term_retention_policy block as defined below.

skuName String

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 force a new resource to be created.

storageAccountType String

Specifies the storage account type used to store backups for this database. Possible values are Geo, GeoZone, Local and Zone. The default value is Geo.

tags Map<String>

A mapping of tags to assign to the resource.

threatDetectionPolicy Property Map

Threat detection policy configuration. The threat_detection_policy block supports fields documented below.

transparentDataEncryptionEnabled Boolean

If set to true, Transparent Data Encryption will be enabled on the database. Defaults to true.

zoneRedundant Boolean

Whether or not this database is zone redundant, which means the replicas of this database will be spread across multiple availability zones. This property is only settable for Premium and Business Critical databases.

Supporting Types

DatabaseLongTermRetentionPolicy

MonthlyRetention string

The monthly retention policy for an LTR backup in an ISO 8601 format. Valid value is between 1 to 120 months. e.g. P1Y, P1M, P4W or P30D.

WeekOfYear int

The week of year to take the yearly backup. Value has to be between 1 and 52.

WeeklyRetention string

The weekly retention policy for an LTR backup in an ISO 8601 format. Valid value is between 1 to 520 weeks. e.g. P1Y, P1M, P1W or P7D.

YearlyRetention string

The yearly retention policy for an LTR backup in an ISO 8601 format. Valid value is between 1 to 10 years. e.g. P1Y, P12M, P52W or P365D.

MonthlyRetention string

The monthly retention policy for an LTR backup in an ISO 8601 format. Valid value is between 1 to 120 months. e.g. P1Y, P1M, P4W or P30D.

WeekOfYear int

The week of year to take the yearly backup. Value has to be between 1 and 52.

WeeklyRetention string

The weekly retention policy for an LTR backup in an ISO 8601 format. Valid value is between 1 to 520 weeks. e.g. P1Y, P1M, P1W or P7D.

YearlyRetention string

The yearly retention policy for an LTR backup in an ISO 8601 format. Valid value is between 1 to 10 years. e.g. P1Y, P12M, P52W or P365D.

monthlyRetention String

The monthly retention policy for an LTR backup in an ISO 8601 format. Valid value is between 1 to 120 months. e.g. P1Y, P1M, P4W or P30D.

weekOfYear Integer

The week of year to take the yearly backup. Value has to be between 1 and 52.

weeklyRetention String

The weekly retention policy for an LTR backup in an ISO 8601 format. Valid value is between 1 to 520 weeks. e.g. P1Y, P1M, P1W or P7D.

yearlyRetention String

The yearly retention policy for an LTR backup in an ISO 8601 format. Valid value is between 1 to 10 years. e.g. P1Y, P12M, P52W or P365D.

monthlyRetention string

The monthly retention policy for an LTR backup in an ISO 8601 format. Valid value is between 1 to 120 months. e.g. P1Y, P1M, P4W or P30D.

weekOfYear number

The week of year to take the yearly backup. Value has to be between 1 and 52.

weeklyRetention string

The weekly retention policy for an LTR backup in an ISO 8601 format. Valid value is between 1 to 520 weeks. e.g. P1Y, P1M, P1W or P7D.

yearlyRetention string

The yearly retention policy for an LTR backup in an ISO 8601 format. Valid value is between 1 to 10 years. e.g. P1Y, P12M, P52W or P365D.

monthly_retention str

The monthly retention policy for an LTR backup in an ISO 8601 format. Valid value is between 1 to 120 months. e.g. P1Y, P1M, P4W or P30D.

week_of_year int

The week of year to take the yearly backup. Value has to be between 1 and 52.

weekly_retention str

The weekly retention policy for an LTR backup in an ISO 8601 format. Valid value is between 1 to 520 weeks. e.g. P1Y, P1M, P1W or P7D.

yearly_retention str

The yearly retention policy for an LTR backup in an ISO 8601 format. Valid value is between 1 to 10 years. e.g. P1Y, P12M, P52W or P365D.

monthlyRetention String

The monthly retention policy for an LTR backup in an ISO 8601 format. Valid value is between 1 to 120 months. e.g. P1Y, P1M, P4W or P30D.

weekOfYear Number

The week of year to take the yearly backup. Value has to be between 1 and 52.

weeklyRetention String

The weekly retention policy for an LTR backup in an ISO 8601 format. Valid value is between 1 to 520 weeks. e.g. P1Y, P1M, P1W or P7D.

yearlyRetention String

The yearly retention policy for an LTR backup in an ISO 8601 format. Valid value is between 1 to 10 years. e.g. P1Y, P12M, P52W or P365D.

DatabaseShortTermRetentionPolicy

RetentionDays int

Point In Time Restore configuration. Value has to be between 7 and 35.

BackupIntervalInHours int

The hours between each differential backup. This is only applicable to live databases but not dropped databases. Value has to be 12 or 24. Defaults to 12 hours.

RetentionDays int

Point In Time Restore configuration. Value has to be between 7 and 35.

BackupIntervalInHours int

The hours between each differential backup. This is only applicable to live databases but not dropped databases. Value has to be 12 or 24. Defaults to 12 hours.

retentionDays Integer

Point In Time Restore configuration. Value has to be between 7 and 35.

backupIntervalInHours Integer

The hours between each differential backup. This is only applicable to live databases but not dropped databases. Value has to be 12 or 24. Defaults to 12 hours.

retentionDays number

Point In Time Restore configuration. Value has to be between 7 and 35.

backupIntervalInHours number

The hours between each differential backup. This is only applicable to live databases but not dropped databases. Value has to be 12 or 24. Defaults to 12 hours.

retention_days int

Point In Time Restore configuration. Value has to be between 7 and 35.

backup_interval_in_hours int

The hours between each differential backup. This is only applicable to live databases but not dropped databases. Value has to be 12 or 24. Defaults to 12 hours.

retentionDays Number

Point In Time Restore configuration. Value has to be between 7 and 35.

backupIntervalInHours Number

The hours between each differential backup. This is only applicable to live databases but not dropped databases. Value has to be 12 or 24. Defaults to 12 hours.

DatabaseThreatDetectionPolicy

DisabledAlerts List<string>

Specifies a list of alerts which should be disabled. Possible values include Access_Anomaly, Sql_Injection and Sql_Injection_Vulnerability.

EmailAccountAdmins string

Should the account administrators be emailed when this alert is triggered?

EmailAddresses List<string>

A list of email addresses which alerts should be sent to.

RetentionDays int

Specifies the number of days to keep in the Threat Detection audit logs.

State string

The State of the Policy. Possible values are Enabled, Disabled or New.

StorageAccountAccessKey string

Specifies the identifier key of the Threat Detection audit storage account. Required if state is Enabled.

StorageEndpoint string

Specifies the blob storage endpoint (e.g. https://example.blob.core.windows.net). This blob storage will hold all Threat Detection audit logs. Required if state is Enabled.

DisabledAlerts []string

Specifies a list of alerts which should be disabled. Possible values include Access_Anomaly, Sql_Injection and Sql_Injection_Vulnerability.

EmailAccountAdmins string

Should the account administrators be emailed when this alert is triggered?

EmailAddresses []string

A list of email addresses which alerts should be sent to.

RetentionDays int

Specifies the number of days to keep in the Threat Detection audit logs.

State string

The State of the Policy. Possible values are Enabled, Disabled or New.

StorageAccountAccessKey string

Specifies the identifier key of the Threat Detection audit storage account. Required if state is Enabled.

StorageEndpoint string

Specifies the blob storage endpoint (e.g. https://example.blob.core.windows.net). This blob storage will hold all Threat Detection audit logs. Required if state is Enabled.

disabledAlerts List<String>

Specifies a list of alerts which should be disabled. Possible values include Access_Anomaly, Sql_Injection and Sql_Injection_Vulnerability.

emailAccountAdmins String

Should the account administrators be emailed when this alert is triggered?

emailAddresses List<String>

A list of email addresses which alerts should be sent to.

retentionDays Integer

Specifies the number of days to keep in the Threat Detection audit logs.

state String

The State of the Policy. Possible values are Enabled, Disabled or New.

storageAccountAccessKey String

Specifies the identifier key of the Threat Detection audit storage account. Required if state is Enabled.

storageEndpoint String

Specifies the blob storage endpoint (e.g. https://example.blob.core.windows.net). This blob storage will hold all Threat Detection audit logs. Required if state is Enabled.

disabledAlerts string[]

Specifies a list of alerts which should be disabled. Possible values include Access_Anomaly, Sql_Injection and Sql_Injection_Vulnerability.

emailAccountAdmins string

Should the account administrators be emailed when this alert is triggered?

emailAddresses string[]

A list of email addresses which alerts should be sent to.

retentionDays number

Specifies the number of days to keep in the Threat Detection audit logs.

state string

The State of the Policy. Possible values are Enabled, Disabled or New.

storageAccountAccessKey string

Specifies the identifier key of the Threat Detection audit storage account. Required if state is Enabled.

storageEndpoint string

Specifies the blob storage endpoint (e.g. https://example.blob.core.windows.net). This blob storage will hold all Threat Detection audit logs. Required if state is Enabled.

disabled_alerts Sequence[str]

Specifies a list of alerts which should be disabled. Possible values include Access_Anomaly, Sql_Injection and Sql_Injection_Vulnerability.

email_account_admins str

Should the account administrators be emailed when this alert is triggered?

email_addresses Sequence[str]

A list of email addresses which alerts should be sent to.

retention_days int

Specifies the number of days to keep in the Threat Detection audit logs.

state str

The State of the Policy. Possible values are Enabled, Disabled or New.

storage_account_access_key str

Specifies the identifier key of the Threat Detection audit storage account. Required if state is Enabled.

storage_endpoint str

Specifies the blob storage endpoint (e.g. https://example.blob.core.windows.net). This blob storage will hold all Threat Detection audit logs. Required if state is Enabled.

disabledAlerts List<String>

Specifies a list of alerts which should be disabled. Possible values include Access_Anomaly, Sql_Injection and Sql_Injection_Vulnerability.

emailAccountAdmins String

Should the account administrators be emailed when this alert is triggered?

emailAddresses List<String>

A list of email addresses which alerts should be sent to.

retentionDays Number

Specifies the number of days to keep in the Threat Detection audit logs.

state String

The State of the Policy. Possible values are Enabled, Disabled or New.

storageAccountAccessKey String

Specifies the identifier key of the Threat Detection audit storage account. Required if state is Enabled.

storageEndpoint String

Specifies the blob storage endpoint (e.g. https://example.blob.core.windows.net). This blob storage will hold all Threat Detection audit logs. Required if state is Enabled.

Import

SQL Database can be imported using the resource id, e.g.

 $ pulumi import azure:mssql/database:Database example /subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/group1/providers/Microsoft.Sql/servers/server1/databases/example1

Package Details

Repository
https://github.com/pulumi/pulumi-azure
License
Apache-2.0
Notes

This Pulumi package is based on the azurerm Terraform Provider.