pulumi-azure-kotlin/com.pulumi.azure.sql.kotlin/ManagedDatabaseArgs

ManagedDatabaseArgs

data class ManagedDatabaseArgs(val location: Output<String>? = null, val name: Output<String>? = null, val sqlManagedInstanceId: Output<String>? = null) : ConvertibleToJava<ManagedDatabaseArgs>

Example Usage

import * as pulumi from "@pulumi/pulumi";
import * as azure from "@pulumi/azure";
const example = new azure.core.ResourceGroup("example", {
    name: "rg-example",
    location: "West Europe",
});
const exampleVirtualNetwork = new azure.network.VirtualNetwork("example", {
    name: "test-network",
    addressSpaces: ["10&#46;0&#46;0&#46;0/16"],
    location: example.location,
    resourceGroupName: example.name,
});
const exampleSubnet = new azure.network.Subnet("example", {
    name: "acctsub",
    resourceGroupName: example.name,
    virtualNetworkName: exampleVirtualNetwork.name,
    addressPrefixes: ["10&#46;0&#46;2&#46;0/24"],
});
const exampleManagedInstance = new azure.sql.ManagedInstance("example", {
    name: "example",
    resourceGroupName: example.name,
    location: example.location,
    administratorLogin: "mradministrator",
    administratorLoginPassword: "thisIsDog11",
    licenseType: "BasePrice",
    subnetId: exampleSubnet.id,
    skuName: "GP_Gen5",
    vcores: 4,
    storageSizeInGb: 32,
});
const exampleManagedDatabase = new azure.sql.ManagedDatabase("example", {
    sqlManagedInstanceId: exampleManagedInstance.id,
    name: "exampledatabase",
    location: example.location,
});

import pulumi
import pulumi_azure as azure
example = azure.core.ResourceGroup("example",
    name="rg-example",
    location="West Europe")
example_virtual_network = azure.network.VirtualNetwork("example",
    name="test-network",
    address_spaces=["10&#46;0&#46;0&#46;0/16"],
    location=example.location,
    resource_group_name=example.name)
example_subnet = azure.network.Subnet("example",
    name="acctsub",
    resource_group_name=example.name,
    virtual_network_name=example_virtual_network.name,
    address_prefixes=["10&#46;0&#46;2&#46;0/24"])
example_managed_instance = azure.sql.ManagedInstance("example",
    name="example",
    resource_group_name=example.name,
    location=example.location,
    administrator_login="mradministrator",
    administrator_login_password="thisIsDog11",
    license_type="BasePrice",
    subnet_id=example_subnet.id,
    sku_name="GP_Gen5",
    vcores=4,
    storage_size_in_gb=32)
example_managed_database = azure.sql.ManagedDatabase("example",
    sql_managed_instance_id=example_managed_instance.id,
    name="exampledatabase",
    location=example.location)

using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Azure = Pulumi.Azure;
return await Deployment.RunAsync(() =>
{
    var example = new Azure.Core.ResourceGroup("example", new()
    {
        Name = "rg-example",
        Location = "West Europe",
    });
    var exampleVirtualNetwork = new Azure.Network.VirtualNetwork("example", new()
    {
        Name = "test-network",
        AddressSpaces = new[]
        {
            "10.0.0.0/16",
        },
        Location = example.Location,
        ResourceGroupName = example.Name,
    });
    var exampleSubnet = new Azure.Network.Subnet("example", new()
    {
        Name = "acctsub",
        ResourceGroupName = example.Name,
        VirtualNetworkName = exampleVirtualNetwork.Name,
        AddressPrefixes = new[]
        {
            "10.0.2.0/24",
        },
    });
    var exampleManagedInstance = new Azure.Sql.ManagedInstance("example", new()
    {
        Name = "example",
        ResourceGroupName = example.Name,
        Location = example.Location,
        AdministratorLogin = "mradministrator",
        AdministratorLoginPassword = "thisIsDog11",
        LicenseType = "BasePrice",
        SubnetId = exampleSubnet.Id,
        SkuName = "GP_Gen5",
        Vcores = 4,
        StorageSizeInGb = 32,
    });
    var exampleManagedDatabase = new Azure.Sql.ManagedDatabase("example", new()
    {
        SqlManagedInstanceId = exampleManagedInstance.Id,
        Name = "exampledatabase",
        Location = example.Location,
    });
});

package main
import (
	"github.com/pulumi/pulumi-azure/sdk/v5/go/azure/core"
	"github.com/pulumi/pulumi-azure/sdk/v5/go/azure/network"
	"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 {
		example, err := core.NewResourceGroup(ctx, "example", &core.ResourceGroupArgs{
			Name:     pulumi.String("rg-example"),
			Location: pulumi.String("West Europe"),
		})
		if err != nil {
			return err
		}
		exampleVirtualNetwork, err := network.NewVirtualNetwork(ctx, "example", &network.VirtualNetworkArgs{
			Name: pulumi.String("test-network"),
			AddressSpaces: pulumi.StringArray{
				pulumi.String("10.0.0.0/16"),
			},
			Location:          example.Location,
			ResourceGroupName: example.Name,
		})
		if err != nil {
			return err
		}
		exampleSubnet, err := network.NewSubnet(ctx, "example", &network.SubnetArgs{
			Name:               pulumi.String("acctsub"),
			ResourceGroupName:  example.Name,
			VirtualNetworkName: exampleVirtualNetwork.Name,
			AddressPrefixes: pulumi.StringArray{
				pulumi.String("10.0.2.0/24"),
			},
		})
		if err != nil {
			return err
		}
		exampleManagedInstance, err := sql.NewManagedInstance(ctx, "example", &sql.ManagedInstanceArgs{
			Name:                       pulumi.String("example"),
			ResourceGroupName:          example.Name,
			Location:                   example.Location,
			AdministratorLogin:         pulumi.String("mradministrator"),
			AdministratorLoginPassword: pulumi.String("thisIsDog11"),
			LicenseType:                pulumi.String("BasePrice"),
			SubnetId:                   exampleSubnet.ID(),
			SkuName:                    pulumi.String("GP_Gen5"),
			Vcores:                     pulumi.Int(4),
			StorageSizeInGb:            pulumi.Int(32),
		})
		if err != nil {
			return err
		}
		_, err = sql.NewManagedDatabase(ctx, "example", &sql.ManagedDatabaseArgs{
			SqlManagedInstanceId: exampleManagedInstance.ID(),
			Name:                 pulumi.String("exampledatabase"),
			Location:             example.Location,
		})
		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.network.VirtualNetwork;
import com.pulumi.azure.network.VirtualNetworkArgs;
import com.pulumi.azure.network.Subnet;
import com.pulumi.azure.network.SubnetArgs;
import com.pulumi.azure.sql.ManagedInstance;
import com.pulumi.azure.sql.ManagedInstanceArgs;
import com.pulumi.azure.sql.ManagedDatabase;
import com.pulumi.azure.sql.ManagedDatabaseArgs;
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 example = new ResourceGroup("example", ResourceGroupArgs.builder()
            .name("rg-example")
            .location("West Europe")
            .build());
        var exampleVirtualNetwork = new VirtualNetwork("exampleVirtualNetwork", VirtualNetworkArgs.builder()
            .name("test-network")
            .addressSpaces("10.0.0.0/16")
            .location(example.location())
            .resourceGroupName(example.name())
            .build());
        var exampleSubnet = new Subnet("exampleSubnet", SubnetArgs.builder()
            .name("acctsub")
            .resourceGroupName(example.name())
            .virtualNetworkName(exampleVirtualNetwork.name())
            .addressPrefixes("10.0.2.0/24")
            .build());
        var exampleManagedInstance = new ManagedInstance("exampleManagedInstance", ManagedInstanceArgs.builder()
            .name("example")
            .resourceGroupName(example.name())
            .location(example.location())
            .administratorLogin("mradministrator")
            .administratorLoginPassword("thisIsDog11")
            .licenseType("BasePrice")
            .subnetId(exampleSubnet.id())
            .skuName("GP_Gen5")
            .vcores(4)
            .storageSizeInGb(32)
            .build());
        var exampleManagedDatabase = new ManagedDatabase("exampleManagedDatabase", ManagedDatabaseArgs.builder()
            .sqlManagedInstanceId(exampleManagedInstance.id())
            .name("exampledatabase")
            .location(example.location())
            .build());
    }
}

resources:
  example:
    type: azure:core:ResourceGroup
    properties:
      name: rg-example
      location: West Europe
  exampleVirtualNetwork:
    type: azure:network:VirtualNetwork
    name: example
    properties:
      name: test-network
      addressSpaces:
        - 10.0.0.0/16
      location: ${example.location}
      resourceGroupName: ${example.name}
  exampleSubnet:
    type: azure:network:Subnet
    name: example
    properties:
      name: acctsub
      resourceGroupName: ${example.name}
      virtualNetworkName: ${exampleVirtualNetwork.name}
      addressPrefixes:
        - 10.0.2.0/24
  exampleManagedInstance:
    type: azure:sql:ManagedInstance
    name: example
    properties:
      name: example
      resourceGroupName: ${example.name}
      location: ${example.location}
      administratorLogin: mradministrator
      administratorLoginPassword: thisIsDog11
      licenseType: BasePrice
      subnetId: ${exampleSubnet.id}
      skuName: GP_Gen5
      vcores: 4
      storageSizeInGb: 32
  exampleManagedDatabase:
    type: azure:sql:ManagedDatabase
    name: example
    properties:
      sqlManagedInstanceId: ${exampleManagedInstance.id}
      name: exampledatabase
      location: ${example.location}

Import

SQL Managed Databases can be imported using the resource id, e.g.

$ pulumi import azure:sql/managedDatabase:ManagedDatabase example /subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/myresourcegroup/providers/Microsoft.Sql/managedInstances/myserver/databases/mydatabase

Constructors

ManagedDatabaseArgs

constructor(location: Output<String>? = null, name: Output<String>? = null, sqlManagedInstanceId: Output<String>? = null)

Properties

location

val location: Output<String>? = null

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

name

val name: Output<String>? = null

The name of the SQL Managed Database. Changing this forces a new resource to be created.

sqlManagedInstanceId

val sqlManagedInstanceId: Output<String>? = null

The SQL Managed Instance ID that this Managed Database will be associated with. Changing this forces a new resource to be created.

Functions

toJava

open override fun toJava(): ManagedDatabaseArgs