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 Azure REST API version: 2023-01-15-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 = "Full",
SizeMB = 150,
SpaceAvailableMB = 100,
State = "Online",
},
ResourceGroupName = "testrg",
SqlServerInstanceName = "testSqlServerInstance",
Tags =
{
{ "mytag", "myval" },
},
});
});Content copied to clipboard
package main
import (
"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.SqlServerDatabaseResourcePropertiesResponse{
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("Full"),
SizeMB: pulumi.Float64(150),
SpaceAvailableMB: pulumi.Float64(100),
State: pulumi.String("Online"),
},
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 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(Map.ofEntries(
Map.entry("backupInformation", Map.ofEntries(
Map.entry("lastFullBackup", "2022-05-05T16:26:33.883Z"),
Map.entry("lastLogBackup", "2022-05-10T16:26:33.883Z")
)),
Map.entry("collationName", "SQL_Latin1_General_CP1_CI_AS"),
Map.entry("compatibilityLevel", 150),
Map.entry("databaseCreationDate", "2022-04-05T16:26:33.883Z"),
Map.entry("databaseOptions", Map.ofEntries(
Map.entry("isAutoCloseOn", true),
Map.entry("isAutoCreateStatsOn", true),
Map.entry("isAutoShrinkOn", true),
Map.entry("isAutoUpdateStatsOn", true),
Map.entry("isEncrypted", true),
Map.entry("isMemoryOptimizationEnabled", true),
Map.entry("isRemoteDataArchiveEnabled", true),
Map.entry("isTrustworthyOn", true)
)),
Map.entry("isReadOnly", true),
Map.entry("recoveryMode", "Full"),
Map.entry("sizeMB", 150),
Map.entry("spaceAvailableMB", 100),
Map.entry("state", "Online")
))
.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
Constructors
Link copied to clipboard
fun SqlServerDatabaseArgs(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)