Azure Native v3.2.0, Apr 14 25

This is the latest version of Azure Native. Use the Azure Native v2 docs if using the v2 version of this package.

Azure Native v3.2.0 published on Monday, Apr 14, 2025 by Pulumi

azure-native.sql.ManagedDatabase

Explore with Pulumi AI

This is the latest version of Azure Native. Use the Azure Native v2 docs if using the v2 version of this package.

Azure Native v3.2.0 published on Monday, Apr 14, 2025 by Pulumi

pulumi/pulumi-azure-native

Example Usage
Creates a new managed database by restoring from an external backup
Creates a new managed database by restoring from an external backup using managed identity
Creates a new managed database from restoring a geo-replicated backup
Creates a new managed database from restoring a long term retention backup
Creates a new managed database using cross subscription point in time restore
Creates a new managed database using point in time restore
Creates a new managed database with ledger on.
Creates a new managed database with maximal properties
Creates a new managed database with minimal properties
Create ManagedDatabase Resource
Constructor syntax
Constructor example
ManagedDatabase Resource Properties
Inputs
Outputs
Supporting Types
Import
Package Details

Related Resources

web.WebApp

resources.ResourceGroup

sql.ManagedInstance

Request a Change

A managed database resource.

Uses Azure REST API version 2023-08-01. In version 2.x of the Azure Native provider, it used API version 2021-11-01.

Other available API versions: 2017-03-01-preview, 2018-06-01-preview, 2019-06-01-preview, 2020-02-02-preview, 2020-08-01-preview, 2020-11-01-preview, 2021-02-01-preview, 2021-05-01-preview, 2021-08-01-preview, 2021-11-01, 2021-11-01-preview, 2022-02-01-preview, 2022-05-01-preview, 2022-08-01-preview, 2022-11-01-preview, 2023-02-01-preview, 2023-05-01-preview, 2023-08-01-preview, 2024-05-01-preview. These can be accessed by generating a local SDK package using the CLI command pulumi package add azure-native sql [ApiVersion]. See the version guide for details.

Creates a new managed database by restoring from an external backup

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

return await Deployment.RunAsync(() => 
{
    var managedDatabase = new AzureNative.Sql.ManagedDatabase("managedDatabase", new()
    {
        AutoCompleteRestore = true,
        Collation = "SQL_Latin1_General_CP1_CI_AS",
        CreateMode = AzureNative.Sql.ManagedDatabaseCreateMode.RestoreExternalBackup,
        DatabaseName = "managedDatabase",
        LastBackupName = "last_backup_name",
        Location = "southeastasia",
        ManagedInstanceName = "managedInstance",
        ResourceGroupName = "Default-SQL-SouthEastAsia",
        StorageContainerSasToken = "sv=2015-12-11&sr=c&sp=rl&sig=1234",
        StorageContainerUri = "https://myaccountname.blob.core.windows.net/backups",
    });

});

package main

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

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := sql.NewManagedDatabase(ctx, "managedDatabase", &sql.ManagedDatabaseArgs{
			AutoCompleteRestore:      pulumi.Bool(true),
			Collation:                pulumi.String("SQL_Latin1_General_CP1_CI_AS"),
			CreateMode:               pulumi.String(sql.ManagedDatabaseCreateModeRestoreExternalBackup),
			DatabaseName:             pulumi.String("managedDatabase"),
			LastBackupName:           pulumi.String("last_backup_name"),
			Location:                 pulumi.String("southeastasia"),
			ManagedInstanceName:      pulumi.String("managedInstance"),
			ResourceGroupName:        pulumi.String("Default-SQL-SouthEastAsia"),
			StorageContainerSasToken: pulumi.String("sv=2015-12-11&sr=c&sp=rl&sig=1234"),
			StorageContainerUri:      pulumi.String("https://myaccountname.blob.core.windows.net/backups"),
		})
		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.azurenative.sql.ManagedDatabase;
import com.pulumi.azurenative.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 managedDatabase = new ManagedDatabase("managedDatabase", ManagedDatabaseArgs.builder()
            .autoCompleteRestore(true)
            .collation("SQL_Latin1_General_CP1_CI_AS")
            .createMode("RestoreExternalBackup")
            .databaseName("managedDatabase")
            .lastBackupName("last_backup_name")
            .location("southeastasia")
            .managedInstanceName("managedInstance")
            .resourceGroupName("Default-SQL-SouthEastAsia")
            .storageContainerSasToken("sv=2015-12-11&sr=c&sp=rl&sig=1234")
            .storageContainerUri("https://myaccountname.blob.core.windows.net/backups")
            .build());

    }
}

import * as pulumi from "@pulumi/pulumi";
import * as azure_native from "@pulumi/azure-native";

const managedDatabase = new azure_native.sql.ManagedDatabase("managedDatabase", {
    autoCompleteRestore: true,
    collation: "SQL_Latin1_General_CP1_CI_AS",
    createMode: azure_native.sql.ManagedDatabaseCreateMode.RestoreExternalBackup,
    databaseName: "managedDatabase",
    lastBackupName: "last_backup_name",
    location: "southeastasia",
    managedInstanceName: "managedInstance",
    resourceGroupName: "Default-SQL-SouthEastAsia",
    storageContainerSasToken: "sv=2015-12-11&sr=c&sp=rl&sig=1234",
    storageContainerUri: "https://myaccountname.blob.core.windows.net/backups",
});

import pulumi
import pulumi_azure_native as azure_native

managed_database = azure_native.sql.ManagedDatabase("managedDatabase",
    auto_complete_restore=True,
    collation="SQL_Latin1_General_CP1_CI_AS",
    create_mode=azure_native.sql.ManagedDatabaseCreateMode.RESTORE_EXTERNAL_BACKUP,
    database_name="managedDatabase",
    last_backup_name="last_backup_name",
    location="southeastasia",
    managed_instance_name="managedInstance",
    resource_group_name="Default-SQL-SouthEastAsia",
    storage_container_sas_token="sv=2015-12-11&sr=c&sp=rl&sig=1234",
    storage_container_uri="https://myaccountname.blob.core.windows.net/backups")

resources:
  managedDatabase:
    type: azure-native:sql:ManagedDatabase
    properties:
      autoCompleteRestore: true
      collation: SQL_Latin1_General_CP1_CI_AS
      createMode: RestoreExternalBackup
      databaseName: managedDatabase
      lastBackupName: last_backup_name
      location: southeastasia
      managedInstanceName: managedInstance
      resourceGroupName: Default-SQL-SouthEastAsia
      storageContainerSasToken: sv=2015-12-11&sr=c&sp=rl&sig=1234
      storageContainerUri: https://myaccountname.blob.core.windows.net/backups

Creates a new managed database by restoring from an external backup using managed identity

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

return await Deployment.RunAsync(() => 
{
    var managedDatabase = new AzureNative.Sql.ManagedDatabase("managedDatabase", new()
    {
        AutoCompleteRestore = true,
        Collation = "SQL_Latin1_General_CP1_CI_AS",
        CreateMode = AzureNative.Sql.ManagedDatabaseCreateMode.RestoreExternalBackup,
        DatabaseName = "managedDatabase",
        LastBackupName = "last_backup_name",
        Location = "southeastasia",
        ManagedInstanceName = "managedInstance",
        ResourceGroupName = "Default-SQL-SouthEastAsia",
        StorageContainerIdentity = "ManagedIdentity",
        StorageContainerUri = "https://myaccountname.blob.core.windows.net/backups",
    });

});

package main

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

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := sql.NewManagedDatabase(ctx, "managedDatabase", &sql.ManagedDatabaseArgs{
			AutoCompleteRestore:      pulumi.Bool(true),
			Collation:                pulumi.String("SQL_Latin1_General_CP1_CI_AS"),
			CreateMode:               pulumi.String(sql.ManagedDatabaseCreateModeRestoreExternalBackup),
			DatabaseName:             pulumi.String("managedDatabase"),
			LastBackupName:           pulumi.String("last_backup_name"),
			Location:                 pulumi.String("southeastasia"),
			ManagedInstanceName:      pulumi.String("managedInstance"),
			ResourceGroupName:        pulumi.String("Default-SQL-SouthEastAsia"),
			StorageContainerIdentity: pulumi.String("ManagedIdentity"),
			StorageContainerUri:      pulumi.String("https://myaccountname.blob.core.windows.net/backups"),
		})
		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.azurenative.sql.ManagedDatabase;
import com.pulumi.azurenative.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 managedDatabase = new ManagedDatabase("managedDatabase", ManagedDatabaseArgs.builder()
            .autoCompleteRestore(true)
            .collation("SQL_Latin1_General_CP1_CI_AS")
            .createMode("RestoreExternalBackup")
            .databaseName("managedDatabase")
            .lastBackupName("last_backup_name")
            .location("southeastasia")
            .managedInstanceName("managedInstance")
            .resourceGroupName("Default-SQL-SouthEastAsia")
            .storageContainerIdentity("ManagedIdentity")
            .storageContainerUri("https://myaccountname.blob.core.windows.net/backups")
            .build());

    }
}

import * as pulumi from "@pulumi/pulumi";
import * as azure_native from "@pulumi/azure-native";

const managedDatabase = new azure_native.sql.ManagedDatabase("managedDatabase", {
    autoCompleteRestore: true,
    collation: "SQL_Latin1_General_CP1_CI_AS",
    createMode: azure_native.sql.ManagedDatabaseCreateMode.RestoreExternalBackup,
    databaseName: "managedDatabase",
    lastBackupName: "last_backup_name",
    location: "southeastasia",
    managedInstanceName: "managedInstance",
    resourceGroupName: "Default-SQL-SouthEastAsia",
    storageContainerIdentity: "ManagedIdentity",
    storageContainerUri: "https://myaccountname.blob.core.windows.net/backups",
});

import pulumi
import pulumi_azure_native as azure_native

managed_database = azure_native.sql.ManagedDatabase("managedDatabase",
    auto_complete_restore=True,
    collation="SQL_Latin1_General_CP1_CI_AS",
    create_mode=azure_native.sql.ManagedDatabaseCreateMode.RESTORE_EXTERNAL_BACKUP,
    database_name="managedDatabase",
    last_backup_name="last_backup_name",
    location="southeastasia",
    managed_instance_name="managedInstance",
    resource_group_name="Default-SQL-SouthEastAsia",
    storage_container_identity="ManagedIdentity",
    storage_container_uri="https://myaccountname.blob.core.windows.net/backups")

resources:
  managedDatabase:
    type: azure-native:sql:ManagedDatabase
    properties:
      autoCompleteRestore: true
      collation: SQL_Latin1_General_CP1_CI_AS
      createMode: RestoreExternalBackup
      databaseName: managedDatabase
      lastBackupName: last_backup_name
      location: southeastasia
      managedInstanceName: managedInstance
      resourceGroupName: Default-SQL-SouthEastAsia
      storageContainerIdentity: ManagedIdentity
      storageContainerUri: https://myaccountname.blob.core.windows.net/backups

Creates a new managed database from restoring a geo-replicated backup

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

return await Deployment.RunAsync(() => 
{
    var managedDatabase = new AzureNative.Sql.ManagedDatabase("managedDatabase", new()
    {
        CreateMode = AzureNative.Sql.ManagedDatabaseCreateMode.Recovery,
        DatabaseName = "testdb_recovered",
        Location = "southeastasia",
        ManagedInstanceName = "server1",
        RecoverableDatabaseId = "/subscriptions/11111111-2222-3333-4444-555555555555/resourceGroups/Default-SQL-WestEurope/providers/Microsoft.Sql/managedInstances/testsvr/recoverableDatabases/testdb",
        ResourceGroupName = "Default-SQL-SouthEastAsia",
    });

});

package main

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

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := sql.NewManagedDatabase(ctx, "managedDatabase", &sql.ManagedDatabaseArgs{
			CreateMode:            pulumi.String(sql.ManagedDatabaseCreateModeRecovery),
			DatabaseName:          pulumi.String("testdb_recovered"),
			Location:              pulumi.String("southeastasia"),
			ManagedInstanceName:   pulumi.String("server1"),
			RecoverableDatabaseId: pulumi.String("/subscriptions/11111111-2222-3333-4444-555555555555/resourceGroups/Default-SQL-WestEurope/providers/Microsoft.Sql/managedInstances/testsvr/recoverableDatabases/testdb"),
			ResourceGroupName:     pulumi.String("Default-SQL-SouthEastAsia"),
		})
		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.azurenative.sql.ManagedDatabase;
import com.pulumi.azurenative.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 managedDatabase = new ManagedDatabase("managedDatabase", ManagedDatabaseArgs.builder()
            .createMode("Recovery")
            .databaseName("testdb_recovered")
            .location("southeastasia")
            .managedInstanceName("server1")
            .recoverableDatabaseId("/subscriptions/11111111-2222-3333-4444-555555555555/resourceGroups/Default-SQL-WestEurope/providers/Microsoft.Sql/managedInstances/testsvr/recoverableDatabases/testdb")
            .resourceGroupName("Default-SQL-SouthEastAsia")
            .build());

    }
}

import * as pulumi from "@pulumi/pulumi";
import * as azure_native from "@pulumi/azure-native";

const managedDatabase = new azure_native.sql.ManagedDatabase("managedDatabase", {
    createMode: azure_native.sql.ManagedDatabaseCreateMode.Recovery,
    databaseName: "testdb_recovered",
    location: "southeastasia",
    managedInstanceName: "server1",
    recoverableDatabaseId: "/subscriptions/11111111-2222-3333-4444-555555555555/resourceGroups/Default-SQL-WestEurope/providers/Microsoft.Sql/managedInstances/testsvr/recoverableDatabases/testdb",
    resourceGroupName: "Default-SQL-SouthEastAsia",
});

import pulumi
import pulumi_azure_native as azure_native

managed_database = azure_native.sql.ManagedDatabase("managedDatabase",
    create_mode=azure_native.sql.ManagedDatabaseCreateMode.RECOVERY,
    database_name="testdb_recovered",
    location="southeastasia",
    managed_instance_name="server1",
    recoverable_database_id="/subscriptions/11111111-2222-3333-4444-555555555555/resourceGroups/Default-SQL-WestEurope/providers/Microsoft.Sql/managedInstances/testsvr/recoverableDatabases/testdb",
    resource_group_name="Default-SQL-SouthEastAsia")

resources:
  managedDatabase:
    type: azure-native:sql:ManagedDatabase
    properties:
      createMode: Recovery
      databaseName: testdb_recovered
      location: southeastasia
      managedInstanceName: server1
      recoverableDatabaseId: /subscriptions/11111111-2222-3333-4444-555555555555/resourceGroups/Default-SQL-WestEurope/providers/Microsoft.Sql/managedInstances/testsvr/recoverableDatabases/testdb
      resourceGroupName: Default-SQL-SouthEastAsia

Creates a new managed database from restoring a long term retention backup

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

return await Deployment.RunAsync(() => 
{
    var managedDatabase = new AzureNative.Sql.ManagedDatabase("managedDatabase", new()
    {
        Collation = "SQL_Latin1_General_CP1_CI_AS",
        CreateMode = AzureNative.Sql.ManagedDatabaseCreateMode.RestoreExternalBackup,
        DatabaseName = "managedDatabase",
        Location = "southeastasia",
        ManagedInstanceName = "managedInstance",
        ResourceGroupName = "Default-SQL-SouthEastAsia",
        StorageContainerSasToken = "sv=2015-12-11&sr=c&sp=rl&sig=1234",
        StorageContainerUri = "https://myaccountname.blob.core.windows.net/backups",
    });

});

package main

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

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := sql.NewManagedDatabase(ctx, "managedDatabase", &sql.ManagedDatabaseArgs{
			Collation:                pulumi.String("SQL_Latin1_General_CP1_CI_AS"),
			CreateMode:               pulumi.String(sql.ManagedDatabaseCreateModeRestoreExternalBackup),
			DatabaseName:             pulumi.String("managedDatabase"),
			Location:                 pulumi.String("southeastasia"),
			ManagedInstanceName:      pulumi.String("managedInstance"),
			ResourceGroupName:        pulumi.String("Default-SQL-SouthEastAsia"),
			StorageContainerSasToken: pulumi.String("sv=2015-12-11&sr=c&sp=rl&sig=1234"),
			StorageContainerUri:      pulumi.String("https://myaccountname.blob.core.windows.net/backups"),
		})
		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.azurenative.sql.ManagedDatabase;
import com.pulumi.azurenative.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 managedDatabase = new ManagedDatabase("managedDatabase", ManagedDatabaseArgs.builder()
            .collation("SQL_Latin1_General_CP1_CI_AS")
            .createMode("RestoreExternalBackup")
            .databaseName("managedDatabase")
            .location("southeastasia")
            .managedInstanceName("managedInstance")
            .resourceGroupName("Default-SQL-SouthEastAsia")
            .storageContainerSasToken("sv=2015-12-11&sr=c&sp=rl&sig=1234")
            .storageContainerUri("https://myaccountname.blob.core.windows.net/backups")
            .build());

    }
}

import * as pulumi from "@pulumi/pulumi";
import * as azure_native from "@pulumi/azure-native";

const managedDatabase = new azure_native.sql.ManagedDatabase("managedDatabase", {
    collation: "SQL_Latin1_General_CP1_CI_AS",
    createMode: azure_native.sql.ManagedDatabaseCreateMode.RestoreExternalBackup,
    databaseName: "managedDatabase",
    location: "southeastasia",
    managedInstanceName: "managedInstance",
    resourceGroupName: "Default-SQL-SouthEastAsia",
    storageContainerSasToken: "sv=2015-12-11&sr=c&sp=rl&sig=1234",
    storageContainerUri: "https://myaccountname.blob.core.windows.net/backups",
});

import pulumi
import pulumi_azure_native as azure_native

managed_database = azure_native.sql.ManagedDatabase("managedDatabase",
    collation="SQL_Latin1_General_CP1_CI_AS",
    create_mode=azure_native.sql.ManagedDatabaseCreateMode.RESTORE_EXTERNAL_BACKUP,
    database_name="managedDatabase",
    location="southeastasia",
    managed_instance_name="managedInstance",
    resource_group_name="Default-SQL-SouthEastAsia",
    storage_container_sas_token="sv=2015-12-11&sr=c&sp=rl&sig=1234",
    storage_container_uri="https://myaccountname.blob.core.windows.net/backups")

resources:
  managedDatabase:
    type: azure-native:sql:ManagedDatabase
    properties:
      collation: SQL_Latin1_General_CP1_CI_AS
      createMode: RestoreExternalBackup
      databaseName: managedDatabase
      location: southeastasia
      managedInstanceName: managedInstance
      resourceGroupName: Default-SQL-SouthEastAsia
      storageContainerSasToken: sv=2015-12-11&sr=c&sp=rl&sig=1234
      storageContainerUri: https://myaccountname.blob.core.windows.net/backups

Creates a new managed database using cross subscription point in time restore

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

return await Deployment.RunAsync(() => 
{
    var managedDatabase = new AzureNative.Sql.ManagedDatabase("managedDatabase", new()
    {
        CreateMode = AzureNative.Sql.ManagedDatabaseCreateMode.PointInTimeRestore,
        CrossSubscriptionSourceDatabaseId = "/subscriptions/11111111-2222-3333-4444-555555555555/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/managedInstances/testsvr2/databases/testdb",
        CrossSubscriptionTargetManagedInstanceId = "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/managedInstances/testsvr",
        DatabaseName = "managedDatabase",
        Location = "southeastasia",
        ManagedInstanceName = "managedInstance",
        ResourceGroupName = "Default-SQL-SouthEastAsia",
        RestorePointInTime = "2017-07-14T05:35:31.503Z",
    });

});

package main

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

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := sql.NewManagedDatabase(ctx, "managedDatabase", &sql.ManagedDatabaseArgs{
			CreateMode:                               pulumi.String(sql.ManagedDatabaseCreateModePointInTimeRestore),
			CrossSubscriptionSourceDatabaseId:        pulumi.String("/subscriptions/11111111-2222-3333-4444-555555555555/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/managedInstances/testsvr2/databases/testdb"),
			CrossSubscriptionTargetManagedInstanceId: pulumi.String("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/managedInstances/testsvr"),
			DatabaseName:                             pulumi.String("managedDatabase"),
			Location:                                 pulumi.String("southeastasia"),
			ManagedInstanceName:                      pulumi.String("managedInstance"),
			ResourceGroupName:                        pulumi.String("Default-SQL-SouthEastAsia"),
			RestorePointInTime:                       pulumi.String("2017-07-14T05:35:31.503Z"),
		})
		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.azurenative.sql.ManagedDatabase;
import com.pulumi.azurenative.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 managedDatabase = new ManagedDatabase("managedDatabase", ManagedDatabaseArgs.builder()
            .createMode("PointInTimeRestore")
            .crossSubscriptionSourceDatabaseId("/subscriptions/11111111-2222-3333-4444-555555555555/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/managedInstances/testsvr2/databases/testdb")
            .crossSubscriptionTargetManagedInstanceId("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/managedInstances/testsvr")
            .databaseName("managedDatabase")
            .location("southeastasia")
            .managedInstanceName("managedInstance")
            .resourceGroupName("Default-SQL-SouthEastAsia")
            .restorePointInTime("2017-07-14T05:35:31.503Z")
            .build());

    }
}

import * as pulumi from "@pulumi/pulumi";
import * as azure_native from "@pulumi/azure-native";

const managedDatabase = new azure_native.sql.ManagedDatabase("managedDatabase", {
    createMode: azure_native.sql.ManagedDatabaseCreateMode.PointInTimeRestore,
    crossSubscriptionSourceDatabaseId: "/subscriptions/11111111-2222-3333-4444-555555555555/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/managedInstances/testsvr2/databases/testdb",
    crossSubscriptionTargetManagedInstanceId: "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/managedInstances/testsvr",
    databaseName: "managedDatabase",
    location: "southeastasia",
    managedInstanceName: "managedInstance",
    resourceGroupName: "Default-SQL-SouthEastAsia",
    restorePointInTime: "2017-07-14T05:35:31.503Z",
});

import pulumi
import pulumi_azure_native as azure_native

managed_database = azure_native.sql.ManagedDatabase("managedDatabase",
    create_mode=azure_native.sql.ManagedDatabaseCreateMode.POINT_IN_TIME_RESTORE,
    cross_subscription_source_database_id="/subscriptions/11111111-2222-3333-4444-555555555555/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/managedInstances/testsvr2/databases/testdb",
    cross_subscription_target_managed_instance_id="/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/managedInstances/testsvr",
    database_name="managedDatabase",
    location="southeastasia",
    managed_instance_name="managedInstance",
    resource_group_name="Default-SQL-SouthEastAsia",
    restore_point_in_time="2017-07-14T05:35:31.503Z")

resources:
  managedDatabase:
    type: azure-native:sql:ManagedDatabase
    properties:
      createMode: PointInTimeRestore
      crossSubscriptionSourceDatabaseId: /subscriptions/11111111-2222-3333-4444-555555555555/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/managedInstances/testsvr2/databases/testdb
      crossSubscriptionTargetManagedInstanceId: /subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/managedInstances/testsvr
      databaseName: managedDatabase
      location: southeastasia
      managedInstanceName: managedInstance
      resourceGroupName: Default-SQL-SouthEastAsia
      restorePointInTime: 2017-07-14T05:35:31.503Z

Creates a new managed database using point in time restore

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

return await Deployment.RunAsync(() => 
{
    var managedDatabase = new AzureNative.Sql.ManagedDatabase("managedDatabase", new()
    {
        CreateMode = AzureNative.Sql.ManagedDatabaseCreateMode.PointInTimeRestore,
        DatabaseName = "managedDatabase",
        Location = "southeastasia",
        ManagedInstanceName = "managedInstance",
        ResourceGroupName = "Default-SQL-SouthEastAsia",
        RestorePointInTime = "2017-07-14T05:35:31.503Z",
        SourceDatabaseId = "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/managedInstances/testsvr/databases/testdb",
    });

});

package main

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

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := sql.NewManagedDatabase(ctx, "managedDatabase", &sql.ManagedDatabaseArgs{
			CreateMode:          pulumi.String(sql.ManagedDatabaseCreateModePointInTimeRestore),
			DatabaseName:        pulumi.String("managedDatabase"),
			Location:            pulumi.String("southeastasia"),
			ManagedInstanceName: pulumi.String("managedInstance"),
			ResourceGroupName:   pulumi.String("Default-SQL-SouthEastAsia"),
			RestorePointInTime:  pulumi.String("2017-07-14T05:35:31.503Z"),
			SourceDatabaseId:    pulumi.String("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/managedInstances/testsvr/databases/testdb"),
		})
		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.azurenative.sql.ManagedDatabase;
import com.pulumi.azurenative.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 managedDatabase = new ManagedDatabase("managedDatabase", ManagedDatabaseArgs.builder()
            .createMode("PointInTimeRestore")
            .databaseName("managedDatabase")
            .location("southeastasia")
            .managedInstanceName("managedInstance")
            .resourceGroupName("Default-SQL-SouthEastAsia")
            .restorePointInTime("2017-07-14T05:35:31.503Z")
            .sourceDatabaseId("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/managedInstances/testsvr/databases/testdb")
            .build());

    }
}

import * as pulumi from "@pulumi/pulumi";
import * as azure_native from "@pulumi/azure-native";

const managedDatabase = new azure_native.sql.ManagedDatabase("managedDatabase", {
    createMode: azure_native.sql.ManagedDatabaseCreateMode.PointInTimeRestore,
    databaseName: "managedDatabase",
    location: "southeastasia",
    managedInstanceName: "managedInstance",
    resourceGroupName: "Default-SQL-SouthEastAsia",
    restorePointInTime: "2017-07-14T05:35:31.503Z",
    sourceDatabaseId: "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/managedInstances/testsvr/databases/testdb",
});

import pulumi
import pulumi_azure_native as azure_native

managed_database = azure_native.sql.ManagedDatabase("managedDatabase",
    create_mode=azure_native.sql.ManagedDatabaseCreateMode.POINT_IN_TIME_RESTORE,
    database_name="managedDatabase",
    location="southeastasia",
    managed_instance_name="managedInstance",
    resource_group_name="Default-SQL-SouthEastAsia",
    restore_point_in_time="2017-07-14T05:35:31.503Z",
    source_database_id="/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/managedInstances/testsvr/databases/testdb")

resources:
  managedDatabase:
    type: azure-native:sql:ManagedDatabase
    properties:
      createMode: PointInTimeRestore
      databaseName: managedDatabase
      location: southeastasia
      managedInstanceName: managedInstance
      resourceGroupName: Default-SQL-SouthEastAsia
      restorePointInTime: 2017-07-14T05:35:31.503Z
      sourceDatabaseId: /subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/managedInstances/testsvr/databases/testdb

Creates a new managed database with ledger on.

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

return await Deployment.RunAsync(() => 
{
    var managedDatabase = new AzureNative.Sql.ManagedDatabase("managedDatabase", new()
    {
        DatabaseName = "managedDatabase",
        IsLedgerOn = true,
        Location = "southeastasia",
        ManagedInstanceName = "managedInstance",
        ResourceGroupName = "Default-SQL-SouthEastAsia",
    });

});

package main

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

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := sql.NewManagedDatabase(ctx, "managedDatabase", &sql.ManagedDatabaseArgs{
			DatabaseName:        pulumi.String("managedDatabase"),
			IsLedgerOn:          pulumi.Bool(true),
			Location:            pulumi.String("southeastasia"),
			ManagedInstanceName: pulumi.String("managedInstance"),
			ResourceGroupName:   pulumi.String("Default-SQL-SouthEastAsia"),
		})
		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.azurenative.sql.ManagedDatabase;
import com.pulumi.azurenative.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 managedDatabase = new ManagedDatabase("managedDatabase", ManagedDatabaseArgs.builder()
            .databaseName("managedDatabase")
            .isLedgerOn(true)
            .location("southeastasia")
            .managedInstanceName("managedInstance")
            .resourceGroupName("Default-SQL-SouthEastAsia")
            .build());

    }
}

import * as pulumi from "@pulumi/pulumi";
import * as azure_native from "@pulumi/azure-native";

const managedDatabase = new azure_native.sql.ManagedDatabase("managedDatabase", {
    databaseName: "managedDatabase",
    isLedgerOn: true,
    location: "southeastasia",
    managedInstanceName: "managedInstance",
    resourceGroupName: "Default-SQL-SouthEastAsia",
});

import pulumi
import pulumi_azure_native as azure_native

managed_database = azure_native.sql.ManagedDatabase("managedDatabase",
    database_name="managedDatabase",
    is_ledger_on=True,
    location="southeastasia",
    managed_instance_name="managedInstance",
    resource_group_name="Default-SQL-SouthEastAsia")

resources:
  managedDatabase:
    type: azure-native:sql:ManagedDatabase
    properties:
      databaseName: managedDatabase
      isLedgerOn: true
      location: southeastasia
      managedInstanceName: managedInstance
      resourceGroupName: Default-SQL-SouthEastAsia

Creates a new managed database with maximal properties

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

return await Deployment.RunAsync(() => 
{
    var managedDatabase = new AzureNative.Sql.ManagedDatabase("managedDatabase", new()
    {
        DatabaseName = "managedDatabase",
        Location = "southeastasia",
        ManagedInstanceName = "managedInstance",
        ResourceGroupName = "Default-SQL-SouthEastAsia",
        Tags = 
        {
            { "tagKey1", "TagValue1" },
        },
    });

});

package main

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

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := sql.NewManagedDatabase(ctx, "managedDatabase", &sql.ManagedDatabaseArgs{
			DatabaseName:        pulumi.String("managedDatabase"),
			Location:            pulumi.String("southeastasia"),
			ManagedInstanceName: pulumi.String("managedInstance"),
			ResourceGroupName:   pulumi.String("Default-SQL-SouthEastAsia"),
			Tags: pulumi.StringMap{
				"tagKey1": pulumi.String("TagValue1"),
			},
		})
		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.azurenative.sql.ManagedDatabase;
import com.pulumi.azurenative.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 managedDatabase = new ManagedDatabase("managedDatabase", ManagedDatabaseArgs.builder()
            .databaseName("managedDatabase")
            .location("southeastasia")
            .managedInstanceName("managedInstance")
            .resourceGroupName("Default-SQL-SouthEastAsia")
            .tags(Map.of("tagKey1", "TagValue1"))
            .build());

    }
}

import * as pulumi from "@pulumi/pulumi";
import * as azure_native from "@pulumi/azure-native";

const managedDatabase = new azure_native.sql.ManagedDatabase("managedDatabase", {
    databaseName: "managedDatabase",
    location: "southeastasia",
    managedInstanceName: "managedInstance",
    resourceGroupName: "Default-SQL-SouthEastAsia",
    tags: {
        tagKey1: "TagValue1",
    },
});

import pulumi
import pulumi_azure_native as azure_native

managed_database = azure_native.sql.ManagedDatabase("managedDatabase",
    database_name="managedDatabase",
    location="southeastasia",
    managed_instance_name="managedInstance",
    resource_group_name="Default-SQL-SouthEastAsia",
    tags={
        "tagKey1": "TagValue1",
    })

resources:
  managedDatabase:
    type: azure-native:sql:ManagedDatabase
    properties:
      databaseName: managedDatabase
      location: southeastasia
      managedInstanceName: managedInstance
      resourceGroupName: Default-SQL-SouthEastAsia
      tags:
        tagKey1: TagValue1

Creates a new managed database with minimal properties

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

return await Deployment.RunAsync(() => 
{
    var managedDatabase = new AzureNative.Sql.ManagedDatabase("managedDatabase", new()
    {
        DatabaseName = "managedDatabase",
        Location = "southeastasia",
        ManagedInstanceName = "managedInstance",
        ResourceGroupName = "Default-SQL-SouthEastAsia",
    });

});

package main

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

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := sql.NewManagedDatabase(ctx, "managedDatabase", &sql.ManagedDatabaseArgs{
			DatabaseName:        pulumi.String("managedDatabase"),
			Location:            pulumi.String("southeastasia"),
			ManagedInstanceName: pulumi.String("managedInstance"),
			ResourceGroupName:   pulumi.String("Default-SQL-SouthEastAsia"),
		})
		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.azurenative.sql.ManagedDatabase;
import com.pulumi.azurenative.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 managedDatabase = new ManagedDatabase("managedDatabase", ManagedDatabaseArgs.builder()
            .databaseName("managedDatabase")
            .location("southeastasia")
            .managedInstanceName("managedInstance")
            .resourceGroupName("Default-SQL-SouthEastAsia")
            .build());

    }
}

import * as pulumi from "@pulumi/pulumi";
import * as azure_native from "@pulumi/azure-native";

const managedDatabase = new azure_native.sql.ManagedDatabase("managedDatabase", {
    databaseName: "managedDatabase",
    location: "southeastasia",
    managedInstanceName: "managedInstance",
    resourceGroupName: "Default-SQL-SouthEastAsia",
});

import pulumi
import pulumi_azure_native as azure_native

managed_database = azure_native.sql.ManagedDatabase("managedDatabase",
    database_name="managedDatabase",
    location="southeastasia",
    managed_instance_name="managedInstance",
    resource_group_name="Default-SQL-SouthEastAsia")

resources:
  managedDatabase:
    type: azure-native:sql:ManagedDatabase
    properties:
      databaseName: managedDatabase
      location: southeastasia
      managedInstanceName: managedInstance
      resourceGroupName: Default-SQL-SouthEastAsia

Create ManagedDatabase Resource

Resources are created with functions called constructors. To learn more about declaring and configuring resources, see Resources.

Constructor syntax

TypeScript
Python
Go
C#
Java
YAML

new ManagedDatabase(name: string, args: ManagedDatabaseArgs, opts?: CustomResourceOptions);

@overload
def ManagedDatabase(resource_name: str,
                    args: ManagedDatabaseArgs,
                    opts: Optional[ResourceOptions] = None)

@overload
def ManagedDatabase(resource_name: str,
                    opts: Optional[ResourceOptions] = None,
                    managed_instance_name: Optional[str] = None,
                    resource_group_name: Optional[str] = None,
                    location: Optional[str] = None,
                    long_term_retention_backup_resource_id: Optional[str] = None,
                    cross_subscription_restorable_dropped_database_id: Optional[str] = None,
                    cross_subscription_source_database_id: Optional[str] = None,
                    cross_subscription_target_managed_instance_id: Optional[str] = None,
                    database_name: Optional[str] = None,
                    is_ledger_on: Optional[bool] = None,
                    last_backup_name: Optional[str] = None,
                    auto_complete_restore: Optional[bool] = None,
                    create_mode: Optional[Union[str, ManagedDatabaseCreateMode]] = None,
                    collation: Optional[str] = None,
                    recoverable_database_id: Optional[str] = None,
                    catalog_collation: Optional[Union[str, CatalogCollationType]] = None,
                    restorable_dropped_database_id: Optional[str] = None,
                    restore_point_in_time: Optional[str] = None,
                    source_database_id: Optional[str] = None,
                    storage_container_identity: Optional[str] = None,
                    storage_container_sas_token: Optional[str] = None,
                    storage_container_uri: Optional[str] = None,
                    tags: Optional[Mapping[str, str]] = None)

func NewManagedDatabase(ctx *Context, name string, args ManagedDatabaseArgs, opts ...ResourceOption) (*ManagedDatabase, error)

public ManagedDatabase(string name, ManagedDatabaseArgs args, CustomResourceOptions? opts = null)

public ManagedDatabase(String name, ManagedDatabaseArgs args)
public ManagedDatabase(String name, ManagedDatabaseArgs args, CustomResourceOptions options)

type: azure-native:sql:ManagedDatabase
properties: # The arguments to resource properties.
options: # Bag of options to control resource's behavior.

Parameters

name string: The unique name of the resource.
args ManagedDatabaseArgs: The arguments to resource properties.
opts CustomResourceOptions: Bag of options to control resource's behavior.

resource_name str: The unique name of the resource.
args ManagedDatabaseArgs: The arguments to resource properties.
opts ResourceOptions: Bag of options to control resource's behavior.

ctx Context: Context object for the current deployment.
name string: The unique name of the resource.
args ManagedDatabaseArgs: The arguments to resource properties.
opts ResourceOption: Bag of options to control resource's behavior.

name string: The unique name of the resource.
args ManagedDatabaseArgs: The arguments to resource properties.
opts CustomResourceOptions: Bag of options to control resource's behavior.

name String: The unique name of the resource.
args ManagedDatabaseArgs: The arguments to resource properties.
options CustomResourceOptions: Bag of options to control resource's behavior.

Constructor example

The following reference example uses placeholder values for all input properties.

TypeScript
Python
Go
C#
Java
YAML

var managedDatabaseResource = new AzureNative.Sql.ManagedDatabase("managedDatabaseResource", new()
{
    ManagedInstanceName = "string",
    ResourceGroupName = "string",
    Location = "string",
    LongTermRetentionBackupResourceId = "string",
    CrossSubscriptionRestorableDroppedDatabaseId = "string",
    CrossSubscriptionSourceDatabaseId = "string",
    CrossSubscriptionTargetManagedInstanceId = "string",
    DatabaseName = "string",
    IsLedgerOn = false,
    LastBackupName = "string",
    AutoCompleteRestore = false,
    CreateMode = "string",
    Collation = "string",
    RecoverableDatabaseId = "string",
    CatalogCollation = "string",
    RestorableDroppedDatabaseId = "string",
    RestorePointInTime = "string",
    SourceDatabaseId = "string",
    StorageContainerIdentity = "string",
    StorageContainerSasToken = "string",
    StorageContainerUri = "string",
    Tags = 
    {
        { "string", "string" },
    },
});

example, err := sql.NewManagedDatabase(ctx, "managedDatabaseResource", &sql.ManagedDatabaseArgs{
	ManagedInstanceName:               pulumi.String("string"),
	ResourceGroupName:                 pulumi.String("string"),
	Location:                          pulumi.String("string"),
	LongTermRetentionBackupResourceId: pulumi.String("string"),
	CrossSubscriptionRestorableDroppedDatabaseId: pulumi.String("string"),
	CrossSubscriptionSourceDatabaseId:            pulumi.String("string"),
	CrossSubscriptionTargetManagedInstanceId:     pulumi.String("string"),
	DatabaseName:                                 pulumi.String("string"),
	IsLedgerOn:                                   pulumi.Bool(false),
	LastBackupName:                               pulumi.String("string"),
	AutoCompleteRestore:                          pulumi.Bool(false),
	CreateMode:                                   pulumi.String("string"),
	Collation:                                    pulumi.String("string"),
	RecoverableDatabaseId:                        pulumi.String("string"),
	CatalogCollation:                             pulumi.String("string"),
	RestorableDroppedDatabaseId:                  pulumi.String("string"),
	RestorePointInTime:                           pulumi.String("string"),
	SourceDatabaseId:                             pulumi.String("string"),
	StorageContainerIdentity:                     pulumi.String("string"),
	StorageContainerSasToken:                     pulumi.String("string"),
	StorageContainerUri:                          pulumi.String("string"),
	Tags: pulumi.StringMap{
		"string": pulumi.String("string"),
	},
})

var managedDatabaseResource = new ManagedDatabase("managedDatabaseResource", ManagedDatabaseArgs.builder()
    .managedInstanceName("string")
    .resourceGroupName("string")
    .location("string")
    .longTermRetentionBackupResourceId("string")
    .crossSubscriptionRestorableDroppedDatabaseId("string")
    .crossSubscriptionSourceDatabaseId("string")
    .crossSubscriptionTargetManagedInstanceId("string")
    .databaseName("string")
    .isLedgerOn(false)
    .lastBackupName("string")
    .autoCompleteRestore(false)
    .createMode("string")
    .collation("string")
    .recoverableDatabaseId("string")
    .catalogCollation("string")
    .restorableDroppedDatabaseId("string")
    .restorePointInTime("string")
    .sourceDatabaseId("string")
    .storageContainerIdentity("string")
    .storageContainerSasToken("string")
    .storageContainerUri("string")
    .tags(Map.of("string", "string"))
    .build());

managed_database_resource = azure_native.sql.ManagedDatabase("managedDatabaseResource",
    managed_instance_name="string",
    resource_group_name="string",
    location="string",
    long_term_retention_backup_resource_id="string",
    cross_subscription_restorable_dropped_database_id="string",
    cross_subscription_source_database_id="string",
    cross_subscription_target_managed_instance_id="string",
    database_name="string",
    is_ledger_on=False,
    last_backup_name="string",
    auto_complete_restore=False,
    create_mode="string",
    collation="string",
    recoverable_database_id="string",
    catalog_collation="string",
    restorable_dropped_database_id="string",
    restore_point_in_time="string",
    source_database_id="string",
    storage_container_identity="string",
    storage_container_sas_token="string",
    storage_container_uri="string",
    tags={
        "string": "string",
    })

const managedDatabaseResource = new azure_native.sql.ManagedDatabase("managedDatabaseResource", {
    managedInstanceName: "string",
    resourceGroupName: "string",
    location: "string",
    longTermRetentionBackupResourceId: "string",
    crossSubscriptionRestorableDroppedDatabaseId: "string",
    crossSubscriptionSourceDatabaseId: "string",
    crossSubscriptionTargetManagedInstanceId: "string",
    databaseName: "string",
    isLedgerOn: false,
    lastBackupName: "string",
    autoCompleteRestore: false,
    createMode: "string",
    collation: "string",
    recoverableDatabaseId: "string",
    catalogCollation: "string",
    restorableDroppedDatabaseId: "string",
    restorePointInTime: "string",
    sourceDatabaseId: "string",
    storageContainerIdentity: "string",
    storageContainerSasToken: "string",
    storageContainerUri: "string",
    tags: {
        string: "string",
    },
});

type: azure-native:sql:ManagedDatabase
properties:
    autoCompleteRestore: false
    catalogCollation: string
    collation: string
    createMode: string
    crossSubscriptionRestorableDroppedDatabaseId: string
    crossSubscriptionSourceDatabaseId: string
    crossSubscriptionTargetManagedInstanceId: string
    databaseName: string
    isLedgerOn: false
    lastBackupName: string
    location: string
    longTermRetentionBackupResourceId: string
    managedInstanceName: string
    recoverableDatabaseId: string
    resourceGroupName: string
    restorableDroppedDatabaseId: string
    restorePointInTime: string
    sourceDatabaseId: string
    storageContainerIdentity: string
    storageContainerSasToken: string
    storageContainerUri: string
    tags:
        string: string

ManagedDatabase Resource Properties

To learn more about resource properties and how to use them, see Inputs and Outputs in the Architecture and Concepts docs.

Inputs

In Python, inputs that are objects can be passed either as argument classes or as dictionary literals.

The ManagedDatabase resource accepts the following input properties:

ManagedInstanceName string: The name of the managed instance.
ResourceGroupName string: The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
AutoCompleteRestore bool: Whether to auto complete restore of this managed database.
CatalogCollation string | Pulumi.AzureNative.Sql.CatalogCollationType: Collation of the metadata catalog.
Collation string: Collation of the managed database.
CreateMode string | Pulumi.AzureNative.Sql.ManagedDatabaseCreateMode: Managed database create mode. PointInTimeRestore: Create a database by restoring a point in time backup of an existing database. SourceDatabaseName, SourceManagedInstanceName and PointInTime must be specified. RestoreExternalBackup: Create a database by restoring from external backup files. Collation, StorageContainerUri and StorageContainerSasToken must be specified. Recovery: Creates a database by restoring a geo-replicated backup. RecoverableDatabaseId must be specified as the recoverable database resource ID to restore. RestoreLongTermRetentionBackup: Create a database by restoring from a long term retention backup (longTermRetentionBackupResourceId required).
CrossSubscriptionRestorableDroppedDatabaseId string: The restorable cross-subscription dropped database resource id to restore when creating this database.
CrossSubscriptionSourceDatabaseId string: The resource identifier of the cross-subscription source database associated with create operation of this database.
CrossSubscriptionTargetManagedInstanceId string: Target managed instance id used in cross-subscription restore.
DatabaseName string: The name of the database.
IsLedgerOn bool: Whether or not this database is a ledger database, which means all tables in the database are ledger tables. Note: the value of this property cannot be changed after the database has been created.
LastBackupName string: Last backup file name for restore of this managed database.
Location string: Resource location.
LongTermRetentionBackupResourceId string: The name of the Long Term Retention backup to be used for restore of this managed database.
RecoverableDatabaseId string: The resource identifier of the recoverable database associated with create operation of this database.
RestorableDroppedDatabaseId string: The restorable dropped database resource id to restore when creating this database.
RestorePointInTime string: Conditional. If createMode is PointInTimeRestore, this value is required. Specifies the point in time (ISO8601 format) of the source database that will be restored to create the new database.
SourceDatabaseId string: The resource identifier of the source database associated with create operation of this database.
StorageContainerIdentity string: Conditional. If createMode is RestoreExternalBackup, this value is used. Specifies the identity used for storage container authentication. Can be 'SharedAccessSignature' or 'ManagedIdentity'; if not specified 'SharedAccessSignature' is assumed.
StorageContainerSasToken string: Conditional. If createMode is RestoreExternalBackup and storageContainerIdentity is not ManagedIdentity, this value is required. Specifies the storage container sas token.
StorageContainerUri string: Conditional. If createMode is RestoreExternalBackup, this value is required. Specifies the uri of the storage container where backups for this restore are stored.
Tags Dictionary<string, string>: Resource tags.

ManagedInstanceName string: The name of the managed instance.
ResourceGroupName string: The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
AutoCompleteRestore bool: Whether to auto complete restore of this managed database.
CatalogCollation string | CatalogCollationType: Collation of the metadata catalog.
Collation string: Collation of the managed database.
CreateMode string | ManagedDatabaseCreateMode: Managed database create mode. PointInTimeRestore: Create a database by restoring a point in time backup of an existing database. SourceDatabaseName, SourceManagedInstanceName and PointInTime must be specified. RestoreExternalBackup: Create a database by restoring from external backup files. Collation, StorageContainerUri and StorageContainerSasToken must be specified. Recovery: Creates a database by restoring a geo-replicated backup. RecoverableDatabaseId must be specified as the recoverable database resource ID to restore. RestoreLongTermRetentionBackup: Create a database by restoring from a long term retention backup (longTermRetentionBackupResourceId required).
CrossSubscriptionRestorableDroppedDatabaseId string: The restorable cross-subscription dropped database resource id to restore when creating this database.
CrossSubscriptionSourceDatabaseId string: The resource identifier of the cross-subscription source database associated with create operation of this database.
CrossSubscriptionTargetManagedInstanceId string: Target managed instance id used in cross-subscription restore.
DatabaseName string: The name of the database.
IsLedgerOn bool: Whether or not this database is a ledger database, which means all tables in the database are ledger tables. Note: the value of this property cannot be changed after the database has been created.
LastBackupName string: Last backup file name for restore of this managed database.
Location string: Resource location.
LongTermRetentionBackupResourceId string: The name of the Long Term Retention backup to be used for restore of this managed database.
RecoverableDatabaseId string: The resource identifier of the recoverable database associated with create operation of this database.
RestorableDroppedDatabaseId string: The restorable dropped database resource id to restore when creating this database.
RestorePointInTime string: Conditional. If createMode is PointInTimeRestore, this value is required. Specifies the point in time (ISO8601 format) of the source database that will be restored to create the new database.
SourceDatabaseId string: The resource identifier of the source database associated with create operation of this database.
StorageContainerIdentity string: Conditional. If createMode is RestoreExternalBackup, this value is used. Specifies the identity used for storage container authentication. Can be 'SharedAccessSignature' or 'ManagedIdentity'; if not specified 'SharedAccessSignature' is assumed.
StorageContainerSasToken string: Conditional. If createMode is RestoreExternalBackup and storageContainerIdentity is not ManagedIdentity, this value is required. Specifies the storage container sas token.
StorageContainerUri string: Conditional. If createMode is RestoreExternalBackup, this value is required. Specifies the uri of the storage container where backups for this restore are stored.
Tags map[string]string: Resource tags.

managedInstanceName String: The name of the managed instance.
resourceGroupName String: The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
autoCompleteRestore Boolean: Whether to auto complete restore of this managed database.
catalogCollation String | CatalogCollationType: Collation of the metadata catalog.
collation String: Collation of the managed database.
createMode String | ManagedDatabaseCreateMode: Managed database create mode. PointInTimeRestore: Create a database by restoring a point in time backup of an existing database. SourceDatabaseName, SourceManagedInstanceName and PointInTime must be specified. RestoreExternalBackup: Create a database by restoring from external backup files. Collation, StorageContainerUri and StorageContainerSasToken must be specified. Recovery: Creates a database by restoring a geo-replicated backup. RecoverableDatabaseId must be specified as the recoverable database resource ID to restore. RestoreLongTermRetentionBackup: Create a database by restoring from a long term retention backup (longTermRetentionBackupResourceId required).
crossSubscriptionRestorableDroppedDatabaseId String: The restorable cross-subscription dropped database resource id to restore when creating this database.
crossSubscriptionSourceDatabaseId String: The resource identifier of the cross-subscription source database associated with create operation of this database.
crossSubscriptionTargetManagedInstanceId String: Target managed instance id used in cross-subscription restore.
databaseName String: The name of the database.
isLedgerOn Boolean: Whether or not this database is a ledger database, which means all tables in the database are ledger tables. Note: the value of this property cannot be changed after the database has been created.
lastBackupName String: Last backup file name for restore of this managed database.
location String: Resource location.
longTermRetentionBackupResourceId String: The name of the Long Term Retention backup to be used for restore of this managed database.
recoverableDatabaseId String: The resource identifier of the recoverable database associated with create operation of this database.
restorableDroppedDatabaseId String: The restorable dropped database resource id to restore when creating this database.
restorePointInTime String: Conditional. If createMode is PointInTimeRestore, this value is required. Specifies the point in time (ISO8601 format) of the source database that will be restored to create the new database.
sourceDatabaseId String: The resource identifier of the source database associated with create operation of this database.
storageContainerIdentity String: Conditional. If createMode is RestoreExternalBackup, this value is used. Specifies the identity used for storage container authentication. Can be 'SharedAccessSignature' or 'ManagedIdentity'; if not specified 'SharedAccessSignature' is assumed.
storageContainerSasToken String: Conditional. If createMode is RestoreExternalBackup and storageContainerIdentity is not ManagedIdentity, this value is required. Specifies the storage container sas token.
storageContainerUri String: Conditional. If createMode is RestoreExternalBackup, this value is required. Specifies the uri of the storage container where backups for this restore are stored.
tags Map<String,String>: Resource tags.

managedInstanceName string: The name of the managed instance.
resourceGroupName string: The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
autoCompleteRestore boolean: Whether to auto complete restore of this managed database.
catalogCollation string | CatalogCollationType: Collation of the metadata catalog.
collation string: Collation of the managed database.
createMode string | ManagedDatabaseCreateMode: Managed database create mode. PointInTimeRestore: Create a database by restoring a point in time backup of an existing database. SourceDatabaseName, SourceManagedInstanceName and PointInTime must be specified. RestoreExternalBackup: Create a database by restoring from external backup files. Collation, StorageContainerUri and StorageContainerSasToken must be specified. Recovery: Creates a database by restoring a geo-replicated backup. RecoverableDatabaseId must be specified as the recoverable database resource ID to restore. RestoreLongTermRetentionBackup: Create a database by restoring from a long term retention backup (longTermRetentionBackupResourceId required).
crossSubscriptionRestorableDroppedDatabaseId string: The restorable cross-subscription dropped database resource id to restore when creating this database.
crossSubscriptionSourceDatabaseId string: The resource identifier of the cross-subscription source database associated with create operation of this database.
crossSubscriptionTargetManagedInstanceId string: Target managed instance id used in cross-subscription restore.
databaseName string: The name of the database.
isLedgerOn boolean: Whether or not this database is a ledger database, which means all tables in the database are ledger tables. Note: the value of this property cannot be changed after the database has been created.
lastBackupName string: Last backup file name for restore of this managed database.
location string: Resource location.
longTermRetentionBackupResourceId string: The name of the Long Term Retention backup to be used for restore of this managed database.
recoverableDatabaseId string: The resource identifier of the recoverable database associated with create operation of this database.
restorableDroppedDatabaseId string: The restorable dropped database resource id to restore when creating this database.
restorePointInTime string: Conditional. If createMode is PointInTimeRestore, this value is required. Specifies the point in time (ISO8601 format) of the source database that will be restored to create the new database.
sourceDatabaseId string: The resource identifier of the source database associated with create operation of this database.
storageContainerIdentity string: Conditional. If createMode is RestoreExternalBackup, this value is used. Specifies the identity used for storage container authentication. Can be 'SharedAccessSignature' or 'ManagedIdentity'; if not specified 'SharedAccessSignature' is assumed.
storageContainerSasToken string: Conditional. If createMode is RestoreExternalBackup and storageContainerIdentity is not ManagedIdentity, this value is required. Specifies the storage container sas token.
storageContainerUri string: Conditional. If createMode is RestoreExternalBackup, this value is required. Specifies the uri of the storage container where backups for this restore are stored.
tags {[key: string]: string}: Resource tags.

managed_instance_name str: The name of the managed instance.
resource_group_name str: The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
auto_complete_restore bool: Whether to auto complete restore of this managed database.
catalog_collation str | CatalogCollationType: Collation of the metadata catalog.
collation str: Collation of the managed database.
create_mode str | ManagedDatabaseCreateMode: Managed database create mode. PointInTimeRestore: Create a database by restoring a point in time backup of an existing database. SourceDatabaseName, SourceManagedInstanceName and PointInTime must be specified. RestoreExternalBackup: Create a database by restoring from external backup files. Collation, StorageContainerUri and StorageContainerSasToken must be specified. Recovery: Creates a database by restoring a geo-replicated backup. RecoverableDatabaseId must be specified as the recoverable database resource ID to restore. RestoreLongTermRetentionBackup: Create a database by restoring from a long term retention backup (longTermRetentionBackupResourceId required).
cross_subscription_restorable_dropped_database_id str: The restorable cross-subscription dropped database resource id to restore when creating this database.
cross_subscription_source_database_id str: The resource identifier of the cross-subscription source database associated with create operation of this database.
cross_subscription_target_managed_instance_id str: Target managed instance id used in cross-subscription restore.
database_name str: The name of the database.
is_ledger_on bool: Whether or not this database is a ledger database, which means all tables in the database are ledger tables. Note: the value of this property cannot be changed after the database has been created.
last_backup_name str: Last backup file name for restore of this managed database.
location str: Resource location.
long_term_retention_backup_resource_id str: The name of the Long Term Retention backup to be used for restore of this managed database.
recoverable_database_id str: The resource identifier of the recoverable database associated with create operation of this database.
restorable_dropped_database_id str: The restorable dropped database resource id to restore when creating this database.
restore_point_in_time str: Conditional. If createMode is PointInTimeRestore, this value is required. Specifies the point in time (ISO8601 format) of the source database that will be restored to create the new database.
source_database_id str: The resource identifier of the source database associated with create operation of this database.
storage_container_identity str: Conditional. If createMode is RestoreExternalBackup, this value is used. Specifies the identity used for storage container authentication. Can be 'SharedAccessSignature' or 'ManagedIdentity'; if not specified 'SharedAccessSignature' is assumed.
storage_container_sas_token str: Conditional. If createMode is RestoreExternalBackup and storageContainerIdentity is not ManagedIdentity, this value is required. Specifies the storage container sas token.
storage_container_uri str: Conditional. If createMode is RestoreExternalBackup, this value is required. Specifies the uri of the storage container where backups for this restore are stored.
tags Mapping[str, str]: Resource tags.

managedInstanceName String: The name of the managed instance.
resourceGroupName String: The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
autoCompleteRestore Boolean: Whether to auto complete restore of this managed database.
catalogCollation String | "DATABASE_DEFAULT" | "SQL_Latin1_General_CP1_CI_AS": Collation of the metadata catalog.
collation String: Collation of the managed database.
createMode String | "Default" | "RestoreExternalBackup" | "PointInTimeRestore" | "Recovery" | "RestoreLongTermRetentionBackup": Managed database create mode. PointInTimeRestore: Create a database by restoring a point in time backup of an existing database. SourceDatabaseName, SourceManagedInstanceName and PointInTime must be specified. RestoreExternalBackup: Create a database by restoring from external backup files. Collation, StorageContainerUri and StorageContainerSasToken must be specified. Recovery: Creates a database by restoring a geo-replicated backup. RecoverableDatabaseId must be specified as the recoverable database resource ID to restore. RestoreLongTermRetentionBackup: Create a database by restoring from a long term retention backup (longTermRetentionBackupResourceId required).
crossSubscriptionRestorableDroppedDatabaseId String: The restorable cross-subscription dropped database resource id to restore when creating this database.
crossSubscriptionSourceDatabaseId String: The resource identifier of the cross-subscription source database associated with create operation of this database.
crossSubscriptionTargetManagedInstanceId String: Target managed instance id used in cross-subscription restore.
databaseName String: The name of the database.
isLedgerOn Boolean: Whether or not this database is a ledger database, which means all tables in the database are ledger tables. Note: the value of this property cannot be changed after the database has been created.
lastBackupName String: Last backup file name for restore of this managed database.
location String: Resource location.
longTermRetentionBackupResourceId String: The name of the Long Term Retention backup to be used for restore of this managed database.
recoverableDatabaseId String: The resource identifier of the recoverable database associated with create operation of this database.
restorableDroppedDatabaseId String: The restorable dropped database resource id to restore when creating this database.
restorePointInTime String: Conditional. If createMode is PointInTimeRestore, this value is required. Specifies the point in time (ISO8601 format) of the source database that will be restored to create the new database.
sourceDatabaseId String: The resource identifier of the source database associated with create operation of this database.
storageContainerIdentity String: Conditional. If createMode is RestoreExternalBackup, this value is used. Specifies the identity used for storage container authentication. Can be 'SharedAccessSignature' or 'ManagedIdentity'; if not specified 'SharedAccessSignature' is assumed.
storageContainerSasToken String: Conditional. If createMode is RestoreExternalBackup and storageContainerIdentity is not ManagedIdentity, this value is required. Specifies the storage container sas token.
storageContainerUri String: Conditional. If createMode is RestoreExternalBackup, this value is required. Specifies the uri of the storage container where backups for this restore are stored.
tags Map<String>: Resource tags.

Outputs

All input properties are implicitly available as output properties. Additionally, the ManagedDatabase resource produces the following output properties:

AzureApiVersion string: The Azure API version of the resource.
CreationDate string: Creation date of the database.
DefaultSecondaryLocation string: Geo paired region.
EarliestRestorePoint string: Earliest restore point in time for point in time restore.
FailoverGroupId string: Instance Failover Group resource identifier that this managed database belongs to.
Id string: The provider-assigned unique ID for this managed resource.
Name string: Resource name.
Status string: Status of the database.
Type string: Resource type.

AzureApiVersion string: The Azure API version of the resource.
CreationDate string: Creation date of the database.
DefaultSecondaryLocation string: Geo paired region.
EarliestRestorePoint string: Earliest restore point in time for point in time restore.
FailoverGroupId string: Instance Failover Group resource identifier that this managed database belongs to.
Id string: The provider-assigned unique ID for this managed resource.
Name string: Resource name.
Status string: Status of the database.
Type string: Resource type.

azureApiVersion String: The Azure API version of the resource.
creationDate String: Creation date of the database.
defaultSecondaryLocation String: Geo paired region.
earliestRestorePoint String: Earliest restore point in time for point in time restore.
failoverGroupId String: Instance Failover Group resource identifier that this managed database belongs to.
id String: The provider-assigned unique ID for this managed resource.
name String: Resource name.
status String: Status of the database.
type String: Resource type.

azureApiVersion string: The Azure API version of the resource.
creationDate string: Creation date of the database.
defaultSecondaryLocation string: Geo paired region.
earliestRestorePoint string: Earliest restore point in time for point in time restore.
failoverGroupId string: Instance Failover Group resource identifier that this managed database belongs to.
id string: The provider-assigned unique ID for this managed resource.
name string: Resource name.
status string: Status of the database.
type string: Resource type.

azure_api_version str: The Azure API version of the resource.
creation_date str: Creation date of the database.
default_secondary_location str: Geo paired region.
earliest_restore_point str: Earliest restore point in time for point in time restore.
failover_group_id str: Instance Failover Group resource identifier that this managed database belongs to.
id str: The provider-assigned unique ID for this managed resource.
name str: Resource name.
status str: Status of the database.
type str: Resource type.

azureApiVersion String: The Azure API version of the resource.
creationDate String: Creation date of the database.
defaultSecondaryLocation String: Geo paired region.
earliestRestorePoint String: Earliest restore point in time for point in time restore.
failoverGroupId String: Instance Failover Group resource identifier that this managed database belongs to.
id String: The provider-assigned unique ID for this managed resource.
name String: Resource name.
status String: Status of the database.
type String: Resource type.

Supporting Types

CatalogCollationType
, CatalogCollationTypeArgs

DATABASE_DEFAULT: DATABASE_DEFAULT
SQL_Latin1_General_CP1_CI_AS: SQL_Latin1_General_CP1_CI_AS

CatalogCollationType_DATABASE_DEFAULT: DATABASE_DEFAULT
CatalogCollationType_SQL_Latin1_General_CP1_CI_AS: SQL_Latin1_General_CP1_CI_AS

DATABASE_DEFAULT: DATABASE_DEFAULT
SQL_Latin1_General_CP1_CI_AS: SQL_Latin1_General_CP1_CI_AS

DATABASE_DEFAULT: DATABASE_DEFAULT
SQL_Latin1_General_CP1_CI_AS: SQL_Latin1_General_CP1_CI_AS

DATABAS_E_DEFAULT: DATABASE_DEFAULT
SQ_L_LATIN1_GENERAL_CP1_C_I_AS: SQL_Latin1_General_CP1_CI_AS

"DATABASE_DEFAULT": DATABASE_DEFAULT
"SQL_Latin1_General_CP1_CI_AS": SQL_Latin1_General_CP1_CI_AS

ManagedDatabaseCreateMode
, ManagedDatabaseCreateModeArgs

Default: Default
RestoreExternalBackup: RestoreExternalBackup
PointInTimeRestore: PointInTimeRestore
Recovery: Recovery
RestoreLongTermRetentionBackup: RestoreLongTermRetentionBackup

ManagedDatabaseCreateModeDefault: Default
ManagedDatabaseCreateModeRestoreExternalBackup: RestoreExternalBackup
ManagedDatabaseCreateModePointInTimeRestore: PointInTimeRestore
ManagedDatabaseCreateModeRecovery: Recovery
ManagedDatabaseCreateModeRestoreLongTermRetentionBackup: RestoreLongTermRetentionBackup

Default: Default
RestoreExternalBackup: RestoreExternalBackup
PointInTimeRestore: PointInTimeRestore
Recovery: Recovery
RestoreLongTermRetentionBackup: RestoreLongTermRetentionBackup

Default: Default
RestoreExternalBackup: RestoreExternalBackup
PointInTimeRestore: PointInTimeRestore
Recovery: Recovery
RestoreLongTermRetentionBackup: RestoreLongTermRetentionBackup

DEFAULT: Default
RESTORE_EXTERNAL_BACKUP: RestoreExternalBackup
POINT_IN_TIME_RESTORE: PointInTimeRestore
RECOVERY: Recovery
RESTORE_LONG_TERM_RETENTION_BACKUP: RestoreLongTermRetentionBackup

"Default": Default
"RestoreExternalBackup": RestoreExternalBackup
"PointInTimeRestore": PointInTimeRestore
"Recovery": Recovery
"RestoreLongTermRetentionBackup": RestoreLongTermRetentionBackup

Import

An existing resource can be imported using its type token, name, and identifier, e.g.

$ pulumi import azure-native:sql:ManagedDatabase testdb1 /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/managedInstances/{managedInstanceName}/databases/{databaseName}

To learn more about importing existing cloud resources, see Importing resources.

Package Details

Repository: Azure Native pulumi/pulumi-azure-native
License: Apache-2.0

This is the latest version of Azure Native. Use the Azure Native v2 docs if using the v2 version of this package.

Azure Native v3.2.0 published on Monday, Apr 14, 2025 by Pulumi

pulumi/pulumi-azure-native

Example Usage
Creates a new managed database by restoring from an external backup
Creates a new managed database by restoring from an external backup using managed identity
Creates a new managed database from restoring a geo-replicated backup
Creates a new managed database from restoring a long term retention backup
Creates a new managed database using cross subscription point in time restore
Creates a new managed database using point in time restore
Creates a new managed database with ledger on.
Creates a new managed database with maximal properties
Creates a new managed database with minimal properties
Create ManagedDatabase Resource
Constructor syntax
Constructor example
ManagedDatabase Resource Properties
Inputs
Outputs
Supporting Types
Import
Package Details

Related Resources

web.WebApp

resources.ResourceGroup

sql.ManagedInstance

Request a Change

azure-native.sql.ManagedDatabase

On this page

On this page

Example Usage

Creates a new managed database by restoring from an external backup

Creates a new managed database by restoring from an external backup using managed identity

Creates a new managed database from restoring a geo-replicated backup

Creates a new managed database from restoring a long term retention backup

Creates a new managed database using cross subscription point in time restore

Creates a new managed database using point in time restore

Creates a new managed database with ledger on.

Creates a new managed database with maximal properties

Creates a new managed database with minimal properties

Create ManagedDatabase Resource

Constructor syntax

Parameters

Constructor example

ManagedDatabase Resource Properties

Inputs

Outputs

Supporting Types

CatalogCollationType
, CatalogCollationTypeArgs

ManagedDatabaseCreateMode
, ManagedDatabaseCreateModeArgs

Import

Package Details

On this page

On this page

azure-native.sql.ManagedDatabase

On this page

On this page

Example Usage

Creates a new managed database by restoring from an external backup

Creates a new managed database by restoring from an external backup using managed identity

Creates a new managed database from restoring a geo-replicated backup

Creates a new managed database from restoring a long term retention backup

Creates a new managed database using cross subscription point in time restore

Creates a new managed database using point in time restore

Creates a new managed database with ledger on.

Creates a new managed database with maximal properties

Creates a new managed database with minimal properties

Create ManagedDatabase Resource

Constructor syntax

Parameters

Constructor example

ManagedDatabase Resource Properties

Inputs

Outputs

Supporting Types

CatalogCollationType, CatalogCollationTypeArgs

ManagedDatabaseCreateMode, ManagedDatabaseCreateModeArgs

Import

Package Details

On this page

On this page

CatalogCollationType
, CatalogCollationTypeArgs

ManagedDatabaseCreateMode
, ManagedDatabaseCreateModeArgs