Module sql

@pulumi/azure > sql

Index

sql/activeDirectoryAdministrator.ts sql/database.ts sql/elasticPool.ts sql/firewallRule.ts sql/sqlServer.ts sql/virtualNetworkRule.ts

class ActiveDirectoryAdministrator

Allows you to set a user or group as the AD administrator for an Azure SQL server

constructor

new ActiveDirectoryAdministrator(name: string, args: ActiveDirectoryAdministratorArgs, opts?: pulumi.CustomResourceOptions)

Create a ActiveDirectoryAdministrator resource with the given unique name, arguments, and options.

  • name The unique name of the resource.
  • args The arguments to use to populate this resource's properties.
  • opts A bag of options that control this resource's behavior.

method get

public static get(name: string, id: pulumi.Input<pulumi.ID>, state?: ActiveDirectoryAdministratorState): ActiveDirectoryAdministrator

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

method getProvider

getProvider(moduleMember: string): ProviderResource | undefined

method isInstance

static isInstance(obj: any): boolean

Returns true if the given object is an instance of CustomResource. This is designed to work even when multiple copies of the Pulumi SDK have been loaded into the same process.

property id

id: Output<ID>;

id is the provider-assigned unique ID for this managed resource. It is set during deployments and may be missing (undefined) during planning phases.

property login

public login: pulumi.Output<string>;

The login name of the principal to set as the server administrator

property objectId

public objectId: pulumi.Output<string>;

The ID of the principal to set as the server administrator

property resourceGroupName

public resourceGroupName: pulumi.Output<string>;

The name of the resource group for the SQL server. Changing this forces a new resource to be created.

property serverName

public serverName: pulumi.Output<string>;

The name of the SQL Server on which to set the administrator. Changing this forces a new resource to be created.

property tenantId

public tenantId: pulumi.Output<string>;

The Azure Tenant ID

property urn

urn: Output<URN>;

urn is the stable logical URN used to distinctly address a resource, both before and after deployments.

class Database

Allows you to manage an Azure SQL Database

constructor

new Database(name: string, args: DatabaseArgs, opts?: pulumi.CustomResourceOptions)

Create a Database resource with the given unique name, arguments, and options.

  • name The unique name of the resource.
  • args The arguments to use to populate this resource's properties.
  • opts A bag of options that control this resource's behavior.

method get

public static get(name: string, id: pulumi.Input<pulumi.ID>, state?: DatabaseState): Database

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

method getProvider

getProvider(moduleMember: string): ProviderResource | undefined

method isInstance

static isInstance(obj: any): boolean

Returns true if the given object is an instance of CustomResource. This is designed to work even when multiple copies of the Pulumi SDK have been loaded into the same process.

property collation

public collation: pulumi.Output<string>;

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.

property createMode

public createMode: pulumi.Output<string | undefined>;

Specifies the type of database to create. Defaults to Default. See below for the accepted values/

property creationDate

public creationDate: pulumi.Output<string>;

The creation date of the SQL Database.

property defaultSecondaryLocation

public defaultSecondaryLocation: pulumi.Output<string>;

The default secondary location of the SQL Database.

property edition

public edition: pulumi.Output<string>;

The edition of the database to be created. Applies only if create_mode is Default. Valid values are: Basic, Standard, Premium, or DataWarehouse. Please see Azure SQL Database Service Tiers.

property elasticPoolName

public elasticPoolName: pulumi.Output<string>;

The name of the elastic database pool.

property encryption

public encryption: pulumi.Output<string>;

property id

id: Output<ID>;

id is the provider-assigned unique ID for this managed resource. It is set during deployments and may be missing (undefined) during planning phases.

property import

public import: pulumi.Output<{ ... } | undefined>;

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

property location

public location: pulumi.Output<string>;

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

property maxSizeBytes

public maxSizeBytes: pulumi.Output<string>;

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

property name

public name: pulumi.Output<string>;

The name of the database.

property requestedServiceObjectiveId

public requestedServiceObjectiveId: pulumi.Output<string>;

Use requested_service_objective_id or requested_service_objective_name to set the performance level for the database. Valid values are: S0, S1, S2, S3, P1, P2, P4, P6, P11 and ElasticPool. Please see Azure SQL Database Service Tiers.

property requestedServiceObjectiveName

public requestedServiceObjectiveName: pulumi.Output<string>;

Use requested_service_objective_name or requested_service_objective_id to set the performance level for the database. Please see Azure SQL Database Service Tiers.

property resourceGroupName

public resourceGroupName: pulumi.Output<string>;

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

property restorePointInTime

public restorePointInTime: pulumi.Output<string>;

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

property serverName

public serverName: pulumi.Output<string>;

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

property sourceDatabaseDeletionDate

public sourceDatabaseDeletionDate: pulumi.Output<string>;

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

property sourceDatabaseId

public sourceDatabaseId: pulumi.Output<string>;

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

property tags

public tags: pulumi.Output<{ ... }>;

A mapping of tags to assign to the resource.

property threatDetectionPolicy

public threatDetectionPolicy: pulumi.Output<{ ... }>;

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

property urn

urn: Output<URN>;

urn is the stable logical URN used to distinctly address a resource, both before and after deployments.

class ElasticPool

Allows you to manage an Azure SQL Elastic Pool.

~> NOTE: - This version of the Elasticpool resource is being deprecated and should no longer be used. Please use the azurerm_mssql_elasticpool version instead.

constructor

new ElasticPool(name: string, args: ElasticPoolArgs, opts?: pulumi.CustomResourceOptions)

Create a ElasticPool resource with the given unique name, arguments, and options.

  • name The unique name of the resource.
  • args The arguments to use to populate this resource's properties.
  • opts A bag of options that control this resource's behavior.

method get

public static get(name: string, id: pulumi.Input<pulumi.ID>, state?: ElasticPoolState): ElasticPool

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

method getProvider

getProvider(moduleMember: string): ProviderResource | undefined

method isInstance

static isInstance(obj: any): boolean

Returns true if the given object is an instance of CustomResource. This is designed to work even when multiple copies of the Pulumi SDK have been loaded into the same process.

property creationDate

public creationDate: pulumi.Output<string>;

The creation date of the SQL Elastic Pool.

property dbDtuMax

public dbDtuMax: pulumi.Output<number>;

The maximum DTU which will be guaranteed to all databases in the elastic pool to be created.

property dbDtuMin

public dbDtuMin: pulumi.Output<number>;

The minimum DTU which will be guaranteed to all databases in the elastic pool to be created.

property dtu

public dtu: pulumi.Output<number>;

The total shared DTU for the elastic pool. Valid values depend on the edition which has been defined. Refer to Azure SQL Database Service Tiers for valid combinations.

property edition

public edition: pulumi.Output<string>;

The edition of the elastic pool to be created. Valid values are Basic, Standard, and Premium. Refer to Azure SQL Database Service Tiers for details. Changing this forces a new resource to be created.

property id

id: Output<ID>;

id is the provider-assigned unique ID for this managed resource. It is set during deployments and may be missing (undefined) during planning phases.

property location

public location: pulumi.Output<string>;

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

property name

public name: pulumi.Output<string>;

The name of the elastic pool. This needs to be globally unique. Changing this forces a new resource to be created.

property poolSize

public poolSize: pulumi.Output<number>;

The maximum size in MB that all databases in the elastic pool can grow to. The maximum size must be consistent with combination of edition and dtu and the limits documented in Azure SQL Database Service Tiers. If not defined when creating an elastic pool, the value is set to the size implied by edition and dtu.

property resourceGroupName

public resourceGroupName: pulumi.Output<string>;

The name of the resource group in which to create the elastic pool. This must be the same as the resource group of the underlying SQL server.

property serverName

public serverName: pulumi.Output<string>;

The name of the SQL Server on which to create the elastic pool. Changing this forces a new resource to be created.

property tags

public tags: pulumi.Output<{ ... }>;

A mapping of tags to assign to the resource.

property urn

urn: Output<URN>;

urn is the stable logical URN used to distinctly address a resource, both before and after deployments.

class FirewallRule

Allows you to manage an Azure SQL Firewall Rule

constructor

new FirewallRule(name: string, args: FirewallRuleArgs, opts?: pulumi.CustomResourceOptions)

Create a FirewallRule resource with the given unique name, arguments, and options.

  • name The unique name of the resource.
  • args The arguments to use to populate this resource's properties.
  • opts A bag of options that control this resource's behavior.

method get

public static get(name: string, id: pulumi.Input<pulumi.ID>, state?: FirewallRuleState): FirewallRule

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

method getProvider

getProvider(moduleMember: string): ProviderResource | undefined

method isInstance

static isInstance(obj: any): boolean

Returns true if the given object is an instance of CustomResource. This is designed to work even when multiple copies of the Pulumi SDK have been loaded into the same process.

property endIpAddress

public endIpAddress: pulumi.Output<string>;

The ending IP address to allow through the firewall for this rule.

property id

id: Output<ID>;

id is the provider-assigned unique ID for this managed resource. It is set during deployments and may be missing (undefined) during planning phases.

property name

public name: pulumi.Output<string>;

The name of the firewall rule.

property resourceGroupName

public resourceGroupName: pulumi.Output<string>;

The name of the resource group in which to create the sql server.

property serverName

public serverName: pulumi.Output<string>;

The name of the SQL Server on which to create the Firewall Rule.

property startIpAddress

public startIpAddress: pulumi.Output<string>;

The starting IP address to allow through the firewall for this rule.

property urn

urn: Output<URN>;

urn is the stable logical URN used to distinctly address a resource, both before and after deployments.

class SqlServer

Manages a SQL Azure Database Server.

~> Note: All arguments including the administrator login and password will be stored in the raw state as plain-text. Read more about sensitive data in state.

constructor

new SqlServer(name: string, args: SqlServerArgs, opts?: pulumi.CustomResourceOptions)

Create a SqlServer resource with the given unique name, arguments, and options.

  • name The unique name of the resource.
  • args The arguments to use to populate this resource's properties.
  • opts A bag of options that control this resource's behavior.

method get

public static get(name: string, id: pulumi.Input<pulumi.ID>, state?: SqlServerState): SqlServer

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

method getProvider

getProvider(moduleMember: string): ProviderResource | undefined

method isInstance

static isInstance(obj: any): boolean

Returns true if the given object is an instance of CustomResource. This is designed to work even when multiple copies of the Pulumi SDK have been loaded into the same process.

property administratorLogin

public administratorLogin: pulumi.Output<string>;

The administrator login name for the new server. Changing this forces a new resource to be created.

property administratorLoginPassword

public administratorLoginPassword: pulumi.Output<string>;

The password associated with the administrator_login user. Needs to comply with Azure’s Password Policy

property fullyQualifiedDomainName

public fullyQualifiedDomainName: pulumi.Output<string>;

The fully qualified domain name of the Azure SQL Server (e.g. myServerName.database.windows.net)

property id

id: Output<ID>;

id is the provider-assigned unique ID for this managed resource. It is set during deployments and may be missing (undefined) during planning phases.

property location

public location: pulumi.Output<string>;

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

property name

public name: pulumi.Output<string>;

The name of the SQL Server. This needs to be globally unique within Azure.

property resourceGroupName

public resourceGroupName: pulumi.Output<string>;

The name of the resource group in which to create the SQL Server.

property tags

public tags: pulumi.Output<{ ... }>;

A mapping of tags to assign to the resource.

property urn

urn: Output<URN>;

urn is the stable logical URN used to distinctly address a resource, both before and after deployments.

property version

public version: pulumi.Output<string>;

The version for the new server. Valid values are: 2.0 (for v11 server) and 12.0 (for v12 server).

class VirtualNetworkRule

Allows you to add, update, or remove an Azure SQL server to a subnet of a virtual network.

constructor

new VirtualNetworkRule(name: string, args: VirtualNetworkRuleArgs, opts?: pulumi.CustomResourceOptions)

Create a VirtualNetworkRule resource with the given unique name, arguments, and options.

  • name The unique name of the resource.
  • args The arguments to use to populate this resource's properties.
  • opts A bag of options that control this resource's behavior.

method get

public static get(name: string, id: pulumi.Input<pulumi.ID>, state?: VirtualNetworkRuleState): VirtualNetworkRule

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

method getProvider

getProvider(moduleMember: string): ProviderResource | undefined

method isInstance

static isInstance(obj: any): boolean

Returns true if the given object is an instance of CustomResource. This is designed to work even when multiple copies of the Pulumi SDK have been loaded into the same process.

property id

id: Output<ID>;

id is the provider-assigned unique ID for this managed resource. It is set during deployments and may be missing (undefined) during planning phases.

property ignoreMissingVnetServiceEndpoint

public ignoreMissingVnetServiceEndpoint: pulumi.Output<boolean | undefined>;

Create the virtual network rule before the subnet has the virtual network service endpoint enabled. The default value is false.

property name

public name: pulumi.Output<string>;

The name of the SQL virtual network rule. Changing this forces a new resource to be created. Cannot be empty and must only contain alphanumeric characters and hyphens. Cannot start with a number, and cannot start or end with a hyphen.

property resourceGroupName

public resourceGroupName: pulumi.Output<string>;

The name of the resource group where the SQL server resides. Changing this forces a new resource to be created.

property serverName

public serverName: pulumi.Output<string>;

The name of the SQL Server to which this SQL virtual network rule will be applied to. Changing this forces a new resource to be created.

property subnetId

public subnetId: pulumi.Output<string>;

The ID of the subnet that the SQL server will be connected to.

property urn

urn: Output<URN>;

urn is the stable logical URN used to distinctly address a resource, both before and after deployments.

interface ActiveDirectoryAdministratorArgs

The set of arguments for constructing a ActiveDirectoryAdministrator resource.

property login

login: pulumi.Input<string>;

The login name of the principal to set as the server administrator

property objectId

objectId: pulumi.Input<string>;

The ID of the principal to set as the server administrator

property resourceGroupName

resourceGroupName: pulumi.Input<string>;

The name of the resource group for the SQL server. Changing this forces a new resource to be created.

property serverName

serverName: pulumi.Input<string>;

The name of the SQL Server on which to set the administrator. Changing this forces a new resource to be created.

property tenantId

tenantId: pulumi.Input<string>;

The Azure Tenant ID

interface ActiveDirectoryAdministratorState

Input properties used for looking up and filtering ActiveDirectoryAdministrator resources.

property login

login?: pulumi.Input<string>;

The login name of the principal to set as the server administrator

property objectId

objectId?: pulumi.Input<string>;

The ID of the principal to set as the server administrator

property resourceGroupName

resourceGroupName?: pulumi.Input<string>;

The name of the resource group for the SQL server. Changing this forces a new resource to be created.

property serverName

serverName?: pulumi.Input<string>;

The name of the SQL Server on which to set the administrator. Changing this forces a new resource to be created.

property tenantId

tenantId?: pulumi.Input<string>;

The Azure Tenant ID

interface DatabaseArgs

The set of arguments for constructing a Database resource.

property collation

collation?: pulumi.Input<string>;

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.

property createMode

createMode?: pulumi.Input<string>;

Specifies the type of database to create. Defaults to Default. See below for the accepted values/

property edition

edition?: pulumi.Input<string>;

The edition of the database to be created. Applies only if create_mode is Default. Valid values are: Basic, Standard, Premium, or DataWarehouse. Please see Azure SQL Database Service Tiers.

property elasticPoolName

elasticPoolName?: pulumi.Input<string>;

The name of the elastic database pool.

property import

import?: pulumi.Input<{ ... }>;

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

property location

location: pulumi.Input<string>;

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

property maxSizeBytes

maxSizeBytes?: pulumi.Input<string>;

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

property name

name?: pulumi.Input<string>;

The name of the database.

property requestedServiceObjectiveId

requestedServiceObjectiveId?: pulumi.Input<string>;

Use requested_service_objective_id or requested_service_objective_name to set the performance level for the database. Valid values are: S0, S1, S2, S3, P1, P2, P4, P6, P11 and ElasticPool. Please see Azure SQL Database Service Tiers.

property requestedServiceObjectiveName

requestedServiceObjectiveName?: pulumi.Input<string>;

Use requested_service_objective_name or requested_service_objective_id to set the performance level for the database. Please see Azure SQL Database Service Tiers.

property resourceGroupName

resourceGroupName: pulumi.Input<string>;

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

property restorePointInTime

restorePointInTime?: pulumi.Input<string>;

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

property serverName

serverName: pulumi.Input<string>;

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

property sourceDatabaseDeletionDate

sourceDatabaseDeletionDate?: pulumi.Input<string>;

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

property sourceDatabaseId

sourceDatabaseId?: pulumi.Input<string>;

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

property tags

tags?: pulumi.Input<{ ... }>;

A mapping of tags to assign to the resource.

property threatDetectionPolicy

threatDetectionPolicy?: pulumi.Input<{ ... }>;

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

interface DatabaseState

Input properties used for looking up and filtering Database resources.

property collation

collation?: pulumi.Input<string>;

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.

property createMode

createMode?: pulumi.Input<string>;

Specifies the type of database to create. Defaults to Default. See below for the accepted values/

property creationDate

creationDate?: pulumi.Input<string>;

The creation date of the SQL Database.

property defaultSecondaryLocation

defaultSecondaryLocation?: pulumi.Input<string>;

The default secondary location of the SQL Database.

property edition

edition?: pulumi.Input<string>;

The edition of the database to be created. Applies only if create_mode is Default. Valid values are: Basic, Standard, Premium, or DataWarehouse. Please see Azure SQL Database Service Tiers.

property elasticPoolName

elasticPoolName?: pulumi.Input<string>;

The name of the elastic database pool.

property encryption

encryption?: pulumi.Input<string>;

property import

import?: pulumi.Input<{ ... }>;

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

property location

location?: pulumi.Input<string>;

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

property maxSizeBytes

maxSizeBytes?: pulumi.Input<string>;

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

property name

name?: pulumi.Input<string>;

The name of the database.

property requestedServiceObjectiveId

requestedServiceObjectiveId?: pulumi.Input<string>;

Use requested_service_objective_id or requested_service_objective_name to set the performance level for the database. Valid values are: S0, S1, S2, S3, P1, P2, P4, P6, P11 and ElasticPool. Please see Azure SQL Database Service Tiers.

property requestedServiceObjectiveName

requestedServiceObjectiveName?: pulumi.Input<string>;

Use requested_service_objective_name or requested_service_objective_id to set the performance level for the database. Please see Azure SQL Database Service Tiers.

property resourceGroupName

resourceGroupName?: pulumi.Input<string>;

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

property restorePointInTime

restorePointInTime?: pulumi.Input<string>;

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

property serverName

serverName?: pulumi.Input<string>;

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

property sourceDatabaseDeletionDate

sourceDatabaseDeletionDate?: pulumi.Input<string>;

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

property sourceDatabaseId

sourceDatabaseId?: pulumi.Input<string>;

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

property tags

tags?: pulumi.Input<{ ... }>;

A mapping of tags to assign to the resource.

property threatDetectionPolicy

threatDetectionPolicy?: pulumi.Input<{ ... }>;

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

interface ElasticPoolArgs

The set of arguments for constructing a ElasticPool resource.

property dbDtuMax

dbDtuMax?: pulumi.Input<number>;

The maximum DTU which will be guaranteed to all databases in the elastic pool to be created.

property dbDtuMin

dbDtuMin?: pulumi.Input<number>;

The minimum DTU which will be guaranteed to all databases in the elastic pool to be created.

property dtu

dtu: pulumi.Input<number>;

The total shared DTU for the elastic pool. Valid values depend on the edition which has been defined. Refer to Azure SQL Database Service Tiers for valid combinations.

property edition

edition: pulumi.Input<string>;

The edition of the elastic pool to be created. Valid values are Basic, Standard, and Premium. Refer to Azure SQL Database Service Tiers for details. Changing this forces a new resource to be created.

property location

location: pulumi.Input<string>;

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

property name

name?: pulumi.Input<string>;

The name of the elastic pool. This needs to be globally unique. Changing this forces a new resource to be created.

property poolSize

poolSize?: pulumi.Input<number>;

The maximum size in MB that all databases in the elastic pool can grow to. The maximum size must be consistent with combination of edition and dtu and the limits documented in Azure SQL Database Service Tiers. If not defined when creating an elastic pool, the value is set to the size implied by edition and dtu.

property resourceGroupName

resourceGroupName: pulumi.Input<string>;

The name of the resource group in which to create the elastic pool. This must be the same as the resource group of the underlying SQL server.

property serverName

serverName: pulumi.Input<string>;

The name of the SQL Server on which to create the elastic pool. Changing this forces a new resource to be created.

property tags

tags?: pulumi.Input<{ ... }>;

A mapping of tags to assign to the resource.

interface ElasticPoolState

Input properties used for looking up and filtering ElasticPool resources.

property creationDate

creationDate?: pulumi.Input<string>;

The creation date of the SQL Elastic Pool.

property dbDtuMax

dbDtuMax?: pulumi.Input<number>;

The maximum DTU which will be guaranteed to all databases in the elastic pool to be created.

property dbDtuMin

dbDtuMin?: pulumi.Input<number>;

The minimum DTU which will be guaranteed to all databases in the elastic pool to be created.

property dtu

dtu?: pulumi.Input<number>;

The total shared DTU for the elastic pool. Valid values depend on the edition which has been defined. Refer to Azure SQL Database Service Tiers for valid combinations.

property edition

edition?: pulumi.Input<string>;

The edition of the elastic pool to be created. Valid values are Basic, Standard, and Premium. Refer to Azure SQL Database Service Tiers for details. Changing this forces a new resource to be created.

property location

location?: pulumi.Input<string>;

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

property name

name?: pulumi.Input<string>;

The name of the elastic pool. This needs to be globally unique. Changing this forces a new resource to be created.

property poolSize

poolSize?: pulumi.Input<number>;

The maximum size in MB that all databases in the elastic pool can grow to. The maximum size must be consistent with combination of edition and dtu and the limits documented in Azure SQL Database Service Tiers. If not defined when creating an elastic pool, the value is set to the size implied by edition and dtu.

property resourceGroupName

resourceGroupName?: pulumi.Input<string>;

The name of the resource group in which to create the elastic pool. This must be the same as the resource group of the underlying SQL server.

property serverName

serverName?: pulumi.Input<string>;

The name of the SQL Server on which to create the elastic pool. Changing this forces a new resource to be created.

property tags

tags?: pulumi.Input<{ ... }>;

A mapping of tags to assign to the resource.

interface FirewallRuleArgs

The set of arguments for constructing a FirewallRule resource.

property endIpAddress

endIpAddress: pulumi.Input<string>;

The ending IP address to allow through the firewall for this rule.

property name

name?: pulumi.Input<string>;

The name of the firewall rule.

property resourceGroupName

resourceGroupName: pulumi.Input<string>;

The name of the resource group in which to create the sql server.

property serverName

serverName: pulumi.Input<string>;

The name of the SQL Server on which to create the Firewall Rule.

property startIpAddress

startIpAddress: pulumi.Input<string>;

The starting IP address to allow through the firewall for this rule.

interface FirewallRuleState

Input properties used for looking up and filtering FirewallRule resources.

property endIpAddress

endIpAddress?: pulumi.Input<string>;

The ending IP address to allow through the firewall for this rule.

property name

name?: pulumi.Input<string>;

The name of the firewall rule.

property resourceGroupName

resourceGroupName?: pulumi.Input<string>;

The name of the resource group in which to create the sql server.

property serverName

serverName?: pulumi.Input<string>;

The name of the SQL Server on which to create the Firewall Rule.

property startIpAddress

startIpAddress?: pulumi.Input<string>;

The starting IP address to allow through the firewall for this rule.

interface SqlServerArgs

The set of arguments for constructing a SqlServer resource.

property administratorLogin

administratorLogin: pulumi.Input<string>;

The administrator login name for the new server. Changing this forces a new resource to be created.

property administratorLoginPassword

administratorLoginPassword: pulumi.Input<string>;

The password associated with the administrator_login user. Needs to comply with Azure’s Password Policy

property location

location: pulumi.Input<string>;

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

property name

name?: pulumi.Input<string>;

The name of the SQL Server. This needs to be globally unique within Azure.

property resourceGroupName

resourceGroupName: pulumi.Input<string>;

The name of the resource group in which to create the SQL Server.

property tags

tags?: pulumi.Input<{ ... }>;

A mapping of tags to assign to the resource.

property version

version: pulumi.Input<string>;

The version for the new server. Valid values are: 2.0 (for v11 server) and 12.0 (for v12 server).

interface SqlServerState

Input properties used for looking up and filtering SqlServer resources.

property administratorLogin

administratorLogin?: pulumi.Input<string>;

The administrator login name for the new server. Changing this forces a new resource to be created.

property administratorLoginPassword

administratorLoginPassword?: pulumi.Input<string>;

The password associated with the administrator_login user. Needs to comply with Azure’s Password Policy

property fullyQualifiedDomainName

fullyQualifiedDomainName?: pulumi.Input<string>;

The fully qualified domain name of the Azure SQL Server (e.g. myServerName.database.windows.net)

property location

location?: pulumi.Input<string>;

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

property name

name?: pulumi.Input<string>;

The name of the SQL Server. This needs to be globally unique within Azure.

property resourceGroupName

resourceGroupName?: pulumi.Input<string>;

The name of the resource group in which to create the SQL Server.

property tags

tags?: pulumi.Input<{ ... }>;

A mapping of tags to assign to the resource.

property version

version?: pulumi.Input<string>;

The version for the new server. Valid values are: 2.0 (for v11 server) and 12.0 (for v12 server).

interface VirtualNetworkRuleArgs

The set of arguments for constructing a VirtualNetworkRule resource.

property ignoreMissingVnetServiceEndpoint

ignoreMissingVnetServiceEndpoint?: pulumi.Input<boolean>;

Create the virtual network rule before the subnet has the virtual network service endpoint enabled. The default value is false.

property name

name?: pulumi.Input<string>;

The name of the SQL virtual network rule. Changing this forces a new resource to be created. Cannot be empty and must only contain alphanumeric characters and hyphens. Cannot start with a number, and cannot start or end with a hyphen.

property resourceGroupName

resourceGroupName: pulumi.Input<string>;

The name of the resource group where the SQL server resides. Changing this forces a new resource to be created.

property serverName

serverName: pulumi.Input<string>;

The name of the SQL Server to which this SQL virtual network rule will be applied to. Changing this forces a new resource to be created.

property subnetId

subnetId: pulumi.Input<string>;

The ID of the subnet that the SQL server will be connected to.

interface VirtualNetworkRuleState

Input properties used for looking up and filtering VirtualNetworkRule resources.

property ignoreMissingVnetServiceEndpoint

ignoreMissingVnetServiceEndpoint?: pulumi.Input<boolean>;

Create the virtual network rule before the subnet has the virtual network service endpoint enabled. The default value is false.

property name

name?: pulumi.Input<string>;

The name of the SQL virtual network rule. Changing this forces a new resource to be created. Cannot be empty and must only contain alphanumeric characters and hyphens. Cannot start with a number, and cannot start or end with a hyphen.

property resourceGroupName

resourceGroupName?: pulumi.Input<string>;

The name of the resource group where the SQL server resides. Changing this forces a new resource to be created.

property serverName

serverName?: pulumi.Input<string>;

The name of the SQL Server to which this SQL virtual network rule will be applied to. Changing this forces a new resource to be created.

property subnetId

subnetId?: pulumi.Input<string>;

The ID of the subnet that the SQL server will be connected to.