pulumi-azure-native-kotlin/com.pulumi.azurenative.azurearcdata.kotlin/SqlServerDatabaseArgs

SqlServerDatabaseArgs

data class SqlServerDatabaseArgs(val databaseName: Output<String>? = null, val location: Output<String>? = null, val properties: Output<SqlServerDatabaseResourcePropertiesArgs>? = null, val resourceGroupName: Output<String>? = null, val sqlServerInstanceName: Output<String>? = null, val tags: Output<Map<String, String>>? = null) : ConvertibleToJava<SqlServerDatabaseArgs>

Arc Sql Server database Uses Azure REST API version 2024-01-01. In version 2.x of the Azure Native provider, it used API version 2023-01-15-preview. Other available API versions: 2023-01-15-preview, 2024-05-01-preview, 2025-03-01-preview. These can be accessed by generating a local SDK package using the CLI command pulumi package add azure-native azurearcdata [ApiVersion]. See the ../../../version-guide/#accessing-any-api-version-via-local-packages for details.

Example Usage

Create a Arc Sql Server database.

using System.Collections.Generic;
using System.Linq;
using Pulumi;
using AzureNative = Pulumi.AzureNative;
return await Deployment.RunAsync(() =>
{
    var sqlServerDatabase = new AzureNative.AzureArcData.SqlServerDatabase("sqlServerDatabase", new()
    {
        DatabaseName = "testdb",
        Location = "southeastasia",
        Properties = new AzureNative.AzureArcData.Inputs.SqlServerDatabaseResourcePropertiesArgs
        {
            BackupInformation = new AzureNative.AzureArcData.Inputs.SqlServerDatabaseResourcePropertiesBackupInformationArgs
            {
                LastFullBackup = "2022-05-05T16:26:33.883Z",
                LastLogBackup = "2022-05-10T16:26:33.883Z",
            },
            BackupPolicy = new AzureNative.AzureArcData.Inputs.BackupPolicyArgs
            {
                DifferentialBackupHours = 12,
                FullBackupDays = 1,
                RetentionPeriodDays = 1,
                TransactionLogBackupMinutes = 30,
            },
            CollationName = "SQL_Latin1_General_CP1_CI_AS",
            CompatibilityLevel = 150,
            CreateMode = AzureNative.AzureArcData.DatabaseCreateMode.PointInTimeRestore,
            DatabaseCreationDate = "2022-04-05T16:26:33.883Z",
            DatabaseOptions = new AzureNative.AzureArcData.Inputs.SqlServerDatabaseResourcePropertiesDatabaseOptionsArgs
            {
                IsAutoCloseOn = true,
                IsAutoCreateStatsOn = true,
                IsAutoShrinkOn = true,
                IsAutoUpdateStatsOn = true,
                IsEncrypted = true,
                IsMemoryOptimizationEnabled = true,
                IsRemoteDataArchiveEnabled = true,
                IsTrustworthyOn = true,
            },
            IsReadOnly = true,
            RecoveryMode = AzureNative.AzureArcData.RecoveryMode.Full,
            RestorePointInTime = "2022-05-05T16:26:33.883Z",
            SizeMB = 150,
            SourceDatabaseId = "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.AzureArcData/testSqlServerInstance/testsqlManagedInstance/databases/MyDatabase",
            SpaceAvailableMB = 100,
            State = AzureNative.AzureArcData.DatabaseState.Online,
        },
        ResourceGroupName = "testrg",
        SqlServerInstanceName = "testSqlServerInstance",
        Tags =
        {
            { "mytag", "myval" },
        },
    });
});

package main
import (
	azurearcdata "github.com/pulumi/pulumi-azure-native-sdk/azurearcdata/v2"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := azurearcdata.NewSqlServerDatabase(ctx, "sqlServerDatabase", &azurearcdata.SqlServerDatabaseArgs{
			DatabaseName: pulumi.String("testdb"),
			Location:     pulumi.String("southeastasia"),
			Properties: &azurearcdata.SqlServerDatabaseResourcePropertiesArgs{
				BackupInformation: &azurearcdata.SqlServerDatabaseResourcePropertiesBackupInformationArgs{
					LastFullBackup: pulumi.String("2022-05-05T16:26:33.883Z"),
					LastLogBackup:  pulumi.String("2022-05-10T16:26:33.883Z"),
				},
				BackupPolicy: &azurearcdata.BackupPolicyArgs{
					DifferentialBackupHours:     pulumi.Int(12),
					FullBackupDays:              pulumi.Int(1),
					RetentionPeriodDays:         pulumi.Int(1),
					TransactionLogBackupMinutes: pulumi.Int(30),
				},
				CollationName:        pulumi.String("SQL_Latin1_General_CP1_CI_AS"),
				CompatibilityLevel:   pulumi.Int(150),
				CreateMode:           pulumi.String(azurearcdata.DatabaseCreateModePointInTimeRestore),
				DatabaseCreationDate: pulumi.String("2022-04-05T16:26:33.883Z"),
				DatabaseOptions: &azurearcdata.SqlServerDatabaseResourcePropertiesDatabaseOptionsArgs{
					IsAutoCloseOn:               pulumi.Bool(true),
					IsAutoCreateStatsOn:         pulumi.Bool(true),
					IsAutoShrinkOn:              pulumi.Bool(true),
					IsAutoUpdateStatsOn:         pulumi.Bool(true),
					IsEncrypted:                 pulumi.Bool(true),
					IsMemoryOptimizationEnabled: pulumi.Bool(true),
					IsRemoteDataArchiveEnabled:  pulumi.Bool(true),
					IsTrustworthyOn:             pulumi.Bool(true),
				},
				IsReadOnly:         pulumi.Bool(true),
				RecoveryMode:       pulumi.String(azurearcdata.RecoveryModeFull),
				RestorePointInTime: pulumi.String("2022-05-05T16:26:33.883Z"),
				SizeMB:             pulumi.Float64(150),
				SourceDatabaseId:   pulumi.String("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.AzureArcData/testSqlServerInstance/testsqlManagedInstance/databases/MyDatabase"),
				SpaceAvailableMB:   pulumi.Float64(100),
				State:              pulumi.String(azurearcdata.DatabaseStateOnline),
			},
			ResourceGroupName:     pulumi.String("testrg"),
			SqlServerInstanceName: pulumi.String("testSqlServerInstance"),
			Tags: pulumi.StringMap{
				"mytag": pulumi.String("myval"),
			},
		})
		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.azurearcdata.SqlServerDatabase;
import com.pulumi.azurenative.azurearcdata.SqlServerDatabaseArgs;
import com.pulumi.azurenative.azurearcdata.inputs.SqlServerDatabaseResourcePropertiesArgs;
import com.pulumi.azurenative.azurearcdata.inputs.SqlServerDatabaseResourcePropertiesBackupInformationArgs;
import com.pulumi.azurenative.azurearcdata.inputs.BackupPolicyArgs;
import com.pulumi.azurenative.azurearcdata.inputs.SqlServerDatabaseResourcePropertiesDatabaseOptionsArgs;
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 sqlServerDatabase = new SqlServerDatabase("sqlServerDatabase", SqlServerDatabaseArgs.builder()
            .databaseName("testdb")
            .location("southeastasia")
            .properties(SqlServerDatabaseResourcePropertiesArgs.builder()
                .backupInformation(SqlServerDatabaseResourcePropertiesBackupInformationArgs.builder()
                    .lastFullBackup("2022-05-05T16:26:33.883Z")
                    .lastLogBackup("2022-05-10T16:26:33.883Z")
                    .build())
                .backupPolicy(BackupPolicyArgs.builder()
                    .differentialBackupHours(12)
                    .fullBackupDays(1)
                    .retentionPeriodDays(1)
                    .transactionLogBackupMinutes(30)
                    .build())
                .collationName("SQL_Latin1_General_CP1_CI_AS")
                .compatibilityLevel(150)
                .createMode("PointInTimeRestore")
                .databaseCreationDate("2022-04-05T16:26:33.883Z")
                .databaseOptions(SqlServerDatabaseResourcePropertiesDatabaseOptionsArgs.builder()
                    .isAutoCloseOn(true)
                    .isAutoCreateStatsOn(true)
                    .isAutoShrinkOn(true)
                    .isAutoUpdateStatsOn(true)
                    .isEncrypted(true)
                    .isMemoryOptimizationEnabled(true)
                    .isRemoteDataArchiveEnabled(true)
                    .isTrustworthyOn(true)
                    .build())
                .isReadOnly(true)
                .recoveryMode("Full")
                .restorePointInTime("2022-05-05T16:26:33.883Z")
                .sizeMB(150)
                .sourceDatabaseId("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.AzureArcData/testSqlServerInstance/testsqlManagedInstance/databases/MyDatabase")
                .spaceAvailableMB(100)
                .state("Online")
                .build())
            .resourceGroupName("testrg")
            .sqlServerInstanceName("testSqlServerInstance")
            .tags(Map.of("mytag", "myval"))
            .build());
    }
}

Import

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

$ pulumi import azure-native:azurearcdata:SqlServerDatabase testdb /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.AzureArcData/sqlServerInstances/{sqlServerInstanceName}/databases/{databaseName}

Constructors

SqlServerDatabaseArgs

constructor(databaseName: Output<String>? = null, location: Output<String>? = null, properties: Output<SqlServerDatabaseResourcePropertiesArgs>? = null, resourceGroupName: Output<String>? = null, sqlServerInstanceName: Output<String>? = null, tags: Output<Map<String, String>>? = null)