Sql
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 2023-01-15-preview. Other available API versions: 2024-01-01, 2024-05-01-preview, 2025-03-01-preview.
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",
},
CollationName = "SQL_Latin1_General_CP1_CI_AS",
CompatibilityLevel = 150,
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,
SizeMB = 150,
SpaceAvailableMB = 100,
State = AzureNative.AzureArcData.DatabaseState.Online,
},
ResourceGroupName = "testrg",
SqlServerInstanceName = "testSqlServerInstance",
Tags =
{
{ "mytag", "myval" },
},
});
});Content copied to clipboard
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"),
},
CollationName: pulumi.String("SQL_Latin1_General_CP1_CI_AS"),
CompatibilityLevel: pulumi.Int(150),
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),
SizeMB: pulumi.Float64(150),
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
})
}Content copied to clipboard
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.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())
.collationName("SQL_Latin1_General_CP1_CI_AS")
.compatibilityLevel(150)
.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")
.sizeMB(150)
.spaceAvailableMB(100)
.state("Online")
.build())
.resourceGroupName("testrg")
.sqlServerInstanceName("testSqlServerInstance")
.tags(Map.of("mytag", "myval"))
.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:azurearcdata:SqlServerDatabase testdb /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.AzureArcData/sqlServerInstances/{sqlServerInstanceName}/databases/{databaseName}Content copied to clipboard