sql

package
v1.5.0 Latest Latest
Warning

This package is not in the latest version of its module.

 Go to latest Published: Nov 27, 2019 License: Apache-2.0 Imports: 2 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

This section is empty.

Types

type ActiveDirectoryAdministrator 

type ActiveDirectoryAdministrator struct {
	// contains filtered or unexported fields
}

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

> This content is derived from https://github.com/terraform-providers/terraform-provider-azurerm/blob/master/website/docs/r/sql_active_directory_administrator.html.markdown.

func GetActiveDirectoryAdministrator 

func GetActiveDirectoryAdministrator(ctx *pulumi.Context,
	name string, id pulumi.ID, state *ActiveDirectoryAdministratorState, opts ...pulumi.ResourceOpt) (*ActiveDirectoryAdministrator, error)

GetActiveDirectoryAdministrator gets an existing ActiveDirectoryAdministrator resource's state with the given name, ID, and optional state properties that are used to uniquely qualify the lookup (nil if not required).

func NewActiveDirectoryAdministrator 

func NewActiveDirectoryAdministrator(ctx *pulumi.Context,
	name string, args *ActiveDirectoryAdministratorArgs, opts ...pulumi.ResourceOpt) (*ActiveDirectoryAdministrator, error)

NewActiveDirectoryAdministrator registers a new resource with the given unique name, arguments, and options.

func (*ActiveDirectoryAdministrator) ID 

func (r *ActiveDirectoryAdministrator) ID() pulumi.IDOutput

ID is this resource's unique identifier assigned by its provider.

func (*ActiveDirectoryAdministrator) Login 

func (r *ActiveDirectoryAdministrator) Login() pulumi.StringOutput

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

func (*ActiveDirectoryAdministrator) ObjectId 

func (r *ActiveDirectoryAdministrator) ObjectId() pulumi.StringOutput

The ID of the principal to set as the server administrator

func (*ActiveDirectoryAdministrator) ResourceGroupName 

func (r *ActiveDirectoryAdministrator) ResourceGroupName() pulumi.StringOutput

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

func (*ActiveDirectoryAdministrator) ServerName 

func (r *ActiveDirectoryAdministrator) ServerName() pulumi.StringOutput

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

func (*ActiveDirectoryAdministrator) TenantId 

func (r *ActiveDirectoryAdministrator) TenantId() pulumi.StringOutput

The Azure Tenant ID

func (*ActiveDirectoryAdministrator) URN 

func (r *ActiveDirectoryAdministrator) URN() pulumi.URNOutput

URN is this resource's unique name assigned by Pulumi.

type ActiveDirectoryAdministratorArgs 

type ActiveDirectoryAdministratorArgs struct {
	// The login name of the principal to set as the server administrator
	Login interface{}
	// The ID of the principal to set as the server administrator
	ObjectId interface{}
	// The name of the resource group for the SQL server. Changing this forces a new resource to be created.
	ResourceGroupName interface{}
	// The name of the SQL Server on which to set the administrator. Changing this forces a new resource to be created.
	ServerName interface{}
	// The Azure Tenant ID
	TenantId interface{}
}

The set of arguments for constructing a ActiveDirectoryAdministrator resource.

type ActiveDirectoryAdministratorState 

type ActiveDirectoryAdministratorState struct {
	// The login name of the principal to set as the server administrator
	Login interface{}
	// The ID of the principal to set as the server administrator
	ObjectId interface{}
	// The name of the resource group for the SQL server. Changing this forces a new resource to be created.
	ResourceGroupName interface{}
	// The name of the SQL Server on which to set the administrator. Changing this forces a new resource to be created.
	ServerName interface{}
	// The Azure Tenant ID
	TenantId interface{}
}

Input properties used for looking up and filtering ActiveDirectoryAdministrator resources.

type Database 

type Database struct {
	// contains filtered or unexported fields
}

Allows you to manage an Azure SQL Database

> This content is derived from https://github.com/terraform-providers/terraform-provider-azurerm/blob/master/website/docs/r/sql_database.html.markdown.

func GetDatabase 

func GetDatabase(ctx *pulumi.Context,
	name string, id pulumi.ID, state *DatabaseState, opts ...pulumi.ResourceOpt) (*Database, error)

GetDatabase gets an existing Database resource's state with the given name, ID, and optional state properties that are used to uniquely qualify the lookup (nil if not required).

func NewDatabase 

func NewDatabase(ctx *pulumi.Context,
	name string, args *DatabaseArgs, opts ...pulumi.ResourceOpt) (*Database, error)

NewDatabase registers a new resource with the given unique name, arguments, and options.

func (*Database) Collation 

func (r *Database) Collation() pulumi.StringOutput

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

func (*Database) CreateMode 

func (r *Database) CreateMode() pulumi.StringOutput

Specifies how to create the database. Must be either `Default` to create a new database or `PointInTimeRestore` to restore from a snapshot. Defaults to `Default`.

func (*Database) CreationDate 

func (r *Database) CreationDate() pulumi.StringOutput

The creation date of the SQL Database.

func (*Database) DefaultSecondaryLocation 

func (r *Database) DefaultSecondaryLocation() pulumi.StringOutput

The default secondary location of the SQL Database.

func (*Database) Edition 

func (r *Database) Edition() pulumi.StringOutput

The edition of the database to be created. Applies only if `createMode` 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](https://azure.microsoft.com/en-gb/documentation/articles/sql-database-service-tiers/).

func (*Database) ElasticPoolName 

func (r *Database) ElasticPoolName() pulumi.StringOutput

The name of the elastic database pool.

func (*Database) Encryption 

func (r *Database) Encryption() pulumi.StringOutput

func (*Database) ID 

func (r *Database) ID() pulumi.IDOutput

ID is this resource's unique identifier assigned by its provider.

func (*Database) Import added in v0.15.0 

func (r *Database) Import() pulumi.Output

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

func (*Database) Location 

func (r *Database) Location() pulumi.StringOutput

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

func (*Database) MaxSizeBytes 

func (r *Database) MaxSizeBytes() pulumi.StringOutput

The maximum size that the database can grow to. Applies only if `createMode` is `Default`. Please see [Azure SQL Database Service Tiers](https://azure.microsoft.com/en-gb/documentation/articles/sql-database-service-tiers/).

func (*Database) Name 

func (r *Database) Name() pulumi.StringOutput

The name of the database.

func (*Database) ReadScale added in v0.18.3 

func (r *Database) ReadScale() pulumi.BoolOutput

Read-only connections will be redirected to a high-available replica. Please see [Use read-only replicas to load-balance read-only query workloads](https://docs.microsoft.com/en-us/azure/sql-database/sql-database-read-scale-out).

func (*Database) RequestedServiceObjectiveId 

func (r *Database) RequestedServiceObjectiveId() pulumi.StringOutput

Use `requestedServiceObjectiveId` or `requestedServiceObjectiveName` to set the performance level for the database. Please see [Azure SQL Database Service Tiers](https://azure.microsoft.com/en-gb/documentation/articles/sql-database-service-tiers/).

func (*Database) RequestedServiceObjectiveName 

func (r *Database) RequestedServiceObjectiveName() pulumi.StringOutput

Use `requestedServiceObjectiveName` or `requestedServiceObjectiveId` 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](https://azure.microsoft.com/en-gb/documentation/articles/sql-database-service-tiers/).

func (*Database) ResourceGroupName 

func (r *Database) ResourceGroupName() pulumi.StringOutput

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

func (*Database) RestorePointInTime 

func (r *Database) RestorePointInTime() pulumi.StringOutput

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

func (*Database) ServerName 

func (r *Database) ServerName() pulumi.StringOutput

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

func (*Database) SourceDatabaseDeletionDate 

func (r *Database) SourceDatabaseDeletionDate() pulumi.StringOutput

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

func (*Database) SourceDatabaseId 

func (r *Database) SourceDatabaseId() pulumi.StringOutput

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

func (*Database) Tags 

func (r *Database) Tags() pulumi.MapOutput

A mapping of tags to assign to the resource.

func (*Database) ThreatDetectionPolicy added in v0.16.0 

func (r *Database) ThreatDetectionPolicy() pulumi.Output

Threat detection policy configuration. The `threatDetectionPolicy` block supports fields documented below.

func (*Database) URN 

func (r *Database) URN() pulumi.URNOutput

URN is this resource's unique name assigned by Pulumi.

type DatabaseArgs 

type DatabaseArgs struct {
	// The name of the collation. Applies only if `createMode` is `Default`.  Azure default is `SQL_LATIN1_GENERAL_CP1_CI_AS`. Changing this forces a new resource to be created.
	Collation interface{}
	// Specifies how to create the database. Must be either `Default` to create a new database or `PointInTimeRestore` to restore from a snapshot. Defaults to `Default`.
	CreateMode interface{}
	// The edition of the database to be created. Applies only if `createMode` 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](https://azure.microsoft.com/en-gb/documentation/articles/sql-database-service-tiers/).
	Edition interface{}
	// The name of the elastic database pool.
	ElasticPoolName interface{}
	// A Database Import block as documented below. `createMode` must be set to `Default`.
	Import interface{}
	// Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
	Location interface{}
	// The maximum size that the database can grow to. Applies only if `createMode` is `Default`.  Please see [Azure SQL Database Service Tiers](https://azure.microsoft.com/en-gb/documentation/articles/sql-database-service-tiers/).
	MaxSizeBytes interface{}
	// The name of the database.
	Name interface{}
	// Read-only connections will be redirected to a high-available replica. Please see [Use read-only replicas to load-balance read-only query workloads](https://docs.microsoft.com/en-us/azure/sql-database/sql-database-read-scale-out).
	ReadScale interface{}
	// Use `requestedServiceObjectiveId` or `requestedServiceObjectiveName` to set the performance level for the database.
	// Please see [Azure SQL Database Service Tiers](https://azure.microsoft.com/en-gb/documentation/articles/sql-database-service-tiers/).
	RequestedServiceObjectiveId interface{}
	// Use `requestedServiceObjectiveName` or `requestedServiceObjectiveId` 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](https://azure.microsoft.com/en-gb/documentation/articles/sql-database-service-tiers/).
	RequestedServiceObjectiveName interface{}
	// The name of the resource group in which to create the database.  This must be the same as Database Server resource group currently.
	ResourceGroupName interface{}
	// The point in time for the restore. Only applies if `createMode` is `PointInTimeRestore` e.g. 2013-11-08T22:00:40Z
	RestorePointInTime interface{}
	// The name of the SQL Server on which to create the database.
	ServerName interface{}
	// The deletion date time of the source database. Only applies to deleted databases where `createMode` is `PointInTimeRestore`.
	SourceDatabaseDeletionDate interface{}
	// The URI of the source database if `createMode` value is not `Default`.
	SourceDatabaseId interface{}
	// A mapping of tags to assign to the resource.
	Tags interface{}
	// Threat detection policy configuration. The `threatDetectionPolicy` block supports fields documented below.
	ThreatDetectionPolicy interface{}
}

The set of arguments for constructing a Database resource.

type DatabaseState 

type DatabaseState struct {
	// The name of the collation. Applies only if `createMode` is `Default`.  Azure default is `SQL_LATIN1_GENERAL_CP1_CI_AS`. Changing this forces a new resource to be created.
	Collation interface{}
	// Specifies how to create the database. Must be either `Default` to create a new database or `PointInTimeRestore` to restore from a snapshot. Defaults to `Default`.
	CreateMode interface{}
	// The creation date of the SQL Database.
	CreationDate interface{}
	// The default secondary location of the SQL Database.
	DefaultSecondaryLocation interface{}
	// The edition of the database to be created. Applies only if `createMode` 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](https://azure.microsoft.com/en-gb/documentation/articles/sql-database-service-tiers/).
	Edition interface{}
	// The name of the elastic database pool.
	ElasticPoolName interface{}
	Encryption      interface{}
	// A Database Import block as documented below. `createMode` must be set to `Default`.
	Import interface{}
	// Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
	Location interface{}
	// The maximum size that the database can grow to. Applies only if `createMode` is `Default`.  Please see [Azure SQL Database Service Tiers](https://azure.microsoft.com/en-gb/documentation/articles/sql-database-service-tiers/).
	MaxSizeBytes interface{}
	// The name of the database.
	Name interface{}
	// Read-only connections will be redirected to a high-available replica. Please see [Use read-only replicas to load-balance read-only query workloads](https://docs.microsoft.com/en-us/azure/sql-database/sql-database-read-scale-out).
	ReadScale interface{}
	// Use `requestedServiceObjectiveId` or `requestedServiceObjectiveName` to set the performance level for the database.
	// Please see [Azure SQL Database Service Tiers](https://azure.microsoft.com/en-gb/documentation/articles/sql-database-service-tiers/).
	RequestedServiceObjectiveId interface{}
	// Use `requestedServiceObjectiveName` or `requestedServiceObjectiveId` 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](https://azure.microsoft.com/en-gb/documentation/articles/sql-database-service-tiers/).
	RequestedServiceObjectiveName interface{}
	// The name of the resource group in which to create the database.  This must be the same as Database Server resource group currently.
	ResourceGroupName interface{}
	// The point in time for the restore. Only applies if `createMode` is `PointInTimeRestore` e.g. 2013-11-08T22:00:40Z
	RestorePointInTime interface{}
	// The name of the SQL Server on which to create the database.
	ServerName interface{}
	// The deletion date time of the source database. Only applies to deleted databases where `createMode` is `PointInTimeRestore`.
	SourceDatabaseDeletionDate interface{}
	// The URI of the source database if `createMode` value is not `Default`.
	SourceDatabaseId interface{}
	// A mapping of tags to assign to the resource.
	Tags interface{}
	// Threat detection policy configuration. The `threatDetectionPolicy` block supports fields documented below.
	ThreatDetectionPolicy interface{}
}

Input properties used for looking up and filtering Database resources.

type ElasticPool 

type ElasticPool struct {
	// contains filtered or unexported fields
}

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 mssql.ElasticPool version instead.

> This content is derived from https://github.com/terraform-providers/terraform-provider-azurerm/blob/master/website/docs/r/sql_elasticpool.html.markdown.

func GetElasticPool 

func GetElasticPool(ctx *pulumi.Context,
	name string, id pulumi.ID, state *ElasticPoolState, opts ...pulumi.ResourceOpt) (*ElasticPool, error)

GetElasticPool gets an existing ElasticPool resource's state with the given name, ID, and optional state properties that are used to uniquely qualify the lookup (nil if not required).

func NewElasticPool 

func NewElasticPool(ctx *pulumi.Context,
	name string, args *ElasticPoolArgs, opts ...pulumi.ResourceOpt) (*ElasticPool, error)

NewElasticPool registers a new resource with the given unique name, arguments, and options.

func (*ElasticPool) CreationDate 

func (r *ElasticPool) CreationDate() pulumi.StringOutput

The creation date of the SQL Elastic Pool.

func (*ElasticPool) DbDtuMax 

func (r *ElasticPool) DbDtuMax() pulumi.IntOutput

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

func (*ElasticPool) DbDtuMin 

func (r *ElasticPool) DbDtuMin() pulumi.IntOutput

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

func (*ElasticPool) Dtu 

func (r *ElasticPool) Dtu() pulumi.IntOutput

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](https://docs.microsoft.com/en-gb/azure/sql-database/sql-database-service-tiers#elastic-pool-service-tiers-and-performance-in-edtus) for valid combinations.

func (*ElasticPool) Edition 

func (r *ElasticPool) Edition() pulumi.StringOutput

The edition of the elastic pool to be created. Valid values are `Basic`, `Standard`, and `Premium`. Refer to [Azure SQL Database Service Tiers](https://docs.microsoft.com/en-gb/azure/sql-database/sql-database-service-tiers#elastic-pool-service-tiers-and-performance-in-edtus) for details. Changing this forces a new resource to be created.

func (*ElasticPool) ID 

func (r *ElasticPool) ID() pulumi.IDOutput

ID is this resource's unique identifier assigned by its provider.

func (*ElasticPool) Location 

func (r *ElasticPool) Location() pulumi.StringOutput

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

func (*ElasticPool) Name 

func (r *ElasticPool) Name() pulumi.StringOutput

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

func (*ElasticPool) PoolSize 

func (r *ElasticPool) PoolSize() pulumi.IntOutput

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](https://docs.microsoft.com/en-gb/azure/sql-database/sql-database-service-tiers#elastic-pool-service-tiers-and-performance-in-edtus). If not defined when creating an elastic pool, the value is set to the size implied by `edition` and `dtu`.

func (*ElasticPool) ResourceGroupName 

func (r *ElasticPool) ResourceGroupName() pulumi.StringOutput

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.

func (*ElasticPool) ServerName 

func (r *ElasticPool) ServerName() pulumi.StringOutput

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

func (*ElasticPool) Tags 

func (r *ElasticPool) Tags() pulumi.MapOutput

A mapping of tags to assign to the resource.

func (*ElasticPool) URN 

func (r *ElasticPool) URN() pulumi.URNOutput

URN is this resource's unique name assigned by Pulumi.

type ElasticPoolArgs 

type ElasticPoolArgs struct {
	// The maximum DTU which will be guaranteed to all databases in the elastic pool to be created.
	DbDtuMax interface{}
	// The minimum DTU which will be guaranteed to all databases in the elastic pool to be created.
	DbDtuMin interface{}
	// 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](https://docs.microsoft.com/en-gb/azure/sql-database/sql-database-service-tiers#elastic-pool-service-tiers-and-performance-in-edtus) for valid combinations.
	Dtu interface{}
	// The edition of the elastic pool to be created. Valid values are `Basic`, `Standard`, and `Premium`. Refer to [Azure SQL Database Service Tiers](https://docs.microsoft.com/en-gb/azure/sql-database/sql-database-service-tiers#elastic-pool-service-tiers-and-performance-in-edtus) for details. Changing this forces a new resource to be created.
	Edition interface{}
	// Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
	Location interface{}
	// The name of the elastic pool. This needs to be globally unique. Changing this forces a new resource to be created.
	Name interface{}
	// 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](https://docs.microsoft.com/en-gb/azure/sql-database/sql-database-service-tiers#elastic-pool-service-tiers-and-performance-in-edtus). If not defined when creating an elastic pool, the value is set to the size implied by `edition` and `dtu`.
	PoolSize interface{}
	// 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.
	ResourceGroupName interface{}
	// The name of the SQL Server on which to create the elastic pool. Changing this forces a new resource to be created.
	ServerName interface{}
	// A mapping of tags to assign to the resource.
	Tags interface{}
}

The set of arguments for constructing a ElasticPool resource.

type ElasticPoolState 

type ElasticPoolState struct {
	// The creation date of the SQL Elastic Pool.
	CreationDate interface{}
	// The maximum DTU which will be guaranteed to all databases in the elastic pool to be created.
	DbDtuMax interface{}
	// The minimum DTU which will be guaranteed to all databases in the elastic pool to be created.
	DbDtuMin interface{}
	// 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](https://docs.microsoft.com/en-gb/azure/sql-database/sql-database-service-tiers#elastic-pool-service-tiers-and-performance-in-edtus) for valid combinations.
	Dtu interface{}
	// The edition of the elastic pool to be created. Valid values are `Basic`, `Standard`, and `Premium`. Refer to [Azure SQL Database Service Tiers](https://docs.microsoft.com/en-gb/azure/sql-database/sql-database-service-tiers#elastic-pool-service-tiers-and-performance-in-edtus) for details. Changing this forces a new resource to be created.
	Edition interface{}
	// Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
	Location interface{}
	// The name of the elastic pool. This needs to be globally unique. Changing this forces a new resource to be created.
	Name interface{}
	// 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](https://docs.microsoft.com/en-gb/azure/sql-database/sql-database-service-tiers#elastic-pool-service-tiers-and-performance-in-edtus). If not defined when creating an elastic pool, the value is set to the size implied by `edition` and `dtu`.
	PoolSize interface{}
	// 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.
	ResourceGroupName interface{}
	// The name of the SQL Server on which to create the elastic pool. Changing this forces a new resource to be created.
	ServerName interface{}
	// A mapping of tags to assign to the resource.
	Tags interface{}
}

Input properties used for looking up and filtering ElasticPool resources.

type FailoverGroup added in v1.0.0 

type FailoverGroup struct {
	// contains filtered or unexported fields
}

Create a failover group of databases on a collection of Azure SQL servers.

> This content is derived from https://github.com/terraform-providers/terraform-provider-azurerm/blob/master/website/docs/r/sql_failover_group.html.markdown.

func GetFailoverGroup added in v1.0.0 

func GetFailoverGroup(ctx *pulumi.Context,
	name string, id pulumi.ID, state *FailoverGroupState, opts ...pulumi.ResourceOpt) (*FailoverGroup, error)

GetFailoverGroup gets an existing FailoverGroup resource's state with the given name, ID, and optional state properties that are used to uniquely qualify the lookup (nil if not required).

func NewFailoverGroup added in v1.0.0 

func NewFailoverGroup(ctx *pulumi.Context,
	name string, args *FailoverGroupArgs, opts ...pulumi.ResourceOpt) (*FailoverGroup, error)

NewFailoverGroup registers a new resource with the given unique name, arguments, and options.

func (*FailoverGroup) Databases added in v1.0.0 

func (r *FailoverGroup) Databases() pulumi.ArrayOutput

A list of database ids to add to the failover group

func (*FailoverGroup) ID added in v1.0.0 

func (r *FailoverGroup) ID() pulumi.IDOutput

ID is this resource's unique identifier assigned by its provider.

func (*FailoverGroup) Location added in v1.0.0 

func (r *FailoverGroup) Location() pulumi.StringOutput

the location of the failover group.

func (*FailoverGroup) Name added in v1.0.0 

func (r *FailoverGroup) Name() pulumi.StringOutput

The name of the failover group. Changing this forces a new resource to be created.

func (*FailoverGroup) PartnerServers added in v1.0.0 

func (r *FailoverGroup) PartnerServers() pulumi.ArrayOutput

A list of secondary servers as documented below

func (*FailoverGroup) ReadWriteEndpointFailoverPolicy added in v1.0.0 

func (r *FailoverGroup) ReadWriteEndpointFailoverPolicy() pulumi.Output

A read/write policy as documented below

func (*FailoverGroup) ReadonlyEndpointFailoverPolicy added in v1.0.0 

func (r *FailoverGroup) ReadonlyEndpointFailoverPolicy() pulumi.Output

a read-only policy as documented below

func (*FailoverGroup) ResourceGroupName added in v1.0.0 

func (r *FailoverGroup) ResourceGroupName() pulumi.StringOutput

The name of the resource group containing the SQL server

func (*FailoverGroup) Role added in v1.0.0 

func (r *FailoverGroup) Role() pulumi.StringOutput

local replication role of the failover group instance.

func (*FailoverGroup) ServerName added in v1.0.0 

func (r *FailoverGroup) ServerName() pulumi.StringOutput

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

func (*FailoverGroup) Tags added in v1.0.0 

func (r *FailoverGroup) Tags() pulumi.MapOutput

A mapping of tags to assign to the resource.

func (*FailoverGroup) URN added in v1.0.0 

func (r *FailoverGroup) URN() pulumi.URNOutput

URN is this resource's unique name assigned by Pulumi.

type FailoverGroupArgs added in v1.0.0 

type FailoverGroupArgs struct {
	// A list of database ids to add to the failover group
	Databases interface{}
	// The name of the failover group. Changing this forces a new resource to be created.
	Name interface{}
	// A list of secondary servers as documented below
	PartnerServers interface{}
	// A read/write policy as documented below
	ReadWriteEndpointFailoverPolicy interface{}
	// a read-only policy as documented below
	ReadonlyEndpointFailoverPolicy interface{}
	// The name of the resource group containing the SQL server
	ResourceGroupName interface{}
	// The name of the primary SQL server. Changing this forces a new resource to be created.
	ServerName interface{}
	// A mapping of tags to assign to the resource.
	Tags interface{}
}

The set of arguments for constructing a FailoverGroup resource.

type FailoverGroupState added in v1.0.0 

type FailoverGroupState struct {
	// A list of database ids to add to the failover group
	Databases interface{}
	// the location of the failover group.
	Location interface{}
	// The name of the failover group. Changing this forces a new resource to be created.
	Name interface{}
	// A list of secondary servers as documented below
	PartnerServers interface{}
	// A read/write policy as documented below
	ReadWriteEndpointFailoverPolicy interface{}
	// a read-only policy as documented below
	ReadonlyEndpointFailoverPolicy interface{}
	// The name of the resource group containing the SQL server
	ResourceGroupName interface{}
	// local replication role of the failover group instance.
	Role interface{}
	// The name of the primary SQL server. Changing this forces a new resource to be created.
	ServerName interface{}
	// A mapping of tags to assign to the resource.
	Tags interface{}
}

Input properties used for looking up and filtering FailoverGroup resources.

type FirewallRule 

type FirewallRule struct {
	// contains filtered or unexported fields
}

Allows you to manage an Azure SQL Firewall Rule

> This content is derived from https://github.com/terraform-providers/terraform-provider-azurerm/blob/master/website/docs/r/sql_firewall_rule.html.markdown.

func GetFirewallRule 

func GetFirewallRule(ctx *pulumi.Context,
	name string, id pulumi.ID, state *FirewallRuleState, opts ...pulumi.ResourceOpt) (*FirewallRule, error)

GetFirewallRule gets an existing FirewallRule resource's state with the given name, ID, and optional state properties that are used to uniquely qualify the lookup (nil if not required).

func NewFirewallRule 

func NewFirewallRule(ctx *pulumi.Context,
	name string, args *FirewallRuleArgs, opts ...pulumi.ResourceOpt) (*FirewallRule, error)

NewFirewallRule registers a new resource with the given unique name, arguments, and options.

func (*FirewallRule) EndIpAddress 

func (r *FirewallRule) EndIpAddress() pulumi.StringOutput

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

func (*FirewallRule) ID 

func (r *FirewallRule) ID() pulumi.IDOutput

ID is this resource's unique identifier assigned by its provider.

func (*FirewallRule) Name 

func (r *FirewallRule) Name() pulumi.StringOutput

The name of the firewall rule.

func (*FirewallRule) ResourceGroupName 

func (r *FirewallRule) ResourceGroupName() pulumi.StringOutput

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

func (*FirewallRule) ServerName 

func (r *FirewallRule) ServerName() pulumi.StringOutput

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

func (*FirewallRule) StartIpAddress 

func (r *FirewallRule) StartIpAddress() pulumi.StringOutput

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

func (*FirewallRule) URN 

func (r *FirewallRule) URN() pulumi.URNOutput

URN is this resource's unique name assigned by Pulumi.

type FirewallRuleArgs 

type FirewallRuleArgs struct {
	// The ending IP address to allow through the firewall for this rule.
	EndIpAddress interface{}
	// The name of the firewall rule.
	Name interface{}
	// The name of the resource group in which to
	// create the sql server.
	ResourceGroupName interface{}
	// The name of the SQL Server on which to create the Firewall Rule.
	ServerName interface{}
	// The starting IP address to allow through the firewall for this rule.
	StartIpAddress interface{}
}

The set of arguments for constructing a FirewallRule resource.

type FirewallRuleState 

type FirewallRuleState struct {
	// The ending IP address to allow through the firewall for this rule.
	EndIpAddress interface{}
	// The name of the firewall rule.
	Name interface{}
	// The name of the resource group in which to
	// create the sql server.
	ResourceGroupName interface{}
	// The name of the SQL Server on which to create the Firewall Rule.
	ServerName interface{}
	// The starting IP address to allow through the firewall for this rule.
	StartIpAddress interface{}
}

Input properties used for looking up and filtering FirewallRule resources.

type GetDatabaseArgs added in v1.1.0 

type GetDatabaseArgs struct {
	// The name of the SQL Database.
	Name interface{}
	// Specifies the name of the Resource Group where the Azure SQL Database exists.
	ResourceGroupName interface{}
	// The name of the SQL Server.
	ServerName interface{}
	Tags       interface{}
}

A collection of arguments for invoking getDatabase.

type GetDatabaseResult added in v1.1.0 

type GetDatabaseResult struct {
	// The name of the collation.
	Collation interface{}
	// The default secondary location of the SQL Database.
	DefaultSecondaryLocation interface{}
	// The edition of the database.
	Edition interface{}
	// The name of the elastic database pool the database belongs to.
	ElasticPoolName interface{}
	// The ID of the failover group the database belongs to.
	FailoverGroupId interface{}
	// The location of the Resource Group in which the SQL Server exists.
	Location interface{}
	// The name of the database.
	Name interface{}
	// Indicate if read-only connections will be redirected to a high-available replica.
	ReadScale interface{}
	// The name of the resource group in which the database resides. This will always be the same resource group as the Database Server.
	ResourceGroupName interface{}
	// The name of the SQL Server on which to create the database.
	ServerName interface{}
	// A mapping of tags assigned to the resource.
	Tags interface{}
	// id is the provider-assigned unique ID for this managed resource.
	Id interface{}
}

A collection of values returned by getDatabase.

func LookupDatabase added in v1.1.0 

func LookupDatabase(ctx *pulumi.Context, args *GetDatabaseArgs) (*GetDatabaseResult, error)

Use this data source to access information about an existing SQL Azure Database.

> This content is derived from https://github.com/terraform-providers/terraform-provider-azurerm/blob/master/website/docs/d/sql_database.html.markdown.

type GetServerArgs added in v0.18.6 

type GetServerArgs struct {
	// The name of the SQL Server.
	Name interface{}
	// Specifies the name of the Resource Group where the SQL Server exists.
	ResourceGroupName interface{}
}

A collection of arguments for invoking getServer.

type GetServerResult added in v0.18.6 

type GetServerResult struct {
	// The administrator username of the SQL Server.
	AdministratorLogin interface{}
	// The fully qualified domain name of the SQL Server.
	Fqdn interface{}
	// An `identity` block as defined below.
	Identities interface{}
	// The location of the Resource Group in which the SQL Server exists.
	Location          interface{}
	Name              interface{}
	ResourceGroupName interface{}
	// A mapping of tags assigned to the resource.
	Tags interface{}
	// The version of the SQL Server.
	Version interface{}
	// id is the provider-assigned unique ID for this managed resource.
	Id interface{}
}

A collection of values returned by getServer.

func LookupServer added in v0.18.6 

func LookupServer(ctx *pulumi.Context, args *GetServerArgs) (*GetServerResult, error)

Use this data source to access information about an existing SQL Azure Database Server.

> This content is derived from https://github.com/terraform-providers/terraform-provider-azurerm/blob/master/website/docs/d/sql_server.html.markdown.

type SqlServer 

type SqlServer struct {
	// contains filtered or unexported fields
}

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](https://www.terraform.io/docs/state/sensitive-data.html).

> This content is derived from https://github.com/terraform-providers/terraform-provider-azurerm/blob/master/website/docs/r/sql_server.html.markdown.

func GetSqlServer 

func GetSqlServer(ctx *pulumi.Context,
	name string, id pulumi.ID, state *SqlServerState, opts ...pulumi.ResourceOpt) (*SqlServer, error)

GetSqlServer gets an existing SqlServer resource's state with the given name, ID, and optional state properties that are used to uniquely qualify the lookup (nil if not required).

func NewSqlServer 

func NewSqlServer(ctx *pulumi.Context,
	name string, args *SqlServerArgs, opts ...pulumi.ResourceOpt) (*SqlServer, error)

NewSqlServer registers a new resource with the given unique name, arguments, and options.

func (*SqlServer) AdministratorLogin 

func (r *SqlServer) AdministratorLogin() pulumi.StringOutput

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

func (*SqlServer) AdministratorLoginPassword 

func (r *SqlServer) AdministratorLoginPassword() pulumi.StringOutput

The password associated with the `administratorLogin` user. Needs to comply with Azure's [Password Policy](https://msdn.microsoft.com/library/ms161959.aspx)

func (*SqlServer) FullyQualifiedDomainName 

func (r *SqlServer) FullyQualifiedDomainName() pulumi.StringOutput

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

func (*SqlServer) ID 

func (r *SqlServer) ID() pulumi.IDOutput

ID is this resource's unique identifier assigned by its provider.

func (*SqlServer) Identity added in v1.5.0 

func (r *SqlServer) Identity() pulumi.Output

An `identity` block as defined below.

func (*SqlServer) Location 

func (r *SqlServer) Location() pulumi.StringOutput

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

func (*SqlServer) Name 

func (r *SqlServer) Name() pulumi.StringOutput

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

func (*SqlServer) ResourceGroupName 

func (r *SqlServer) ResourceGroupName() pulumi.StringOutput

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

func (*SqlServer) Tags 

func (r *SqlServer) Tags() pulumi.MapOutput

A mapping of tags to assign to the resource.

func (*SqlServer) URN 

func (r *SqlServer) URN() pulumi.URNOutput

URN is this resource's unique name assigned by Pulumi.

func (*SqlServer) Version 

func (r *SqlServer) Version() pulumi.StringOutput

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

type SqlServerArgs 

type SqlServerArgs struct {
	// The administrator login name for the new server. Changing this forces a new resource to be created.
	AdministratorLogin interface{}
	// The password associated with the `administratorLogin` user. Needs to comply with Azure's [Password Policy](https://msdn.microsoft.com/library/ms161959.aspx)
	AdministratorLoginPassword interface{}
	// An `identity` block as defined below.
	Identity interface{}
	// Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
	Location interface{}
	// The name of the SQL Server. This needs to be globally unique within Azure.
	Name interface{}
	// The name of the resource group in which to create the SQL Server.
	ResourceGroupName interface{}
	// A mapping of tags to assign to the resource.
	Tags interface{}
	// The version for the new server. Valid values are: 2.0 (for v11 server) and 12.0 (for v12 server).
	Version interface{}
}

The set of arguments for constructing a SqlServer resource.

type SqlServerState 

type SqlServerState struct {
	// The administrator login name for the new server. Changing this forces a new resource to be created.
	AdministratorLogin interface{}
	// The password associated with the `administratorLogin` user. Needs to comply with Azure's [Password Policy](https://msdn.microsoft.com/library/ms161959.aspx)
	AdministratorLoginPassword interface{}
	// The fully qualified domain name of the Azure SQL Server (e.g. myServerName.database.windows.net)
	FullyQualifiedDomainName interface{}
	// An `identity` block as defined below.
	Identity interface{}
	// Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
	Location interface{}
	// The name of the SQL Server. This needs to be globally unique within Azure.
	Name interface{}
	// The name of the resource group in which to create the SQL Server.
	ResourceGroupName interface{}
	// A mapping of tags to assign to the resource.
	Tags interface{}
	// The version for the new server. Valid values are: 2.0 (for v11 server) and 12.0 (for v12 server).
	Version interface{}
}

Input properties used for looking up and filtering SqlServer resources.

type VirtualNetworkRule 

type VirtualNetworkRule struct {
	// contains filtered or unexported fields
}

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

> This content is derived from https://github.com/terraform-providers/terraform-provider-azurerm/blob/master/website/docs/r/sql_virtual_network_rule.html.markdown.

func GetVirtualNetworkRule 

func GetVirtualNetworkRule(ctx *pulumi.Context,
	name string, id pulumi.ID, state *VirtualNetworkRuleState, opts ...pulumi.ResourceOpt) (*VirtualNetworkRule, error)

GetVirtualNetworkRule gets an existing VirtualNetworkRule resource's state with the given name, ID, and optional state properties that are used to uniquely qualify the lookup (nil if not required).

func NewVirtualNetworkRule 

func NewVirtualNetworkRule(ctx *pulumi.Context,
	name string, args *VirtualNetworkRuleArgs, opts ...pulumi.ResourceOpt) (*VirtualNetworkRule, error)

NewVirtualNetworkRule registers a new resource with the given unique name, arguments, and options.

func (*VirtualNetworkRule) ID 

func (r *VirtualNetworkRule) ID() pulumi.IDOutput

ID is this resource's unique identifier assigned by its provider.

func (*VirtualNetworkRule) IgnoreMissingVnetServiceEndpoint 

func (r *VirtualNetworkRule) IgnoreMissingVnetServiceEndpoint() pulumi.BoolOutput

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

func (*VirtualNetworkRule) Name 

func (r *VirtualNetworkRule) Name() pulumi.StringOutput

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.

func (*VirtualNetworkRule) ResourceGroupName 

func (r *VirtualNetworkRule) ResourceGroupName() pulumi.StringOutput

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

func (*VirtualNetworkRule) ServerName 

func (r *VirtualNetworkRule) ServerName() pulumi.StringOutput

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.

func (*VirtualNetworkRule) SubnetId 

func (r *VirtualNetworkRule) SubnetId() pulumi.StringOutput

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

func (*VirtualNetworkRule) URN 

func (r *VirtualNetworkRule) URN() pulumi.URNOutput

URN is this resource's unique name assigned by Pulumi.

type VirtualNetworkRuleArgs 

type VirtualNetworkRuleArgs struct {
	// Create the virtual network rule before the subnet has the virtual network service endpoint enabled. The default value is false.
	IgnoreMissingVnetServiceEndpoint interface{}
	// 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.
	Name interface{}
	// The name of the resource group where the SQL server resides. Changing this forces a new resource to be created.
	ResourceGroupName interface{}
	// 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.
	ServerName interface{}
	// The ID of the subnet that the SQL server will be connected to.
	SubnetId interface{}
}

The set of arguments for constructing a VirtualNetworkRule resource.

type VirtualNetworkRuleState 

type VirtualNetworkRuleState struct {
	// Create the virtual network rule before the subnet has the virtual network service endpoint enabled. The default value is false.
	IgnoreMissingVnetServiceEndpoint interface{}
	// 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.
	Name interface{}
	// The name of the resource group where the SQL server resides. Changing this forces a new resource to be created.
	ResourceGroupName interface{}
	// 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.
	ServerName interface{}
	// The ID of the subnet that the SQL server will be connected to.
	SubnetId interface{}
}

Input properties used for looking up and filtering VirtualNetworkRule resources.

Source Files

View all Source files

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL
go.dev uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. Learn more.