Azure Native

Pulumi Official
Package maintained by Pulumi
v1.64.0 published on Wednesday, May 4, 2022 by Pulumi

SqlServerInstance

A SqlServerInstance. API Version: 2021-06-01-preview.

Example Usage

Updates a SQL Server Instance tags.

using Pulumi;
using AzureNative = Pulumi.AzureNative;

class MyStack : Stack
{
    public MyStack()
    {
        var sqlServerInstance = new AzureNative.AzureArcData.SqlServerInstance("sqlServerInstance", new AzureNative.AzureArcData.SqlServerInstanceArgs
        {
            Location = "northeurope",
            Properties = new AzureNative.AzureArcData.Inputs.SqlServerInstancePropertiesArgs
            {
                Collation = "collation",
                ContainerResourceId = "Arc Machine Name",
                CurrentVersion = "2008 R2",
                Edition = "Developer",
                InstanceName = "name of instance",
                LicenseType = "Free",
                PatchLevel = "patchlevel",
                ProductId = "sql id",
                Status = "Connected",
                TcpDynamicPorts = "1433",
                TcpStaticPorts = "1433",
                VCore = "4",
                Version = "SQL Server 2017",
            },
            ResourceGroupName = "testrg",
            SqlServerInstanceName = "testsqlServerInstance",
            Tags = 
            {
                { "mytag", "myval" },
            },
        });
    }

}
package main

import (
	azurearcdata "github.com/pulumi/pulumi-azure-native/sdk/go/azure/azurearcdata"
	"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{
				Collation:           pulumi.String("collation"),
				ContainerResourceId: pulumi.String("Arc Machine Name"),
				CurrentVersion:      pulumi.String("2008 R2"),
				Edition:             pulumi.String("Developer"),
				InstanceName:        pulumi.String("name of instance"),
				LicenseType:         pulumi.String("Free"),
				PatchLevel:          pulumi.String("patchlevel"),
				ProductId:           pulumi.String("sql id"),
				Status:              pulumi.String("Connected"),
				TcpDynamicPorts:     pulumi.String("1433"),
				TcpStaticPorts:      pulumi.String("1433"),
				VCore:               pulumi.String("4"),
				Version:             pulumi.String("SQL Server 2017"),
			},
			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 java.util.*;
import java.io.*;
import java.nio.*;
import com.pulumi.*;

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(Map.ofEntries(
                Map.entry("collation", "collation"),
                Map.entry("containerResourceId", "Arc Machine Name"),
                Map.entry("currentVersion", "2008 R2"),
                Map.entry("edition", "Developer"),
                Map.entry("instanceName", "name of instance"),
                Map.entry("licenseType", "Free"),
                Map.entry("patchLevel", "patchlevel"),
                Map.entry("productId", "sql id"),
                Map.entry("status", "Connected"),
                Map.entry("tcpDynamicPorts", "1433"),
                Map.entry("tcpStaticPorts", "1433"),
                Map.entry("vCore", "4"),
                Map.entry("version", "SQL Server 2017")
            ))
            .resourceGroupName("testrg")
            .sqlServerInstanceName("testsqlServerInstance")
            .tags(Map.of("mytag", "myval"))
            .build());

        }
}
import pulumi
import pulumi_azure_native as azure_native

sql_server_instance = azure_native.azurearcdata.SqlServerInstance("sqlServerInstance",
    location="northeurope",
    properties=azure_native.azurearcdata.SqlServerInstancePropertiesArgs(
        collation="collation",
        container_resource_id="Arc Machine Name",
        current_version="2008 R2",
        edition="Developer",
        instance_name="name of instance",
        license_type="Free",
        patch_level="patchlevel",
        product_id="sql id",
        status="Connected",
        tcp_dynamic_ports="1433",
        tcp_static_ports="1433",
        v_core="4",
        version="SQL Server 2017",
    ),
    resource_group_name="testrg",
    sql_server_instance_name="testsqlServerInstance",
    tags={
        "mytag": "myval",
    })
import * as pulumi from "@pulumi/pulumi";
import * as azure_native from "@pulumi/azure-native";

const sqlServerInstance = new azure_native.azurearcdata.SqlServerInstance("sqlServerInstance", {
    location: "northeurope",
    properties: {
        collation: "collation",
        containerResourceId: "Arc Machine Name",
        currentVersion: "2008 R2",
        edition: "Developer",
        instanceName: "name of instance",
        licenseType: "Free",
        patchLevel: "patchlevel",
        productId: "sql id",
        status: "Connected",
        tcpDynamicPorts: "1433",
        tcpStaticPorts: "1433",
        vCore: "4",
        version: "SQL Server 2017",
    },
    resourceGroupName: "testrg",
    sqlServerInstanceName: "testsqlServerInstance",
    tags: {
        mytag: "myval",
    },
});
resources:
  sqlServerInstance:
    type: azure-native:azurearcdata:SqlServerInstance
    properties:
      location: northeurope
      properties:
        collation: collation
        containerResourceId: Arc Machine Name
        currentVersion: 2008 R2
        edition: Developer
        instanceName: name of instance
        licenseType: Free
        patchLevel: patchlevel
        productId: sql id
        status: Connected
        tcpDynamicPorts: 1433
        tcpStaticPorts: 1433
        vCore: 4
        version: SQL Server 2017
      resourceGroupName: testrg
      sqlServerInstanceName: testsqlServerInstance
      tags:
        mytag: myval

Create a SqlServerInstance Resource

new SqlServerInstance(name: string, args: SqlServerInstanceArgs, opts?: CustomResourceOptions);
@overload
def SqlServerInstance(resource_name: str,
                      opts: Optional[ResourceOptions] = None,
                      location: Optional[str] = None,
                      properties: Optional[SqlServerInstancePropertiesArgs] = None,
                      resource_group_name: Optional[str] = None,
                      sql_server_instance_name: Optional[str] = None,
                      tags: Optional[Mapping[str, str]] = None)
@overload
def SqlServerInstance(resource_name: str,
                      args: SqlServerInstanceArgs,
                      opts: Optional[ResourceOptions] = None)
func NewSqlServerInstance(ctx *Context, name string, args SqlServerInstanceArgs, opts ...ResourceOption) (*SqlServerInstance, error)
public SqlServerInstance(string name, SqlServerInstanceArgs args, CustomResourceOptions? opts = null)
public SqlServerInstance(String name, SqlServerInstanceArgs args)
public SqlServerInstance(String name, SqlServerInstanceArgs args, CustomResourceOptions options)
type: azure-native:azurearcdata:SqlServerInstance
properties: # The arguments to resource properties.
options: # Bag of options to control resource's behavior.

name string
The unique name of the resource.
args SqlServerInstanceArgs
The arguments to resource properties.
opts CustomResourceOptions
Bag of options to control resource's behavior.
resource_name str
The unique name of the resource.
args SqlServerInstanceArgs
The arguments to resource properties.
opts ResourceOptions
Bag of options to control resource's behavior.
ctx Context
Context object for the current deployment.
name string
The unique name of the resource.
args SqlServerInstanceArgs
The arguments to resource properties.
opts ResourceOption
Bag of options to control resource's behavior.
name string
The unique name of the resource.
args SqlServerInstanceArgs
The arguments to resource properties.
opts CustomResourceOptions
Bag of options to control resource's behavior.
name String
The unique name of the resource.
args SqlServerInstanceArgs
The arguments to resource properties.
options CustomResourceOptions
Bag of options to control resource's behavior.

SqlServerInstance Resource Properties

To learn more about resource properties and how to use them, see Inputs and Outputs in the Architecture and Concepts docs.

Inputs

The SqlServerInstance resource accepts the following input properties:

ResourceGroupName string

The name of the Azure resource group

Location string

The geo-location where the resource lives

Properties Pulumi.AzureNative.AzureArcData.Inputs.SqlServerInstancePropertiesArgs

null

SqlServerInstanceName string

The name of SQL Server Instance

Tags Dictionary<string, string>

Resource tags.

ResourceGroupName string

The name of the Azure resource group

Location string

The geo-location where the resource lives

Properties SqlServerInstancePropertiesArgs

null

SqlServerInstanceName string

The name of SQL Server Instance

Tags map[string]string

Resource tags.

resourceGroupName String

The name of the Azure resource group

location String

The geo-location where the resource lives

properties SqlServerInstancePropertiesArgs

null

sqlServerInstanceName String

The name of SQL Server Instance

tags Map

Resource tags.

resourceGroupName string

The name of the Azure resource group

location string

The geo-location where the resource lives

properties SqlServerInstancePropertiesArgs

null

sqlServerInstanceName string

The name of SQL Server Instance

tags {[key: string]: string}

Resource tags.

resource_group_name str

The name of the Azure resource group

location str

The geo-location where the resource lives

properties SqlServerInstancePropertiesArgs

null

sql_server_instance_name str

The name of SQL Server Instance

tags Mapping[str, str]

Resource tags.

resourceGroupName String

The name of the Azure resource group

location String

The geo-location where the resource lives

properties Property Map

null

sqlServerInstanceName String

The name of SQL Server Instance

tags Map

Resource tags.

Outputs

All input properties are implicitly available as output properties. Additionally, the SqlServerInstance resource produces the following output properties:

Id string

The provider-assigned unique ID for this managed resource.

Name string

The name of the resource

SystemData Pulumi.AzureNative.AzureArcData.Outputs.SystemDataResponse

Read only system data

Type string

The type of the resource. Ex- Microsoft.Compute/virtualMachines or Microsoft.Storage/storageAccounts.

Id string

The provider-assigned unique ID for this managed resource.

Name string

The name of the resource

SystemData SystemDataResponse

Read only system data

Type string

The type of the resource. Ex- Microsoft.Compute/virtualMachines or Microsoft.Storage/storageAccounts.

id String

The provider-assigned unique ID for this managed resource.

name String

The name of the resource

systemData SystemDataResponse

Read only system data

type String

The type of the resource. Ex- Microsoft.Compute/virtualMachines or Microsoft.Storage/storageAccounts.

id string

The provider-assigned unique ID for this managed resource.

name string

The name of the resource

systemData SystemDataResponse

Read only system data

type string

The type of the resource. Ex- Microsoft.Compute/virtualMachines or Microsoft.Storage/storageAccounts.

id str

The provider-assigned unique ID for this managed resource.

name str

The name of the resource

system_data SystemDataResponse

Read only system data

type str

The type of the resource. Ex- Microsoft.Compute/virtualMachines or Microsoft.Storage/storageAccounts.

id String

The provider-assigned unique ID for this managed resource.

name String

The name of the resource

systemData Property Map

Read only system data

type String

The type of the resource. Ex- Microsoft.Compute/virtualMachines or Microsoft.Storage/storageAccounts.

Supporting Types

SqlServerInstanceProperties

ContainerResourceId string

ARM Resource id of the container resource (Azure Arc for Servers).

Status string

The cloud connectivity status.

Collation string

SQL Server collation.

CurrentVersion string

SQL Server current version.

Edition string

SQL Server edition.

InstanceName string

SQL Server instance name.

LicenseType string

SQL Server license type.

PatchLevel string

SQL Server update level.

ProductId string

SQL Server product ID.

TcpDynamicPorts string

Dynamic TCP ports used by SQL Server.

TcpStaticPorts string

Static TCP ports used by SQL Server.

VCore string

The number of logical processors used by the SQL Server instance.

Version string

SQL Server version.

ContainerResourceId string

ARM Resource id of the container resource (Azure Arc for Servers).

Status string

The cloud connectivity status.

Collation string

SQL Server collation.

CurrentVersion string

SQL Server current version.

Edition string

SQL Server edition.

InstanceName string

SQL Server instance name.

LicenseType string

SQL Server license type.

PatchLevel string

SQL Server update level.

ProductId string

SQL Server product ID.

TcpDynamicPorts string

Dynamic TCP ports used by SQL Server.

TcpStaticPorts string

Static TCP ports used by SQL Server.

VCore string

The number of logical processors used by the SQL Server instance.

Version string

SQL Server version.

containerResourceId String

ARM Resource id of the container resource (Azure Arc for Servers).

status String

The cloud connectivity status.

collation String

SQL Server collation.

currentVersion String

SQL Server current version.

edition String

SQL Server edition.

instanceName String

SQL Server instance name.

licenseType String

SQL Server license type.

patchLevel String

SQL Server update level.

productId String

SQL Server product ID.

tcpDynamicPorts String

Dynamic TCP ports used by SQL Server.

tcpStaticPorts String

Static TCP ports used by SQL Server.

vCore String

The number of logical processors used by the SQL Server instance.

version String

SQL Server version.

containerResourceId string

ARM Resource id of the container resource (Azure Arc for Servers).

status string

The cloud connectivity status.

collation string

SQL Server collation.

currentVersion string

SQL Server current version.

edition string

SQL Server edition.

instanceName string

SQL Server instance name.

licenseType string

SQL Server license type.

patchLevel string

SQL Server update level.

productId string

SQL Server product ID.

tcpDynamicPorts string

Dynamic TCP ports used by SQL Server.

tcpStaticPorts string

Static TCP ports used by SQL Server.

vCore string

The number of logical processors used by the SQL Server instance.

version string

SQL Server version.

container_resource_id str

ARM Resource id of the container resource (Azure Arc for Servers).

status str

The cloud connectivity status.

collation str

SQL Server collation.

current_version str

SQL Server current version.

edition str

SQL Server edition.

instance_name str

SQL Server instance name.

license_type str

SQL Server license type.

patch_level str

SQL Server update level.

product_id str

SQL Server product ID.

tcp_dynamic_ports str

Dynamic TCP ports used by SQL Server.

tcp_static_ports str

Static TCP ports used by SQL Server.

v_core str

The number of logical processors used by the SQL Server instance.

version str

SQL Server version.

containerResourceId String

ARM Resource id of the container resource (Azure Arc for Servers).

status String

The cloud connectivity status.

collation String

SQL Server collation.

currentVersion String

SQL Server current version.

edition String

SQL Server edition.

instanceName String

SQL Server instance name.

licenseType String

SQL Server license type.

patchLevel String

SQL Server update level.

productId String

SQL Server product ID.

tcpDynamicPorts String

Dynamic TCP ports used by SQL Server.

tcpStaticPorts String

Static TCP ports used by SQL Server.

vCore String

The number of logical processors used by the SQL Server instance.

version String

SQL Server version.

SqlServerInstancePropertiesResponse

ContainerResourceId string

ARM Resource id of the container resource (Azure Arc for Servers).

CreateTime string

The time when the resource was created.

ProvisioningState string
Status string

The cloud connectivity status.

Collation string

SQL Server collation.

CurrentVersion string

SQL Server current version.

Edition string

SQL Server edition.

InstanceName string

SQL Server instance name.

LicenseType string

SQL Server license type.

PatchLevel string

SQL Server update level.

ProductId string

SQL Server product ID.

TcpDynamicPorts string

Dynamic TCP ports used by SQL Server.

TcpStaticPorts string

Static TCP ports used by SQL Server.

VCore string

The number of logical processors used by the SQL Server instance.

Version string

SQL Server version.

ContainerResourceId string

ARM Resource id of the container resource (Azure Arc for Servers).

CreateTime string

The time when the resource was created.

ProvisioningState string
Status string

The cloud connectivity status.

Collation string

SQL Server collation.

CurrentVersion string

SQL Server current version.

Edition string

SQL Server edition.

InstanceName string

SQL Server instance name.

LicenseType string

SQL Server license type.

PatchLevel string

SQL Server update level.

ProductId string

SQL Server product ID.

TcpDynamicPorts string

Dynamic TCP ports used by SQL Server.

TcpStaticPorts string

Static TCP ports used by SQL Server.

VCore string

The number of logical processors used by the SQL Server instance.

Version string

SQL Server version.

containerResourceId String

ARM Resource id of the container resource (Azure Arc for Servers).

createTime String

The time when the resource was created.

provisioningState String
status String

The cloud connectivity status.

collation String

SQL Server collation.

currentVersion String

SQL Server current version.

edition String

SQL Server edition.

instanceName String

SQL Server instance name.

licenseType String

SQL Server license type.

patchLevel String

SQL Server update level.

productId String

SQL Server product ID.

tcpDynamicPorts String

Dynamic TCP ports used by SQL Server.

tcpStaticPorts String

Static TCP ports used by SQL Server.

vCore String

The number of logical processors used by the SQL Server instance.

version String

SQL Server version.

containerResourceId string

ARM Resource id of the container resource (Azure Arc for Servers).

createTime string

The time when the resource was created.

provisioningState string
status string

The cloud connectivity status.

collation string

SQL Server collation.

currentVersion string

SQL Server current version.

edition string

SQL Server edition.

instanceName string

SQL Server instance name.

licenseType string

SQL Server license type.

patchLevel string

SQL Server update level.

productId string

SQL Server product ID.

tcpDynamicPorts string

Dynamic TCP ports used by SQL Server.

tcpStaticPorts string

Static TCP ports used by SQL Server.

vCore string

The number of logical processors used by the SQL Server instance.

version string

SQL Server version.

container_resource_id str

ARM Resource id of the container resource (Azure Arc for Servers).

create_time str

The time when the resource was created.

provisioning_state str
status str

The cloud connectivity status.

collation str

SQL Server collation.

current_version str

SQL Server current version.

edition str

SQL Server edition.

instance_name str

SQL Server instance name.

license_type str

SQL Server license type.

patch_level str

SQL Server update level.

product_id str

SQL Server product ID.

tcp_dynamic_ports str

Dynamic TCP ports used by SQL Server.

tcp_static_ports str

Static TCP ports used by SQL Server.

v_core str

The number of logical processors used by the SQL Server instance.

version str

SQL Server version.

containerResourceId String

ARM Resource id of the container resource (Azure Arc for Servers).

createTime String

The time when the resource was created.

provisioningState String
status String

The cloud connectivity status.

collation String

SQL Server collation.

currentVersion String

SQL Server current version.

edition String

SQL Server edition.

instanceName String

SQL Server instance name.

licenseType String

SQL Server license type.

patchLevel String

SQL Server update level.

productId String

SQL Server product ID.

tcpDynamicPorts String

Dynamic TCP ports used by SQL Server.

tcpStaticPorts String

Static TCP ports used by SQL Server.

vCore String

The number of logical processors used by the SQL Server instance.

version String

SQL Server version.

SystemDataResponse

CreatedAt string

The timestamp of resource creation (UTC)

CreatedBy string

An identifier for the identity that created the resource

CreatedByType string

The type of identity that created the resource

LastModifiedAt string

The timestamp of resource last modification (UTC)

LastModifiedBy string

An identifier for the identity that last modified the resource

LastModifiedByType string

The type of identity that last modified the resource

CreatedAt string

The timestamp of resource creation (UTC)

CreatedBy string

An identifier for the identity that created the resource

CreatedByType string

The type of identity that created the resource

LastModifiedAt string

The timestamp of resource last modification (UTC)

LastModifiedBy string

An identifier for the identity that last modified the resource

LastModifiedByType string

The type of identity that last modified the resource

createdAt String

The timestamp of resource creation (UTC)

createdBy String

An identifier for the identity that created the resource

createdByType String

The type of identity that created the resource

lastModifiedAt String

The timestamp of resource last modification (UTC)

lastModifiedBy String

An identifier for the identity that last modified the resource

lastModifiedByType String

The type of identity that last modified the resource

createdAt string

The timestamp of resource creation (UTC)

createdBy string

An identifier for the identity that created the resource

createdByType string

The type of identity that created the resource

lastModifiedAt string

The timestamp of resource last modification (UTC)

lastModifiedBy string

An identifier for the identity that last modified the resource

lastModifiedByType string

The type of identity that last modified the resource

created_at str

The timestamp of resource creation (UTC)

created_by str

An identifier for the identity that created the resource

created_by_type str

The type of identity that created the resource

last_modified_at str

The timestamp of resource last modification (UTC)

last_modified_by str

An identifier for the identity that last modified the resource

last_modified_by_type str

The type of identity that last modified the resource

createdAt String

The timestamp of resource creation (UTC)

createdBy String

An identifier for the identity that created the resource

createdByType String

The type of identity that created the resource

lastModifiedAt String

The timestamp of resource last modification (UTC)

lastModifiedBy String

An identifier for the identity that last modified the resource

lastModifiedByType String

The type of identity that last modified the resource

Import

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

$ pulumi import azure-native:azurearcdata:SqlServerInstance testsqlServerInstance /subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.AzureArcData/SqlServerInstances/testsqlServerInstance 

Package Details

Repository
https://github.com/pulumi/pulumi-azure-native
License
Apache-2.0