Class DatabaseArgs

Inheritance
System.Object
InputArgs
ResourceArgs
DatabaseArgs
Inherited Members
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.ToString()
Namespace: Pulumi.Azure.Sql
Assembly: Pulumi.Azure.dll
Syntax
public sealed class DatabaseArgs : ResourceArgs

Constructors

View Source

DatabaseArgs()

Declaration
public DatabaseArgs()

Properties

View Source

Collation

The name of the collation. Applies only if create_mode is Default. Azure default is SQL_LATIN1_GENERAL_CP1_CI_AS. Changing this forces a new resource to be created.

Declaration
public Input<string> Collation { get; set; }
Property Value
Type Description
Input<System.String>
View Source

CreateMode

Specifies how to create the database. Valid values are: Default, Copy, OnlineSecondary, NonReadableSecondary, PointInTimeRestore, Recovery, Restore or RestoreLongTermRetentionBackup. Must be Default to create a new database. Defaults to Default. Please see Azure SQL Database REST API

Declaration
public Input<string> CreateMode { get; set; }
Property Value
Type Description
Input<System.String>
View Source

Edition

The edition of the database to be created. Applies only if create_mode is Default. Valid values are: Basic, Standard, Premium, DataWarehouse, Business, BusinessCritical, Free, GeneralPurpose, Hyperscale, Premium, PremiumRS, Standard, Stretch, System, System2, or Web. Please see Azure SQL Database Service Tiers.

Declaration
public Input<string> Edition { get; set; }
Property Value
Type Description
Input<System.String>
View Source

ElasticPoolName

The name of the elastic database pool.

Declaration
public Input<string> ElasticPoolName { get; set; }
Property Value
Type Description
Input<System.String>
View Source

ExtendedAuditingPolicy

A extended_auditing_policy block as defined below.

Declaration
public Input<DatabaseExtendedAuditingPolicyArgs> ExtendedAuditingPolicy { get; set; }
Property Value
Type Description
Input<DatabaseExtendedAuditingPolicyArgs>
View Source

Import

A Database Import block as documented below. create_mode must be set to Default.

Declaration
public Input<DatabaseImportArgs> Import { get; set; }
Property Value
Type Description
Input<DatabaseImportArgs>
View Source

Location

Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.

Declaration
public Input<string> Location { get; set; }
Property Value
Type Description
Input<System.String>
View Source

MaxSizeBytes

The maximum size that the database can grow to. Applies only if create_mode is Default. Please see Azure SQL Database Service Tiers.

Declaration
public Input<string> MaxSizeBytes { get; set; }
Property Value
Type Description
Input<System.String>
View Source

MaxSizeGb

Declaration
public Input<string> MaxSizeGb { get; set; }
Property Value
Type Description
Input<System.String>
View Source

Name

The name of the database.

Declaration
public Input<string> Name { get; set; }
Property Value
Type Description
Input<System.String>
View Source

ReadScale

Read-only connections will be redirected to a high-available replica. Please see Use read-only replicas to load-balance read-only query workloads.

Declaration
public Input<bool> ReadScale { get; set; }
Property Value
Type Description
Input<System.Boolean>
View Source

RequestedServiceObjectiveId

A GUID/UUID corresponding to a configured Service Level Objective for the Azure SQL database which can be used to configure a performance level. .

Declaration
public Input<string> RequestedServiceObjectiveId { get; set; }
Property Value
Type Description
Input<System.String>
View Source

RequestedServiceObjectiveName

The service objective name for the database. Valid values depend on edition and location and may include S0, S1, S2, S3, P1, P2, P4, P6, P11 and ElasticPool. You can list the available names with the cli: shell az sql db list-editions -l westus --edition Standard -o table. For further information please see Azure CLI - az sql db.

Declaration
public Input<string> RequestedServiceObjectiveName { get; set; }
Property Value
Type Description
Input<System.String>
View Source

ResourceGroupName

The name of the resource group in which to create the database. This must be the same as Database Server resource group currently.

Declaration
public Input<string> ResourceGroupName { get; set; }
Property Value
Type Description
Input<System.String>
View Source

RestorePointInTime

The point in time for the restore. Only applies if create_mode is PointInTimeRestore e.g. 2013-11-08T22:00:40Z

Declaration
public Input<string> RestorePointInTime { get; set; }
Property Value
Type Description
Input<System.String>
View Source

ServerName

The name of the SQL Server on which to create the database.

Declaration
public Input<string> ServerName { get; set; }
Property Value
Type Description
Input<System.String>
View Source

SourceDatabaseDeletionDate

The deletion date time of the source database. Only applies to deleted databases where create_mode is PointInTimeRestore.

Declaration
public Input<string> SourceDatabaseDeletionDate { get; set; }
Property Value
Type Description
Input<System.String>
View Source

SourceDatabaseId

The URI of the source database if create_mode value is not Default.

Declaration
public Input<string> SourceDatabaseId { get; set; }
Property Value
Type Description
Input<System.String>
View Source

Tags

A mapping of tags to assign to the resource.

Declaration
public InputMap<string> Tags { get; set; }
Property Value
Type Description
InputMap<System.String>
View Source

ThreatDetectionPolicy

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

Declaration
public Input<DatabaseThreatDetectionPolicyArgs> ThreatDetectionPolicy { get; set; }
Property Value
Type Description
Input<DatabaseThreatDetectionPolicyArgs>
View Source

ZoneRedundant

Whether or not this database is zone redundant, which means the replicas of this database will be spread across multiple availability zones.

Declaration
public Input<bool> ZoneRedundant { get; set; }
Property Value
Type Description
Input<System.Boolean>