azure-native.azurearcdata.SqlServerInstance
Explore with Pulumi AI
A SqlServerInstance. Azure REST API version: 2023-01-15-preview. Prior API version in Azure Native 1.x: 2021-06-01-preview.
Other available API versions: 2024-01-01.
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 pulumi
import pulumi_azure_native as azure_native
sql_server_instance = azure_native.azurearcdata.SqlServerInstance("sqlServerInstance",
location="northeurope",
properties={
"azure_defender_status": azure_native.azurearcdata.DefenderStatus.PROTECTED,
"azure_defender_status_last_updated": "2020-01-02T17:18:19.1234567Z",
"collation": "collation",
"container_resource_id": "Resource id of hosting Arc Machine",
"cores": "4",
"current_version": "2012",
"edition": azure_native.azurearcdata.EditionType.DEVELOPER,
"host_type": azure_native.azurearcdata.HostType.PHYSICAL_SERVER,
"instance_name": "name of instance",
"license_type": azure_native.azurearcdata.ArcSqlServerLicenseType.FREE,
"patch_level": "patchlevel",
"product_id": "sql id",
"status": azure_native.azurearcdata.ConnectionStatus.REGISTERED,
"tcp_dynamic_ports": "1433",
"tcp_static_ports": "1433",
"v_core": "4",
"version": azure_native.azurearcdata.SqlVersion.SQ_L_SERVER_2012,
},
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: {
azureDefenderStatus: azure_native.azurearcdata.DefenderStatus.Protected,
azureDefenderStatusLastUpdated: "2020-01-02T17:18:19.1234567Z",
collation: "collation",
containerResourceId: "Resource id of hosting Arc Machine",
cores: "4",
currentVersion: "2012",
edition: azure_native.azurearcdata.EditionType.Developer,
hostType: azure_native.azurearcdata.HostType.Physical_Server,
instanceName: "name of instance",
licenseType: azure_native.azurearcdata.ArcSqlServerLicenseType.Free,
patchLevel: "patchlevel",
productId: "sql id",
status: azure_native.azurearcdata.ConnectionStatus.Registered,
tcpDynamicPorts: "1433",
tcpStaticPorts: "1433",
vCore: "4",
version: azure_native.azurearcdata.SqlVersion.SQL_Server_2012,
},
resourceGroupName: "testrg",
sqlServerInstanceName: "testsqlServerInstance",
tags: {
mytag: "myval",
},
});
resources:
sqlServerInstance:
type: azure-native:azurearcdata:SqlServerInstance
properties:
location: northeurope
properties:
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
resourceGroupName: testrg
sqlServerInstanceName: testsqlServerInstance
tags:
mytag: myval
Create SqlServerInstance Resource
Resources are created with functions called constructors. To learn more about declaring and configuring resources, see Resources.
Constructor syntax
new SqlServerInstance(name: string, args: SqlServerInstanceArgs, opts?: CustomResourceOptions);
@overload
def SqlServerInstance(resource_name: str,
args: SqlServerInstanceArgs,
opts: Optional[ResourceOptions] = None)
@overload
def SqlServerInstance(resource_name: str,
opts: Optional[ResourceOptions] = None,
resource_group_name: Optional[str] = None,
location: Optional[str] = None,
properties: Optional[SqlServerInstancePropertiesArgs] = None,
sql_server_instance_name: Optional[str] = None,
tags: Optional[Mapping[str, str]] = 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.
Parameters
- 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.
Constructor example
The following reference example uses placeholder values for all input properties.
var sqlServerInstanceResource = new AzureNative.AzureArcData.SqlServerInstance("sqlServerInstanceResource", new()
{
ResourceGroupName = "string",
Location = "string",
Properties = new AzureNative.AzureArcData.Inputs.SqlServerInstancePropertiesArgs
{
ContainerResourceId = "string",
Status = "string",
Cores = "string",
LicenseType = "string",
AzureDefenderStatus = "string",
CurrentVersion = "string",
Edition = "string",
HostType = "string",
InstanceName = "string",
Collation = "string",
PatchLevel = "string",
ProductId = "string",
AzureDefenderStatusLastUpdated = "string",
TcpDynamicPorts = "string",
TcpStaticPorts = "string",
VCore = "string",
Version = "string",
},
SqlServerInstanceName = "string",
Tags =
{
{ "string", "string" },
},
});
example, err := azurearcdata.NewSqlServerInstance(ctx, "sqlServerInstanceResource", &azurearcdata.SqlServerInstanceArgs{
ResourceGroupName: pulumi.String("string"),
Location: pulumi.String("string"),
Properties: &azurearcdata.SqlServerInstancePropertiesArgs{
ContainerResourceId: pulumi.String("string"),
Status: pulumi.String("string"),
Cores: pulumi.String("string"),
LicenseType: pulumi.String("string"),
AzureDefenderStatus: pulumi.String("string"),
CurrentVersion: pulumi.String("string"),
Edition: pulumi.String("string"),
HostType: pulumi.String("string"),
InstanceName: pulumi.String("string"),
Collation: pulumi.String("string"),
PatchLevel: pulumi.String("string"),
ProductId: pulumi.String("string"),
AzureDefenderStatusLastUpdated: pulumi.String("string"),
TcpDynamicPorts: pulumi.String("string"),
TcpStaticPorts: pulumi.String("string"),
VCore: pulumi.String("string"),
Version: pulumi.String("string"),
},
SqlServerInstanceName: pulumi.String("string"),
Tags: pulumi.StringMap{
"string": pulumi.String("string"),
},
})
var sqlServerInstanceResource = new SqlServerInstance("sqlServerInstanceResource", SqlServerInstanceArgs.builder()
.resourceGroupName("string")
.location("string")
.properties(SqlServerInstancePropertiesArgs.builder()
.containerResourceId("string")
.status("string")
.cores("string")
.licenseType("string")
.azureDefenderStatus("string")
.currentVersion("string")
.edition("string")
.hostType("string")
.instanceName("string")
.collation("string")
.patchLevel("string")
.productId("string")
.azureDefenderStatusLastUpdated("string")
.tcpDynamicPorts("string")
.tcpStaticPorts("string")
.vCore("string")
.version("string")
.build())
.sqlServerInstanceName("string")
.tags(Map.of("string", "string"))
.build());
sql_server_instance_resource = azure_native.azurearcdata.SqlServerInstance("sqlServerInstanceResource",
resource_group_name="string",
location="string",
properties={
"containerResourceId": "string",
"status": "string",
"cores": "string",
"licenseType": "string",
"azureDefenderStatus": "string",
"currentVersion": "string",
"edition": "string",
"hostType": "string",
"instanceName": "string",
"collation": "string",
"patchLevel": "string",
"productId": "string",
"azureDefenderStatusLastUpdated": "string",
"tcpDynamicPorts": "string",
"tcpStaticPorts": "string",
"vCore": "string",
"version": "string",
},
sql_server_instance_name="string",
tags={
"string": "string",
})
const sqlServerInstanceResource = new azure_native.azurearcdata.SqlServerInstance("sqlServerInstanceResource", {
resourceGroupName: "string",
location: "string",
properties: {
containerResourceId: "string",
status: "string",
cores: "string",
licenseType: "string",
azureDefenderStatus: "string",
currentVersion: "string",
edition: "string",
hostType: "string",
instanceName: "string",
collation: "string",
patchLevel: "string",
productId: "string",
azureDefenderStatusLastUpdated: "string",
tcpDynamicPorts: "string",
tcpStaticPorts: "string",
vCore: "string",
version: "string",
},
sqlServerInstanceName: "string",
tags: {
string: "string",
},
});
type: azure-native:azurearcdata:SqlServerInstance
properties:
location: string
properties:
azureDefenderStatus: string
azureDefenderStatusLastUpdated: string
collation: string
containerResourceId: string
cores: string
currentVersion: string
edition: string
hostType: string
instanceName: string
licenseType: string
patchLevel: string
productId: string
status: string
tcpDynamicPorts: string
tcpStaticPorts: string
vCore: string
version: string
resourceGroupName: string
sqlServerInstanceName: string
tags:
string: string
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:
- Resource
Group stringName - The name of the Azure resource group
- Location string
- The geo-location where the resource lives
- Properties
Pulumi.
Azure Native. Azure Arc Data. Inputs. Sql Server Instance Properties - null
- Sql
Server stringInstance Name - Name of SQL Server Instance
- Dictionary<string, string>
- Resource tags.
- Resource
Group stringName - The name of the Azure resource group
- Location string
- The geo-location where the resource lives
- Properties
Sql
Server Instance Properties Args - null
- Sql
Server stringInstance Name - Name of SQL Server Instance
- map[string]string
- Resource tags.
- resource
Group StringName - The name of the Azure resource group
- location String
- The geo-location where the resource lives
- properties
Sql
Server Instance Properties - null
- sql
Server StringInstance Name - Name of SQL Server Instance
- Map<String,String>
- Resource tags.
- resource
Group stringName - The name of the Azure resource group
- location string
- The geo-location where the resource lives
- properties
Sql
Server Instance Properties - null
- sql
Server stringInstance Name - Name of SQL Server Instance
- {[key: string]: string}
- Resource tags.
- resource_
group_ strname - The name of the Azure resource group
- location str
- The geo-location where the resource lives
- properties
Sql
Server Instance Properties Args - null
- sql_
server_ strinstance_ name - Name of SQL Server Instance
- Mapping[str, str]
- Resource tags.
- resource
Group StringName - The name of the Azure resource group
- location String
- The geo-location where the resource lives
- properties Property Map
- null
- sql
Server StringInstance Name - Name of SQL Server Instance
- Map<String>
- 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
- System
Data Pulumi.Azure Native. Azure Arc Data. Outputs. System Data Response - Azure Resource Manager metadata containing createdBy and modifiedBy information.
- Type string
- The type of the resource. E.g. "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
- System
Data SystemData Response - Azure Resource Manager metadata containing createdBy and modifiedBy information.
- Type string
- The type of the resource. E.g. "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
- system
Data SystemData Response - Azure Resource Manager metadata containing createdBy and modifiedBy information.
- type String
- The type of the resource. E.g. "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
- system
Data SystemData Response - Azure Resource Manager metadata containing createdBy and modifiedBy information.
- type string
- The type of the resource. E.g. "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 SystemData Response - Azure Resource Manager metadata containing createdBy and modifiedBy information.
- type str
- The type of the resource. E.g. "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
- system
Data Property Map - Azure Resource Manager metadata containing createdBy and modifiedBy information.
- type String
- The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"
Supporting Types
ArcSqlServerLicenseType, ArcSqlServerLicenseTypeArgs
- Undefined
- Undefined
- Free
- Free
- HADR
- HADR
- Server
CAL - ServerCAL
- License
Only - LicenseOnly
- PAYG
- PAYG
- Paid
- Paid
- Arc
Sql Server License Type Undefined - Undefined
- Arc
Sql Server License Type Free - Free
- Arc
Sql Server License Type HADR - HADR
- Arc
Sql Server License Type Server CAL - ServerCAL
- Arc
Sql Server License Type License Only - LicenseOnly
- Arc
Sql Server License Type PAYG - PAYG
- Arc
Sql Server License Type Paid - Paid
- Undefined
- Undefined
- Free
- Free
- HADR
- HADR
- Server
CAL - ServerCAL
- License
Only - LicenseOnly
- PAYG
- PAYG
- Paid
- Paid
- Undefined
- Undefined
- Free
- Free
- HADR
- HADR
- Server
CAL - ServerCAL
- License
Only - LicenseOnly
- PAYG
- PAYG
- Paid
- Paid
- UNDEFINED
- Undefined
- FREE
- Free
- HADR
- HADR
- SERVER_CAL
- ServerCAL
- LICENSE_ONLY
- LicenseOnly
- PAYG
- PAYG
- PAID
- Paid
- "Undefined"
- Undefined
- "Free"
- Free
- "HADR"
- HADR
- "Server
CAL" - ServerCAL
- "License
Only" - LicenseOnly
- "PAYG"
- PAYG
- "Paid"
- Paid
ConnectionStatus, ConnectionStatusArgs
- Connected
- Connected
- Disconnected
- Disconnected
- Registered
- Registered
- Unknown
- Unknown
- Connection
Status Connected - Connected
- Connection
Status Disconnected - Disconnected
- Connection
Status Registered - Registered
- Connection
Status Unknown - Unknown
- Connected
- Connected
- Disconnected
- Disconnected
- Registered
- Registered
- Unknown
- Unknown
- Connected
- Connected
- Disconnected
- Disconnected
- Registered
- Registered
- Unknown
- Unknown
- CONNECTED
- Connected
- DISCONNECTED
- Disconnected
- REGISTERED
- Registered
- UNKNOWN
- Unknown
- "Connected"
- Connected
- "Disconnected"
- Disconnected
- "Registered"
- Registered
- "Unknown"
- Unknown
DefenderStatus, DefenderStatusArgs
- Protected
- Protected
- Unprotected
- Unprotected
- Unknown
- Unknown
- Defender
Status Protected - Protected
- Defender
Status Unprotected - Unprotected
- Defender
Status Unknown - Unknown
- Protected
- Protected
- Unprotected
- Unprotected
- Unknown
- Unknown
- Protected
- Protected
- Unprotected
- Unprotected
- Unknown
- Unknown
- PROTECTED
- Protected
- UNPROTECTED
- Unprotected
- UNKNOWN
- Unknown
- "Protected"
- Protected
- "Unprotected"
- Unprotected
- "Unknown"
- Unknown
EditionType, EditionTypeArgs
- Evaluation
- Evaluation
- Enterprise
- Enterprise
- Standard
- Standard
- Web
- Web
- Developer
- Developer
- Express
- Express
- Business_Intelligence
- Business Intelligence
- Edition
Type Evaluation - Evaluation
- Edition
Type Enterprise - Enterprise
- Edition
Type Standard - Standard
- Edition
Type Web - Web
- Edition
Type Developer - Developer
- Edition
Type Express - Express
- Edition
Type_Business_Intelligence - Business Intelligence
- Evaluation
- Evaluation
- Enterprise
- Enterprise
- Standard
- Standard
- Web
- Web
- Developer
- Developer
- Express
- Express
- Business_Intelligence
- Business Intelligence
- Evaluation
- Evaluation
- Enterprise
- Enterprise
- Standard
- Standard
- Web
- Web
- Developer
- Developer
- Express
- Express
- Business_Intelligence
- Business Intelligence
- EVALUATION
- Evaluation
- ENTERPRISE
- Enterprise
- STANDARD
- Standard
- WEB
- Web
- DEVELOPER
- Developer
- EXPRESS
- Express
- BUSINESS_INTELLIGENCE
- Business Intelligence
- "Evaluation"
- Evaluation
- "Enterprise"
- Enterprise
- "Standard"
- Standard
- "Web"
- Web
- "Developer"
- Developer
- "Express"
- Express
- "Business Intelligence"
- Business Intelligence
HostType, HostTypeArgs
- Azure_Virtual_Machine
- Azure Virtual Machine
- Azure_VMWare_Virtual_Machine
- Azure VMWare Virtual Machine
- Azure_Kubernetes_Service
- Azure Kubernetes Service
- AWS_VMWare_Virtual_Machine
- AWS VMWare Virtual Machine
- AWS_Kubernetes_Service
- AWS Kubernetes Service
- GCP_VMWare_Virtual_Machine
- GCP VMWare Virtual Machine
- GCP_Kubernetes_Service
- GCP Kubernetes Service
- Container
- Container
- Virtual_Machine
- Virtual Machine
- Physical_Server
- Physical Server
- AWS_Virtual_Machine
- AWS Virtual Machine
- GCP_Virtual_Machine
- GCP Virtual Machine
- Other
- Other
- Host
Type_Azure_Virtual_Machine - Azure Virtual Machine
- Host
Type_Azure_VMWare_Virtual_Machine - Azure VMWare Virtual Machine
- Host
Type_Azure_Kubernetes_Service - Azure Kubernetes Service
- Host
Type_AWS_VMWare_Virtual_Machine - AWS VMWare Virtual Machine
- Host
Type_AWS_Kubernetes_Service - AWS Kubernetes Service
- Host
Type_GCP_VMWare_Virtual_Machine - GCP VMWare Virtual Machine
- Host
Type_GCP_Kubernetes_Service - GCP Kubernetes Service
- Host
Type Container - Container
- Host
Type_Virtual_Machine - Virtual Machine
- Host
Type_Physical_Server - Physical Server
- Host
Type_AWS_Virtual_Machine - AWS Virtual Machine
- Host
Type_GCP_Virtual_Machine - GCP Virtual Machine
- Host
Type Other - Other
- Azure_Virtual_Machine
- Azure Virtual Machine
- Azure_VMWare_Virtual_Machine
- Azure VMWare Virtual Machine
- Azure_Kubernetes_Service
- Azure Kubernetes Service
- AWS_VMWare_Virtual_Machine
- AWS VMWare Virtual Machine
- AWS_Kubernetes_Service
- AWS Kubernetes Service
- GCP_VMWare_Virtual_Machine
- GCP VMWare Virtual Machine
- GCP_Kubernetes_Service
- GCP Kubernetes Service
- Container
- Container
- Virtual_Machine
- Virtual Machine
- Physical_Server
- Physical Server
- AWS_Virtual_Machine
- AWS Virtual Machine
- GCP_Virtual_Machine
- GCP Virtual Machine
- Other
- Other
- Azure_Virtual_Machine
- Azure Virtual Machine
- Azure_VMWare_Virtual_Machine
- Azure VMWare Virtual Machine
- Azure_Kubernetes_Service
- Azure Kubernetes Service
- AWS_VMWare_Virtual_Machine
- AWS VMWare Virtual Machine
- AWS_Kubernetes_Service
- AWS Kubernetes Service
- GCP_VMWare_Virtual_Machine
- GCP VMWare Virtual Machine
- GCP_Kubernetes_Service
- GCP Kubernetes Service
- Container
- Container
- Virtual_Machine
- Virtual Machine
- Physical_Server
- Physical Server
- AWS_Virtual_Machine
- AWS Virtual Machine
- GCP_Virtual_Machine
- GCP Virtual Machine
- Other
- Other
- AZURE_VIRTUAL_MACHINE
- Azure Virtual Machine
- AZURE_VM_WARE_VIRTUAL_MACHINE
- Azure VMWare Virtual Machine
- AZURE_KUBERNETES_SERVICE
- Azure Kubernetes Service
- AW_S_VM_WARE_VIRTUAL_MACHINE
- AWS VMWare Virtual Machine
- AW_S_KUBERNETES_SERVICE
- AWS Kubernetes Service
- GC_P_VM_WARE_VIRTUAL_MACHINE
- GCP VMWare Virtual Machine
- GC_P_KUBERNETES_SERVICE
- GCP Kubernetes Service
- CONTAINER
- Container
- VIRTUAL_MACHINE
- Virtual Machine
- PHYSICAL_SERVER
- Physical Server
- AW_S_VIRTUAL_MACHINE
- AWS Virtual Machine
- GC_P_VIRTUAL_MACHINE
- GCP Virtual Machine
- OTHER
- Other
- "Azure Virtual Machine"
- Azure Virtual Machine
- "Azure VMWare Virtual Machine"
- Azure VMWare Virtual Machine
- "Azure Kubernetes Service"
- Azure Kubernetes Service
- "AWS VMWare Virtual Machine"
- AWS VMWare Virtual Machine
- "AWS Kubernetes Service"
- AWS Kubernetes Service
- "GCP VMWare Virtual Machine"
- GCP VMWare Virtual Machine
- "GCP Kubernetes Service"
- GCP Kubernetes Service
- "Container"
- Container
- "Virtual Machine"
- Virtual Machine
- "Physical Server"
- Physical Server
- "AWS Virtual Machine"
- AWS Virtual Machine
- "GCP Virtual Machine"
- GCP Virtual Machine
- "Other"
- Other
SqlServerInstanceProperties, SqlServerInstancePropertiesArgs
- Container
Resource stringId - ARM Resource id of the container resource (Azure Arc for Servers).
- Status
string | Pulumi.
Azure Native. Azure Arc Data. Connection Status - The cloud connectivity status.
- Azure
Defender string | Pulumi.Status Azure Native. Azure Arc Data. Defender Status - Status of Azure Defender.
- Azure
Defender stringStatus Last Updated - Timestamp of last Azure Defender status update.
- Collation string
- SQL Server collation.
- Cores string
- The number of total cores of the Operating System Environment (OSE) hosting the SQL Server instance.
- Current
Version string - SQL Server current version.
- Edition
string | Pulumi.
Azure Native. Azure Arc Data. Edition Type - SQL Server edition.
- Host
Type string | Pulumi.Azure Native. Azure Arc Data. Host Type - Type of host for Azure Arc SQL Server
- Instance
Name string - SQL Server instance name.
- License
Type string | Pulumi.Azure Native. Azure Arc Data. Arc Sql Server License Type - SQL Server license type.
- Patch
Level string - SQL Server update level.
- Product
Id string - SQL Server product ID.
- Tcp
Dynamic stringPorts - Dynamic TCP ports used by SQL Server.
- Tcp
Static stringPorts - Static TCP ports used by SQL Server.
- VCore string
- The number of logical processors used by the SQL Server instance.
- Version
string | Pulumi.
Azure Native. Azure Arc Data. Sql Version - SQL Server version.
- Container
Resource stringId - ARM Resource id of the container resource (Azure Arc for Servers).
- Status
string | Connection
Status - The cloud connectivity status.
- Azure
Defender string | DefenderStatus Status - Status of Azure Defender.
- Azure
Defender stringStatus Last Updated - Timestamp of last Azure Defender status update.
- Collation string
- SQL Server collation.
- Cores string
- The number of total cores of the Operating System Environment (OSE) hosting the SQL Server instance.
- Current
Version string - SQL Server current version.
- Edition
string | Edition
Type - SQL Server edition.
- Host
Type string | HostType - Type of host for Azure Arc SQL Server
- Instance
Name string - SQL Server instance name.
- License
Type string | ArcSql Server License Type - SQL Server license type.
- Patch
Level string - SQL Server update level.
- Product
Id string - SQL Server product ID.
- Tcp
Dynamic stringPorts - Dynamic TCP ports used by SQL Server.
- Tcp
Static stringPorts - Static TCP ports used by SQL Server.
- VCore string
- The number of logical processors used by the SQL Server instance.
- Version
string | Sql
Version - SQL Server version.
- container
Resource StringId - ARM Resource id of the container resource (Azure Arc for Servers).
- status
String | Connection
Status - The cloud connectivity status.
- azure
Defender String | DefenderStatus Status - Status of Azure Defender.
- azure
Defender StringStatus Last Updated - Timestamp of last Azure Defender status update.
- collation String
- SQL Server collation.
- cores String
- The number of total cores of the Operating System Environment (OSE) hosting the SQL Server instance.
- current
Version String - SQL Server current version.
- edition
String | Edition
Type - SQL Server edition.
- host
Type String | HostType - Type of host for Azure Arc SQL Server
- instance
Name String - SQL Server instance name.
- license
Type String | ArcSql Server License Type - SQL Server license type.
- patch
Level String - SQL Server update level.
- product
Id String - SQL Server product ID.
- tcp
Dynamic StringPorts - Dynamic TCP ports used by SQL Server.
- tcp
Static StringPorts - Static TCP ports used by SQL Server.
- v
Core String - The number of logical processors used by the SQL Server instance.
- version
String | Sql
Version - SQL Server version.
- container
Resource stringId - ARM Resource id of the container resource (Azure Arc for Servers).
- status
string | Connection
Status - The cloud connectivity status.
- azure
Defender string | DefenderStatus Status - Status of Azure Defender.
- azure
Defender stringStatus Last Updated - Timestamp of last Azure Defender status update.
- collation string
- SQL Server collation.
- cores string
- The number of total cores of the Operating System Environment (OSE) hosting the SQL Server instance.
- current
Version string - SQL Server current version.
- edition
string | Edition
Type - SQL Server edition.
- host
Type string | HostType - Type of host for Azure Arc SQL Server
- instance
Name string - SQL Server instance name.
- license
Type string | ArcSql Server License Type - SQL Server license type.
- patch
Level string - SQL Server update level.
- product
Id string - SQL Server product ID.
- tcp
Dynamic stringPorts - Dynamic TCP ports used by SQL Server.
- tcp
Static stringPorts - Static TCP ports used by SQL Server.
- v
Core string - The number of logical processors used by the SQL Server instance.
- version
string | Sql
Version - SQL Server version.
- container_
resource_ strid - ARM Resource id of the container resource (Azure Arc for Servers).
- status
str | Connection
Status - The cloud connectivity status.
- azure_
defender_ str | Defenderstatus Status - Status of Azure Defender.
- azure_
defender_ strstatus_ last_ updated - Timestamp of last Azure Defender status update.
- collation str
- SQL Server collation.
- cores str
- The number of total cores of the Operating System Environment (OSE) hosting the SQL Server instance.
- current_
version str - SQL Server current version.
- edition
str | Edition
Type - SQL Server edition.
- host_
type str | HostType - Type of host for Azure Arc SQL Server
- instance_
name str - SQL Server instance name.
- license_
type str | ArcSql Server License Type - SQL Server license type.
- patch_
level str - SQL Server update level.
- product_
id str - SQL Server product ID.
- tcp_
dynamic_ strports - Dynamic TCP ports used by SQL Server.
- tcp_
static_ strports - Static TCP ports used by SQL Server.
- v_
core str - The number of logical processors used by the SQL Server instance.
- version
str | Sql
Version - SQL Server version.
- container
Resource StringId - ARM Resource id of the container resource (Azure Arc for Servers).
- status String | "Connected" | "Disconnected" | "Registered" | "Unknown"
- The cloud connectivity status.
- azure
Defender String | "Protected" | "Unprotected" | "Unknown"Status - Status of Azure Defender.
- azure
Defender StringStatus Last Updated - Timestamp of last Azure Defender status update.
- collation String
- SQL Server collation.
- cores String
- The number of total cores of the Operating System Environment (OSE) hosting the SQL Server instance.
- current
Version String - SQL Server current version.
- edition String | "Evaluation" | "Enterprise" | "Standard" | "Web" | "Developer" | "Express" | "Business Intelligence"
- SQL Server edition.
- host
Type String | "Azure Virtual Machine" | "Azure VMWare Virtual Machine" | "Azure Kubernetes Service" | "AWS VMWare Virtual Machine" | "AWS Kubernetes Service" | "GCP VMWare Virtual Machine" | "GCP Kubernetes Service" | "Container" | "Virtual Machine" | "Physical Server" | "AWS Virtual Machine" | "GCP Virtual Machine" | "Other" - Type of host for Azure Arc SQL Server
- instance
Name String - SQL Server instance name.
- license
Type String | "Undefined" | "Free" | "HADR" | "ServerCAL" | "License Only" | "PAYG" | "Paid" - SQL Server license type.
- patch
Level String - SQL Server update level.
- product
Id String - SQL Server product ID.
- tcp
Dynamic StringPorts - Dynamic TCP ports used by SQL Server.
- tcp
Static StringPorts - Static TCP ports used by SQL Server.
- v
Core String - The number of logical processors used by the SQL Server instance.
- version String | "SQL Server 2012" | "SQL Server 2014" | "SQL Server 2016" | "SQL Server 2017" | "SQL Server 2019" | "SQL Server 2022" | "Unknown"
- SQL Server version.
SqlServerInstancePropertiesResponse, SqlServerInstancePropertiesResponseArgs
- Container
Resource stringId - ARM Resource id of the container resource (Azure Arc for Servers).
- Create
Time string - The time when the resource was created.
- Provisioning
State string - The provisioning state of the Arc-enabled SQL Server resource.
- Status string
- The cloud connectivity status.
- Azure
Defender stringStatus - Status of Azure Defender.
- Azure
Defender stringStatus Last Updated - Timestamp of last Azure Defender status update.
- Collation string
- SQL Server collation.
- Cores string
- The number of total cores of the Operating System Environment (OSE) hosting the SQL Server instance.
- Current
Version string - SQL Server current version.
- Edition string
- SQL Server edition.
- Host
Type string - Type of host for Azure Arc SQL Server
- Instance
Name string - SQL Server instance name.
- License
Type string - SQL Server license type.
- Patch
Level string - SQL Server update level.
- Product
Id string - SQL Server product ID.
- Tcp
Dynamic stringPorts - Dynamic TCP ports used by SQL Server.
- Tcp
Static stringPorts - 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 stringId - ARM Resource id of the container resource (Azure Arc for Servers).
- Create
Time string - The time when the resource was created.
- Provisioning
State string - The provisioning state of the Arc-enabled SQL Server resource.
- Status string
- The cloud connectivity status.
- Azure
Defender stringStatus - Status of Azure Defender.
- Azure
Defender stringStatus Last Updated - Timestamp of last Azure Defender status update.
- Collation string
- SQL Server collation.
- Cores string
- The number of total cores of the Operating System Environment (OSE) hosting the SQL Server instance.
- Current
Version string - SQL Server current version.
- Edition string
- SQL Server edition.
- Host
Type string - Type of host for Azure Arc SQL Server
- Instance
Name string - SQL Server instance name.
- License
Type string - SQL Server license type.
- Patch
Level string - SQL Server update level.
- Product
Id string - SQL Server product ID.
- Tcp
Dynamic stringPorts - Dynamic TCP ports used by SQL Server.
- Tcp
Static stringPorts - 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 StringId - ARM Resource id of the container resource (Azure Arc for Servers).
- create
Time String - The time when the resource was created.
- provisioning
State String - The provisioning state of the Arc-enabled SQL Server resource.
- status String
- The cloud connectivity status.
- azure
Defender StringStatus - Status of Azure Defender.
- azure
Defender StringStatus Last Updated - Timestamp of last Azure Defender status update.
- collation String
- SQL Server collation.
- cores String
- The number of total cores of the Operating System Environment (OSE) hosting the SQL Server instance.
- current
Version String - SQL Server current version.
- edition String
- SQL Server edition.
- host
Type String - Type of host for Azure Arc SQL Server
- instance
Name String - SQL Server instance name.
- license
Type String - SQL Server license type.
- patch
Level String - SQL Server update level.
- product
Id String - SQL Server product ID.
- tcp
Dynamic StringPorts - Dynamic TCP ports used by SQL Server.
- tcp
Static StringPorts - Static TCP ports used by SQL Server.
- v
Core String - The number of logical processors used by the SQL Server instance.
- version String
- SQL Server version.
- container
Resource stringId - ARM Resource id of the container resource (Azure Arc for Servers).
- create
Time string - The time when the resource was created.
- provisioning
State string - The provisioning state of the Arc-enabled SQL Server resource.
- status string
- The cloud connectivity status.
- azure
Defender stringStatus - Status of Azure Defender.
- azure
Defender stringStatus Last Updated - Timestamp of last Azure Defender status update.
- collation string
- SQL Server collation.
- cores string
- The number of total cores of the Operating System Environment (OSE) hosting the SQL Server instance.
- current
Version string - SQL Server current version.
- edition string
- SQL Server edition.
- host
Type string - Type of host for Azure Arc SQL Server
- instance
Name string - SQL Server instance name.
- license
Type string - SQL Server license type.
- patch
Level string - SQL Server update level.
- product
Id string - SQL Server product ID.
- tcp
Dynamic stringPorts - Dynamic TCP ports used by SQL Server.
- tcp
Static stringPorts - Static TCP ports used by SQL Server.
- v
Core string - The number of logical processors used by the SQL Server instance.
- version string
- SQL Server version.
- container_
resource_ strid - ARM Resource id of the container resource (Azure Arc for Servers).
- create_
time str - The time when the resource was created.
- provisioning_
state str - The provisioning state of the Arc-enabled SQL Server resource.
- status str
- The cloud connectivity status.
- azure_
defender_ strstatus - Status of Azure Defender.
- azure_
defender_ strstatus_ last_ updated - Timestamp of last Azure Defender status update.
- collation str
- SQL Server collation.
- cores str
- The number of total cores of the Operating System Environment (OSE) hosting the SQL Server instance.
- current_
version str - SQL Server current version.
- edition str
- SQL Server edition.
- host_
type str - Type of host for Azure Arc SQL Server
- 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_ strports - Dynamic TCP ports used by SQL Server.
- tcp_
static_ strports - 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.
- container
Resource StringId - ARM Resource id of the container resource (Azure Arc for Servers).
- create
Time String - The time when the resource was created.
- provisioning
State String - The provisioning state of the Arc-enabled SQL Server resource.
- status String
- The cloud connectivity status.
- azure
Defender StringStatus - Status of Azure Defender.
- azure
Defender StringStatus Last Updated - Timestamp of last Azure Defender status update.
- collation String
- SQL Server collation.
- cores String
- The number of total cores of the Operating System Environment (OSE) hosting the SQL Server instance.
- current
Version String - SQL Server current version.
- edition String
- SQL Server edition.
- host
Type String - Type of host for Azure Arc SQL Server
- instance
Name String - SQL Server instance name.
- license
Type String - SQL Server license type.
- patch
Level String - SQL Server update level.
- product
Id String - SQL Server product ID.
- tcp
Dynamic StringPorts - Dynamic TCP ports used by SQL Server.
- tcp
Static StringPorts - Static TCP ports used by SQL Server.
- v
Core String - The number of logical processors used by the SQL Server instance.
- version String
- SQL Server version.
SqlVersion, SqlVersionArgs
- SQL_Server_2012
- SQL Server 2012
- SQL_Server_2014
- SQL Server 2014
- SQL_Server_2016
- SQL Server 2016
- SQL_Server_2017
- SQL Server 2017
- SQL_Server_2019
- SQL Server 2019
- SQL_Server_2022
- SQL Server 2022
- Unknown
- Unknown
- Sql
Version_SQL_Server_2012 - SQL Server 2012
- Sql
Version_SQL_Server_2014 - SQL Server 2014
- Sql
Version_SQL_Server_2016 - SQL Server 2016
- Sql
Version_SQL_Server_2017 - SQL Server 2017
- Sql
Version_SQL_Server_2019 - SQL Server 2019
- Sql
Version_SQL_Server_2022 - SQL Server 2022
- Sql
Version Unknown - Unknown
- SQL_Server_2012
- SQL Server 2012
- SQL_Server_2014
- SQL Server 2014
- SQL_Server_2016
- SQL Server 2016
- SQL_Server_2017
- SQL Server 2017
- SQL_Server_2019
- SQL Server 2019
- SQL_Server_2022
- SQL Server 2022
- Unknown
- Unknown
- SQL_Server_2012
- SQL Server 2012
- SQL_Server_2014
- SQL Server 2014
- SQL_Server_2016
- SQL Server 2016
- SQL_Server_2017
- SQL Server 2017
- SQL_Server_2019
- SQL Server 2019
- SQL_Server_2022
- SQL Server 2022
- Unknown
- Unknown
- SQ_L_SERVER_2012
- SQL Server 2012
- SQ_L_SERVER_2014
- SQL Server 2014
- SQ_L_SERVER_2016
- SQL Server 2016
- SQ_L_SERVER_2017
- SQL Server 2017
- SQ_L_SERVER_2019
- SQL Server 2019
- SQ_L_SERVER_2022
- SQL Server 2022
- UNKNOWN
- Unknown
- "SQL Server 2012"
- SQL Server 2012
- "SQL Server 2014"
- SQL Server 2014
- "SQL Server 2016"
- SQL Server 2016
- "SQL Server 2017"
- SQL Server 2017
- "SQL Server 2019"
- SQL Server 2019
- "SQL Server 2022"
- SQL Server 2022
- "Unknown"
- Unknown
SystemDataResponse, SystemDataResponseArgs
- Created
At string - The timestamp of resource creation (UTC).
- Created
By string - The identity that created the resource.
- Created
By stringType - The type of identity that created the resource.
- Last
Modified stringAt - The timestamp of resource last modification (UTC)
- Last
Modified stringBy - The identity that last modified the resource.
- Last
Modified stringBy Type - The type of identity that last modified the resource.
- Created
At string - The timestamp of resource creation (UTC).
- Created
By string - The identity that created the resource.
- Created
By stringType - The type of identity that created the resource.
- Last
Modified stringAt - The timestamp of resource last modification (UTC)
- Last
Modified stringBy - The identity that last modified the resource.
- Last
Modified stringBy Type - The type of identity that last modified the resource.
- created
At String - The timestamp of resource creation (UTC).
- created
By String - The identity that created the resource.
- created
By StringType - The type of identity that created the resource.
- last
Modified StringAt - The timestamp of resource last modification (UTC)
- last
Modified StringBy - The identity that last modified the resource.
- last
Modified StringBy Type - The type of identity that last modified the resource.
- created
At string - The timestamp of resource creation (UTC).
- created
By string - The identity that created the resource.
- created
By stringType - The type of identity that created the resource.
- last
Modified stringAt - The timestamp of resource last modification (UTC)
- last
Modified stringBy - The identity that last modified the resource.
- last
Modified stringBy Type - The type of identity that last modified the resource.
- created_
at str - The timestamp of resource creation (UTC).
- created_
by str - The identity that created the resource.
- created_
by_ strtype - The type of identity that created the resource.
- last_
modified_ strat - The timestamp of resource last modification (UTC)
- last_
modified_ strby - The identity that last modified the resource.
- last_
modified_ strby_ type - The type of identity that last modified the resource.
- created
At String - The timestamp of resource creation (UTC).
- created
By String - The identity that created the resource.
- created
By StringType - The type of identity that created the resource.
- last
Modified StringAt - The timestamp of resource last modification (UTC)
- last
Modified StringBy - The identity that last modified the resource.
- last
Modified StringBy Type - 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/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.AzureArcData/sqlServerInstances/{sqlServerInstanceName}
To learn more about importing existing cloud resources, see Importing resources.
Package Details
- Repository
- Azure Native pulumi/pulumi-azure-native
- License
- Apache-2.0