azure.sql.FailoverGroup

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

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

    var primary = new Azure.Sql.SqlServer("primary", new()
    {
        ResourceGroupName = exampleResourceGroup.Name,
        Location = exampleResourceGroup.Location,
        Version = "12.0",
        AdministratorLogin = "sqladmin",
        AdministratorLoginPassword = "pa$$w0rd",
    });

    var secondary = new Azure.Sql.SqlServer("secondary", new()
    {
        ResourceGroupName = exampleResourceGroup.Name,
        Location = exampleResourceGroup.Location,
        Version = "12.0",
        AdministratorLogin = "sqladmin",
        AdministratorLoginPassword = "pa$$w0rd",
    });

    var db1 = new Azure.Sql.Database("db1", new()
    {
        ResourceGroupName = primary.ResourceGroupName,
        Location = primary.Location,
        ServerName = primary.Name,
    });

    var exampleFailoverGroup = new Azure.Sql.FailoverGroup("exampleFailoverGroup", new()
    {
        ResourceGroupName = primary.ResourceGroupName,
        ServerName = primary.Name,
        Databases = new[]
        {
            db1.Id,
        },
        PartnerServers = new[]
        {
            new Azure.Sql.Inputs.FailoverGroupPartnerServerArgs
            {
                Id = secondary.Id,
            },
        },
        ReadWriteEndpointFailoverPolicy = new Azure.Sql.Inputs.FailoverGroupReadWriteEndpointFailoverPolicyArgs
        {
            Mode = "Automatic",
            GraceMinutes = 60,
        },
    });

});

package main

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

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		exampleResourceGroup, err := core.NewResourceGroup(ctx, "exampleResourceGroup", &core.ResourceGroupArgs{
			Location: pulumi.String("West Europe"),
		})
		if err != nil {
			return err
		}
		primary, err := sql.NewSqlServer(ctx, "primary", &sql.SqlServerArgs{
			ResourceGroupName:          exampleResourceGroup.Name,
			Location:                   exampleResourceGroup.Location,
			Version:                    pulumi.String("12.0"),
			AdministratorLogin:         pulumi.String("sqladmin"),
			AdministratorLoginPassword: pulumi.String("pa$$w0rd"),
		})
		if err != nil {
			return err
		}
		secondary, err := sql.NewSqlServer(ctx, "secondary", &sql.SqlServerArgs{
			ResourceGroupName:          exampleResourceGroup.Name,
			Location:                   exampleResourceGroup.Location,
			Version:                    pulumi.String("12.0"),
			AdministratorLogin:         pulumi.String("sqladmin"),
			AdministratorLoginPassword: pulumi.String("pa$$w0rd"),
		})
		if err != nil {
			return err
		}
		db1, err := sql.NewDatabase(ctx, "db1", &sql.DatabaseArgs{
			ResourceGroupName: primary.ResourceGroupName,
			Location:          primary.Location,
			ServerName:        primary.Name,
		})
		if err != nil {
			return err
		}
		_, err = sql.NewFailoverGroup(ctx, "exampleFailoverGroup", &sql.FailoverGroupArgs{
			ResourceGroupName: primary.ResourceGroupName,
			ServerName:        primary.Name,
			Databases: pulumi.StringArray{
				db1.ID(),
			},
			PartnerServers: sql.FailoverGroupPartnerServerArray{
				&sql.FailoverGroupPartnerServerArgs{
					Id: secondary.ID(),
				},
			},
			ReadWriteEndpointFailoverPolicy: &sql.FailoverGroupReadWriteEndpointFailoverPolicyArgs{
				Mode:         pulumi.String("Automatic"),
				GraceMinutes: pulumi.Int(60),
			},
		})
		if err != nil {
			return err
		}
		return nil
	})
}

package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.azure.core.ResourceGroup;
import com.pulumi.azure.core.ResourceGroupArgs;
import com.pulumi.azure.sql.SqlServer;
import com.pulumi.azure.sql.SqlServerArgs;
import com.pulumi.azure.sql.Database;
import com.pulumi.azure.sql.DatabaseArgs;
import com.pulumi.azure.sql.FailoverGroup;
import com.pulumi.azure.sql.FailoverGroupArgs;
import com.pulumi.azure.sql.inputs.FailoverGroupPartnerServerArgs;
import com.pulumi.azure.sql.inputs.FailoverGroupReadWriteEndpointFailoverPolicyArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;

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

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

        var primary = new SqlServer("primary", SqlServerArgs.builder()        
            .resourceGroupName(exampleResourceGroup.name())
            .location(exampleResourceGroup.location())
            .version("12.0")
            .administratorLogin("sqladmin")
            .administratorLoginPassword("pa$$w0rd")
            .build());

        var secondary = new SqlServer("secondary", SqlServerArgs.builder()        
            .resourceGroupName(exampleResourceGroup.name())
            .location(exampleResourceGroup.location())
            .version("12.0")
            .administratorLogin("sqladmin")
            .administratorLoginPassword("pa$$w0rd")
            .build());

        var db1 = new Database("db1", DatabaseArgs.builder()        
            .resourceGroupName(primary.resourceGroupName())
            .location(primary.location())
            .serverName(primary.name())
            .build());

        var exampleFailoverGroup = new FailoverGroup("exampleFailoverGroup", FailoverGroupArgs.builder()        
            .resourceGroupName(primary.resourceGroupName())
            .serverName(primary.name())
            .databases(db1.id())
            .partnerServers(FailoverGroupPartnerServerArgs.builder()
                .id(secondary.id())
                .build())
            .readWriteEndpointFailoverPolicy(FailoverGroupReadWriteEndpointFailoverPolicyArgs.builder()
                .mode("Automatic")
                .graceMinutes(60)
                .build())
            .build());

    }
}

import pulumi
import pulumi_azure as azure

example_resource_group = azure.core.ResourceGroup("exampleResourceGroup", location="West Europe")
primary = azure.sql.SqlServer("primary",
    resource_group_name=example_resource_group.name,
    location=example_resource_group.location,
    version="12.0",
    administrator_login="sqladmin",
    administrator_login_password="pa$$w0rd")
secondary = azure.sql.SqlServer("secondary",
    resource_group_name=example_resource_group.name,
    location=example_resource_group.location,
    version="12.0",
    administrator_login="sqladmin",
    administrator_login_password="pa$$w0rd")
db1 = azure.sql.Database("db1",
    resource_group_name=primary.resource_group_name,
    location=primary.location,
    server_name=primary.name)
example_failover_group = azure.sql.FailoverGroup("exampleFailoverGroup",
    resource_group_name=primary.resource_group_name,
    server_name=primary.name,
    databases=[db1.id],
    partner_servers=[azure.sql.FailoverGroupPartnerServerArgs(
        id=secondary.id,
    )],
    read_write_endpoint_failover_policy=azure.sql.FailoverGroupReadWriteEndpointFailoverPolicyArgs(
        mode="Automatic",
        grace_minutes=60,
    ))

import * as pulumi from "@pulumi/pulumi";
import * as azure from "@pulumi/azure";

const exampleResourceGroup = new azure.core.ResourceGroup("exampleResourceGroup", {location: "West Europe"});
const primary = new azure.sql.SqlServer("primary", {
    resourceGroupName: exampleResourceGroup.name,
    location: exampleResourceGroup.location,
    version: "12.0",
    administratorLogin: "sqladmin",
    administratorLoginPassword: "pa$$w0rd",
});
const secondary = new azure.sql.SqlServer("secondary", {
    resourceGroupName: exampleResourceGroup.name,
    location: exampleResourceGroup.location,
    version: "12.0",
    administratorLogin: "sqladmin",
    administratorLoginPassword: "pa$$w0rd",
});
const db1 = new azure.sql.Database("db1", {
    resourceGroupName: primary.resourceGroupName,
    location: primary.location,
    serverName: primary.name,
});
const exampleFailoverGroup = new azure.sql.FailoverGroup("exampleFailoverGroup", {
    resourceGroupName: primary.resourceGroupName,
    serverName: primary.name,
    databases: [db1.id],
    partnerServers: [{
        id: secondary.id,
    }],
    readWriteEndpointFailoverPolicy: {
        mode: "Automatic",
        graceMinutes: 60,
    },
});

resources:
  exampleResourceGroup:
    type: azure:core:ResourceGroup
    properties:
      location: West Europe
  primary:
    type: azure:sql:SqlServer
    properties:
      resourceGroupName: ${exampleResourceGroup.name}
      location: ${exampleResourceGroup.location}
      version: '12.0'
      administratorLogin: sqladmin
      administratorLoginPassword: pa$$w0rd
  secondary:
    type: azure:sql:SqlServer
    properties:
      resourceGroupName: ${exampleResourceGroup.name}
      location: ${exampleResourceGroup.location}
      version: '12.0'
      administratorLogin: sqladmin
      administratorLoginPassword: pa$$w0rd
  db1:
    type: azure:sql:Database
    properties:
      resourceGroupName: ${primary.resourceGroupName}
      location: ${primary.location}
      serverName: ${primary.name}
  exampleFailoverGroup:
    type: azure:sql:FailoverGroup
    properties:
      resourceGroupName: ${primary.resourceGroupName}
      serverName: ${primary.name}
      databases:
        - ${db1.id}
      partnerServers:
        - id: ${secondary.id}
      readWriteEndpointFailoverPolicy:
        mode: Automatic
        graceMinutes: 60