SqlServerInstance

class SqlServerInstance : KotlinCustomResource

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" },
},
});
});
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
})
}
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());
}
}

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}

Properties

Link copied to clipboard
val id: Output<String>
Link copied to clipboard
val location: Output<String>

The geo-location where the resource lives

Link copied to clipboard
val name: Output<String>

The name of the resource

Link copied to clipboard
Link copied to clipboard
val pulumiChildResources: Set<KotlinResource>
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard

Azure Resource Manager metadata containing createdBy and modifiedBy information.

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

Resource tags.

Link copied to clipboard
val type: Output<String>

The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"

Link copied to clipboard
val urn: Output<String>