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

ManagedDatabaseArgs

data class ManagedDatabaseArgs(val autoCompleteRestore: Output<Boolean>? = null, val catalogCollation: Output<Either<String, CatalogCollationType>>? = null, val collation: Output<String>? = null, val createMode: Output<Either<String, ManagedDatabaseCreateMode>>? = null, val crossSubscriptionRestorableDroppedDatabaseId: Output<String>? = null, val crossSubscriptionSourceDatabaseId: Output<String>? = null, val crossSubscriptionTargetManagedInstanceId: Output<String>? = null, val databaseName: Output<String>? = null, val isLedgerOn: Output<Boolean>? = null, val lastBackupName: Output<String>? = null, val location: Output<String>? = null, val longTermRetentionBackupResourceId: Output<String>? = null, val managedInstanceName: Output<String>? = null, val recoverableDatabaseId: Output<String>? = null, val resourceGroupName: Output<String>? = null, val restorableDroppedDatabaseId: Output<String>? = null, val restorePointInTime: Output<String>? = null, val sourceDatabaseId: Output<String>? = null, val storageContainerIdentity: Output<String>? = null, val storageContainerSasToken: Output<String>? = null, val storageContainerUri: Output<String>? = null, val tags: Output<Map<String, String>>? = null) : ConvertibleToJava<ManagedDatabaseArgs>

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/#accessing-any-api-version-via-local-packages for details.

Example Usage

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",
    });
});
Content copied to clipboard
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
	})
}
Content copied to clipboard
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());
    }
}
Content copied to clipboard

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",
    });
});
Content copied to clipboard
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
	})
}
Content copied to clipboard
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());
    }
}
Content copied to clipboard

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",
    });
});
Content copied to clipboard
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
	})
}
Content copied to clipboard
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());
    }
}
Content copied to clipboard

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",
    });
});
Content copied to clipboard
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
	})
}
Content copied to clipboard
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());
    }
}
Content copied to clipboard

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",
    });
});
Content copied to clipboard
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
	})
}
Content copied to clipboard
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());
    }
}
Content copied to clipboard

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",
    });
});
Content copied to clipboard
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
	})
}
Content copied to clipboard
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());
    }
}
Content copied to clipboard

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",
    });
});
Content copied to clipboard
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
	})
}
Content copied to clipboard
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());
    }
}
Content copied to clipboard

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" },
        },
    });
});
Content copied to clipboard
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
	})
}
Content copied to clipboard
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());
    }
}
Content copied to clipboard

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",
    });
});
Content copied to clipboard
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
	})
}
Content copied to clipboard
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());
    }
}
Content copied to clipboard

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}
Content copied to clipboard

Constructors

Link copied to clipboard
constructor(autoCompleteRestore: Output<Boolean>? = null, catalogCollation: Output<Either<String, CatalogCollationType>>? = null, collation: Output<String>? = null, createMode: Output<Either<String, ManagedDatabaseCreateMode>>? = null, crossSubscriptionRestorableDroppedDatabaseId: Output<String>? = null, crossSubscriptionSourceDatabaseId: Output<String>? = null, crossSubscriptionTargetManagedInstanceId: Output<String>? = null, databaseName: Output<String>? = null, isLedgerOn: Output<Boolean>? = null, lastBackupName: Output<String>? = null, location: Output<String>? = null, longTermRetentionBackupResourceId: Output<String>? = null, managedInstanceName: Output<String>? = null, recoverableDatabaseId: Output<String>? = null, resourceGroupName: Output<String>? = null, restorableDroppedDatabaseId: Output<String>? = null, restorePointInTime: Output<String>? = null, sourceDatabaseId: Output<String>? = null, storageContainerIdentity: Output<String>? = null, storageContainerSasToken: Output<String>? = null, storageContainerUri: Output<String>? = null, tags: Output<Map<String, String>>? = null)

Properties

Link copied to clipboard
val autoCompleteRestore: Output<Boolean>? = null

Whether to auto complete restore of this managed database.

Link copied to clipboard
val catalogCollation: Output<Either<String, CatalogCollationType>>? = null

Collation of the metadata catalog.

Link copied to clipboard
val collation: Output<String>? = null

Collation of the managed database.

Link copied to clipboard
val createMode: Output<Either<String, ManagedDatabaseCreateMode>>? = null

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).

val crossSubscriptionRestorableDroppedDatabaseId: Output<String>? = null

The restorable cross-subscription dropped database resource id to restore when creating this database.

Link copied to clipboard
val crossSubscriptionSourceDatabaseId: Output<String>? = null

The resource identifier of the cross-subscription source database associated with create operation of this database.

Link copied to clipboard
val crossSubscriptionTargetManagedInstanceId: Output<String>? = null

Target managed instance id used in cross-subscription restore.

Link copied to clipboard
val databaseName: Output<String>? = null

The name of the database.

Link copied to clipboard
val isLedgerOn: Output<Boolean>? = null

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.

Link copied to clipboard
val lastBackupName: Output<String>? = null

Last backup file name for restore of this managed database.

Link copied to clipboard
val location: Output<String>? = null

Resource location.

Link copied to clipboard
val longTermRetentionBackupResourceId: Output<String>? = null

The name of the Long Term Retention backup to be used for restore of this managed database.

Link copied to clipboard
val managedInstanceName: Output<String>? = null

The name of the managed instance.

Link copied to clipboard
val recoverableDatabaseId: Output<String>? = null

The resource identifier of the recoverable database associated with create operation of this database.

Link copied to clipboard
val resourceGroupName: Output<String>? = null

The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.

Link copied to clipboard
val restorableDroppedDatabaseId: Output<String>? = null

The restorable dropped database resource id to restore when creating this database.

Link copied to clipboard
val restorePointInTime: Output<String>? = null

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.

Link copied to clipboard
val sourceDatabaseId: Output<String>? = null

The resource identifier of the source database associated with create operation of this database.

Link copied to clipboard
val storageContainerIdentity: Output<String>? = null

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.

Link copied to clipboard
val storageContainerSasToken: Output<String>? = null

Conditional. If createMode is RestoreExternalBackup and storageContainerIdentity is not ManagedIdentity, this value is required. Specifies the storage container sas token.

Link copied to clipboard
val storageContainerUri: Output<String>? = null

Conditional. If createMode is RestoreExternalBackup, this value is required. Specifies the uri of the storage container where backups for this restore are stored.

Link copied to clipboard
val tags: Output<Map<String, String>>? = null

Resource tags.

Functions

Link copied to clipboard
open override fun toJava(): ManagedDatabaseArgs