Namespace Pulumi.Azure.Sql

Classes

ActiveDirectoryAdministrator

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

Example Usage

using Pulumi;
using Azure = Pulumi.Azure;

class MyStack : Stack
{
public MyStack()
{
    var current = Output.Create(Azure.Core.GetClientConfig.InvokeAsync());
    var exampleResourceGroup = new Azure.Core.ResourceGroup("exampleResourceGroup", new Azure.Core.ResourceGroupArgs
    {
        Location = "West US",
    });
    var exampleSqlServer = new Azure.Sql.SqlServer("exampleSqlServer", new Azure.Sql.SqlServerArgs
    {
        ResourceGroupName = exampleResourceGroup.Name,
        Location = exampleResourceGroup.Location,
        Version = "12.0",
        AdministratorLogin = "4dm1n157r470r",
        AdministratorLoginPassword = "4-v3ry-53cr37-p455w0rd",
    });
    var exampleActiveDirectoryAdministrator = new Azure.Sql.ActiveDirectoryAdministrator("exampleActiveDirectoryAdministrator", new Azure.Sql.ActiveDirectoryAdministratorArgs
    {
        ServerName = exampleSqlServer.Name,
        ResourceGroupName = exampleResourceGroup.Name,
        Login = "sqladmin",
        TenantId = current.Apply(current => current.TenantId),
        ObjectId = current.Apply(current => current.ObjectId),
    });
}

}

ActiveDirectoryAdministratorArgs

ActiveDirectoryAdministratorState

Database

Allows you to manage an Azure SQL Database

DatabaseArgs

DatabaseState

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

Example Usage

using Pulumi;
using Azure = Pulumi.Azure;

class MyStack : Stack
{
public MyStack()
{
    var exampleResourceGroup = new Azure.Core.ResourceGroup("exampleResourceGroup", new Azure.Core.ResourceGroupArgs
    {
        Location = "West US",
    });
    var exampleSqlServer = new Azure.Sql.SqlServer("exampleSqlServer", new Azure.Sql.SqlServerArgs
    {
        ResourceGroupName = exampleResourceGroup.Name,
        Location = exampleResourceGroup.Location,
        Version = "12.0",
        AdministratorLogin = "4dm1n157r470r",
        AdministratorLoginPassword = "4-v3ry-53cr37-p455w0rd",
    });
    var exampleElasticPool = new Azure.Sql.ElasticPool("exampleElasticPool", new Azure.Sql.ElasticPoolArgs
    {
        ResourceGroupName = exampleResourceGroup.Name,
        Location = exampleResourceGroup.Location,
        ServerName = exampleSqlServer.Name,
        Edition = "Basic",
        Dtu = 50,
        DbDtuMin = 0,
        DbDtuMax = 5,
        PoolSize = 5000,
    });
}

}

ElasticPoolArgs

ElasticPoolState

FailoverGroup

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

FailoverGroupArgs

FailoverGroupState

FirewallRule

Allows you to manage an Azure SQL Firewall Rule

Example Usage

using Pulumi;
using Azure = Pulumi.Azure;

class MyStack : Stack
{
public MyStack()
{
    var exampleResourceGroup = new Azure.Core.ResourceGroup("exampleResourceGroup", new Azure.Core.ResourceGroupArgs
    {
        Location = "West US",
    });
    var exampleSqlServer = new Azure.Sql.SqlServer("exampleSqlServer", new Azure.Sql.SqlServerArgs
    {
        ResourceGroupName = exampleResourceGroup.Name,
        Location = "West US",
        Version = "12.0",
        AdministratorLogin = "4dm1n157r470r",
        AdministratorLoginPassword = "4-v3ry-53cr37-p455w0rd",
    });
    var exampleFirewallRule = new Azure.Sql.FirewallRule("exampleFirewallRule", new Azure.Sql.FirewallRuleArgs
    {
        ResourceGroupName = exampleResourceGroup.Name,
        ServerName = exampleSqlServer.Name,
        StartIpAddress = "10.0.17.62",
        EndIpAddress = "10.0.17.62",
    });
}

}

FirewallRuleArgs

FirewallRuleState

GetDatabase

GetDatabaseArgs

GetDatabaseResult

GetServer

GetServerArgs

GetServerResult

SqlServer

Manages a Microsoft SQL Azure Database Server.

SqlServerArgs

SqlServerState

VirtualNetworkRule

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

Example Usage

using Pulumi;
using Azure = Pulumi.Azure;

class MyStack : Stack
{
public MyStack()
{
    var example = new Azure.Core.ResourceGroup("example", new Azure.Core.ResourceGroupArgs
    {
        Location = "West US",
    });
    var vnet = new Azure.Network.VirtualNetwork("vnet", new Azure.Network.VirtualNetworkArgs
    {
        AddressSpaces = 
        {
            "10.7.29.0/29",
        },
        Location = example.Location,
        ResourceGroupName = example.Name,
    });
    var subnet = new Azure.Network.Subnet("subnet", new Azure.Network.SubnetArgs
    {
        ResourceGroupName = example.Name,
        VirtualNetworkName = vnet.Name,
        AddressPrefix = "10.7.29.0/29",
        ServiceEndpoints = 
        {
            "Microsoft.Sql",
        },
    });
    var sqlserver = new Azure.Sql.SqlServer("sqlserver", new Azure.Sql.SqlServerArgs
    {
        ResourceGroupName = example.Name,
        Location = example.Location,
        Version = "12.0",
        AdministratorLogin = "4dm1n157r470r",
        AdministratorLoginPassword = "4-v3ry-53cr37-p455w0rd",
    });
    var sqlvnetrule = new Azure.Sql.VirtualNetworkRule("sqlvnetrule", new Azure.Sql.VirtualNetworkRuleArgs
    {
        ResourceGroupName = example.Name,
        ServerName = sqlserver.Name,
        SubnetId = subnet.Id,
    });
}

}

VirtualNetworkRuleArgs

VirtualNetworkRuleState