Sql
data class SqlServerInstanceArgs(val location: Output<String>? = null, val properties: Output<SqlServerInstancePropertiesArgs>? = null, val resourceGroupName: Output<String>? = null, val sqlServerInstanceName: Output<String>? = null, val tags: Output<Map<String, String>>? = null) : ConvertibleToJava<SqlServerInstanceArgs>
A SqlServerInstance. Uses Azure REST API version 2023-01-15-preview. In version 1.x of the Azure Native provider, it used API version 2021-06-01-preview. Other available API versions: 2024-01-01, 2024-05-01-preview, 2025-03-01-preview.
Example Usage
Updates a SQL Server Instance tags.
using System.Collections.Generic;
using System.Linq;
using Pulumi;
using AzureNative = Pulumi.AzureNative;
return await Deployment.RunAsync(() =>
{
var sqlServerInstance = new AzureNative.AzureArcData.SqlServerInstance("sqlServerInstance", new()
{
Location = "northeurope",
Properties = new AzureNative.AzureArcData.Inputs.SqlServerInstancePropertiesArgs
{
AzureDefenderStatus = AzureNative.AzureArcData.DefenderStatus.Protected,
AzureDefenderStatusLastUpdated = "2020-01-02T17:18:19.1234567Z",
Collation = "collation",
ContainerResourceId = "Resource id of hosting Arc Machine",
Cores = "4",
CurrentVersion = "2012",
Edition = AzureNative.AzureArcData.EditionType.Developer,
HostType = AzureNative.AzureArcData.HostType.Physical_Server,
InstanceName = "name of instance",
LicenseType = AzureNative.AzureArcData.ArcSqlServerLicenseType.Free,
PatchLevel = "patchlevel",
ProductId = "sql id",
Status = AzureNative.AzureArcData.ConnectionStatus.Registered,
TcpDynamicPorts = "1433",
TcpStaticPorts = "1433",
VCore = "4",
Version = AzureNative.AzureArcData.SqlVersion.SQL_Server_2012,
},
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.NewSqlServerInstance(ctx, "sqlServerInstance", &azurearcdata.SqlServerInstanceArgs{
Location: pulumi.String("northeurope"),
Properties: &azurearcdata.SqlServerInstancePropertiesArgs{
AzureDefenderStatus: pulumi.String(azurearcdata.DefenderStatusProtected),
AzureDefenderStatusLastUpdated: pulumi.String("2020-01-02T17:18:19.1234567Z"),
Collation: pulumi.String("collation"),
ContainerResourceId: pulumi.String("Resource id of hosting Arc Machine"),
Cores: pulumi.String("4"),
CurrentVersion: pulumi.String("2012"),
Edition: pulumi.String(azurearcdata.EditionTypeDeveloper),
HostType: pulumi.String(azurearcdata.HostType_Physical_Server),
InstanceName: pulumi.String("name of instance"),
LicenseType: pulumi.String(azurearcdata.ArcSqlServerLicenseTypeFree),
PatchLevel: pulumi.String("patchlevel"),
ProductId: pulumi.String("sql id"),
Status: pulumi.String(azurearcdata.ConnectionStatusRegistered),
TcpDynamicPorts: pulumi.String("1433"),
TcpStaticPorts: pulumi.String("1433"),
VCore: pulumi.String("4"),
Version: pulumi.String(azurearcdata.SqlVersion_SQL_Server_2012),
},
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.SqlServerInstance;
import com.pulumi.azurenative.azurearcdata.SqlServerInstanceArgs;
import com.pulumi.azurenative.azurearcdata.inputs.SqlServerInstancePropertiesArgs;
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 sqlServerInstance = new SqlServerInstance("sqlServerInstance", SqlServerInstanceArgs.builder()
.location("northeurope")
.properties(SqlServerInstancePropertiesArgs.builder()
.azureDefenderStatus("Protected")
.azureDefenderStatusLastUpdated("2020-01-02T17:18:19.1234567Z")
.collation("collation")
.containerResourceId("Resource id of hosting Arc Machine")
.cores("4")
.currentVersion("2012")
.edition("Developer")
.hostType("Physical Server")
.instanceName("name of instance")
.licenseType("Free")
.patchLevel("patchlevel")
.productId("sql id")
.status("Registered")
.tcpDynamicPorts("1433")
.tcpStaticPorts("1433")
.vCore("4")
.version("SQL Server 2012")
.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:SqlServerInstance testsqlServerInstance /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.AzureArcData/sqlServerInstances/{sqlServerInstanceName}Content copied to clipboard