1. Packages
  2. Tencentcloud Provider
  3. API Docs
  4. SqlserverInstance
tencentcloud 1.81.183 published on Wednesday, Apr 16, 2025 by tencentcloudstack

tencentcloud.SqlserverInstance

Explore with Pulumi AI

Use this resource to create SQL Server instance

Example Usage

import * as pulumi from "@pulumi/pulumi";
import * as tencentcloud from "@pulumi/tencentcloud";

const zones = tencentcloud.getAvailabilityZonesByProduct({
    product: "sqlserver",
});
const vpc = new tencentcloud.Vpc("vpc", {cidrBlock: "10.0.0.0/16"});
const subnet = new tencentcloud.Subnet("subnet", {
    availabilityZone: zones.then(zones => zones.zones?.[4]?.name),
    vpcId: vpc.vpcId,
    cidrBlock: "10.0.0.0/16",
    isMulticast: false,
});
const example = new tencentcloud.SqlserverInstance("example", {
    availabilityZone: zones.then(zones => zones.zones?.[4]?.name),
    chargeType: "POSTPAID_BY_HOUR",
    vpcId: vpc.vpcId,
    subnetId: subnet.subnetId,
    projectId: 0,
    memory: 16,
    storage: 100,
});
Copy
import pulumi
import pulumi_tencentcloud as tencentcloud

zones = tencentcloud.get_availability_zones_by_product(product="sqlserver")
vpc = tencentcloud.Vpc("vpc", cidr_block="10.0.0.0/16")
subnet = tencentcloud.Subnet("subnet",
    availability_zone=zones.zones[4].name,
    vpc_id=vpc.vpc_id,
    cidr_block="10.0.0.0/16",
    is_multicast=False)
example = tencentcloud.SqlserverInstance("example",
    availability_zone=zones.zones[4].name,
    charge_type="POSTPAID_BY_HOUR",
    vpc_id=vpc.vpc_id,
    subnet_id=subnet.subnet_id,
    project_id=0,
    memory=16,
    storage=100)
Copy
package main

import (
	"github.com/pulumi/pulumi-terraform-provider/sdks/go/tencentcloud/tencentcloud"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		zones, err := tencentcloud.GetAvailabilityZonesByProduct(ctx, &tencentcloud.GetAvailabilityZonesByProductArgs{
			Product: "sqlserver",
		}, nil)
		if err != nil {
			return err
		}
		vpc, err := tencentcloud.NewVpc(ctx, "vpc", &tencentcloud.VpcArgs{
			CidrBlock: pulumi.String("10.0.0.0/16"),
		})
		if err != nil {
			return err
		}
		subnet, err := tencentcloud.NewSubnet(ctx, "subnet", &tencentcloud.SubnetArgs{
			AvailabilityZone: pulumi.String(zones.Zones[4].Name),
			VpcId:            vpc.VpcId,
			CidrBlock:        pulumi.String("10.0.0.0/16"),
			IsMulticast:      pulumi.Bool(false),
		})
		if err != nil {
			return err
		}
		_, err = tencentcloud.NewSqlserverInstance(ctx, "example", &tencentcloud.SqlserverInstanceArgs{
			AvailabilityZone: pulumi.String(zones.Zones[4].Name),
			ChargeType:       pulumi.String("POSTPAID_BY_HOUR"),
			VpcId:            vpc.VpcId,
			SubnetId:         subnet.SubnetId,
			ProjectId:        pulumi.Float64(0),
			Memory:           pulumi.Float64(16),
			Storage:          pulumi.Float64(100),
		})
		if err != nil {
			return err
		}
		return nil
	})
}
Copy
using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Tencentcloud = Pulumi.Tencentcloud;

return await Deployment.RunAsync(() => 
{
    var zones = Tencentcloud.GetAvailabilityZonesByProduct.Invoke(new()
    {
        Product = "sqlserver",
    });

    var vpc = new Tencentcloud.Vpc("vpc", new()
    {
        CidrBlock = "10.0.0.0/16",
    });

    var subnet = new Tencentcloud.Subnet("subnet", new()
    {
        AvailabilityZone = zones.Apply(getAvailabilityZonesByProductResult => getAvailabilityZonesByProductResult.Zones[4]?.Name),
        VpcId = vpc.VpcId,
        CidrBlock = "10.0.0.0/16",
        IsMulticast = false,
    });

    var example = new Tencentcloud.SqlserverInstance("example", new()
    {
        AvailabilityZone = zones.Apply(getAvailabilityZonesByProductResult => getAvailabilityZonesByProductResult.Zones[4]?.Name),
        ChargeType = "POSTPAID_BY_HOUR",
        VpcId = vpc.VpcId,
        SubnetId = subnet.SubnetId,
        ProjectId = 0,
        Memory = 16,
        Storage = 100,
    });

});
Copy
package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.tencentcloud.TencentcloudFunctions;
import com.pulumi.tencentcloud.inputs.GetAvailabilityZonesByProductArgs;
import com.pulumi.tencentcloud.Vpc;
import com.pulumi.tencentcloud.VpcArgs;
import com.pulumi.tencentcloud.Subnet;
import com.pulumi.tencentcloud.SubnetArgs;
import com.pulumi.tencentcloud.SqlserverInstance;
import com.pulumi.tencentcloud.SqlserverInstanceArgs;
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) {
        final var zones = TencentcloudFunctions.getAvailabilityZonesByProduct(GetAvailabilityZonesByProductArgs.builder()
            .product("sqlserver")
            .build());

        var vpc = new Vpc("vpc", VpcArgs.builder()
            .cidrBlock("10.0.0.0/16")
            .build());

        var subnet = new Subnet("subnet", SubnetArgs.builder()
            .availabilityZone(zones.applyValue(getAvailabilityZonesByProductResult -> getAvailabilityZonesByProductResult.zones()[4].name()))
            .vpcId(vpc.vpcId())
            .cidrBlock("10.0.0.0/16")
            .isMulticast(false)
            .build());

        var example = new SqlserverInstance("example", SqlserverInstanceArgs.builder()
            .availabilityZone(zones.applyValue(getAvailabilityZonesByProductResult -> getAvailabilityZonesByProductResult.zones()[4].name()))
            .chargeType("POSTPAID_BY_HOUR")
            .vpcId(vpc.vpcId())
            .subnetId(subnet.subnetId())
            .projectId(0)
            .memory(16)
            .storage(100)
            .build());

    }
}
Copy
resources:
  vpc:
    type: tencentcloud:Vpc
    properties:
      cidrBlock: 10.0.0.0/16
  subnet:
    type: tencentcloud:Subnet
    properties:
      availabilityZone: ${zones.zones[4].name}
      vpcId: ${vpc.vpcId}
      cidrBlock: 10.0.0.0/16
      isMulticast: false
  example:
    type: tencentcloud:SqlserverInstance
    properties:
      availabilityZone: ${zones.zones[4].name}
      chargeType: POSTPAID_BY_HOUR
      vpcId: ${vpc.vpcId}
      subnetId: ${subnet.subnetId}
      projectId: 0
      memory: 16
      storage: 100
variables:
  zones:
    fn::invoke:
      function: tencentcloud:getAvailabilityZonesByProduct
      arguments:
        product: sqlserver
Copy

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,
                      memory: Optional[float] = None,
                      storage: Optional[float] = None,
                      multi_zones: Optional[bool] = None,
                      project_id: Optional[float] = None,
                      engine_version: Optional[str] = None,
                      ha_type: Optional[str] = None,
                      maintenance_start_time: Optional[str] = None,
                      maintenance_time_span: Optional[float] = None,
                      maintenance_week_sets: Optional[Sequence[float]] = None,
                      availability_zone: Optional[str] = None,
                      auto_renew: Optional[float] = None,
                      name: Optional[str] = None,
                      period: Optional[float] = None,
                      charge_type: Optional[str] = None,
                      security_groups: Optional[Sequence[str]] = None,
                      sqlserver_instance_id: Optional[str] = None,
                      auto_voucher: Optional[float] = None,
                      subnet_id: Optional[str] = None,
                      tags: Optional[Mapping[str, str]] = None,
                      time_zone: Optional[str] = None,
                      voucher_ids: Optional[Sequence[str]] = None,
                      vpc_id: Optional[str] = None,
                      wait_switch: Optional[float] = 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: tencentcloud:SqlserverInstance
properties: # The arguments to resource properties.
options: # Bag of options to control resource's behavior.

Parameters

name This property is required. string
The unique name of the resource.
args This property is required. SqlserverInstanceArgs
The arguments to resource properties.
opts CustomResourceOptions
Bag of options to control resource's behavior.
resource_name This property is required. str
The unique name of the resource.
args This property is required. 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 This property is required. string
The unique name of the resource.
args This property is required. SqlserverInstanceArgs
The arguments to resource properties.
opts ResourceOption
Bag of options to control resource's behavior.
name This property is required. string
The unique name of the resource.
args This property is required. SqlserverInstanceArgs
The arguments to resource properties.
opts CustomResourceOptions
Bag of options to control resource's behavior.
name This property is required. String
The unique name of the resource.
args This property is required. 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

In Python, inputs that are objects can be passed either as argument classes or as dictionary literals.

The SqlserverInstance resource accepts the following input properties:

Memory This property is required. double
Memory size (in GB). Allowed value must be larger than memory that data source tencentcloud_sqlserver_specinfos provides.
Storage This property is required. double
Disk size (in GB). Allowed value must be a multiple of 10. The storage must be set with the limit of storage_min and storage_max which data source tencentcloud_sqlserver_specinfos provides.
AutoRenew double
Automatic renewal sign. 0 for normal renewal, 1 for automatic renewal (Default). Only valid when purchasing a prepaid instance.
AutoVoucher double
Whether to use the voucher automatically; 1 for yes, 0 for no, the default is 0.
AvailabilityZone string
Availability zone.
ChargeType string
Pay type of the SQL Server instance. Available values PREPAID, POSTPAID_BY_HOUR.
EngineVersion string
Version of the SQL Server database engine. Allowed values are 2008R2(SQL Server 2008 Enterprise), 2012SP3(SQL Server 2012 Enterprise), 2016SP1 (SQL Server 2016 Enterprise), 201602(SQL Server 2016 Standard) and 2017(SQL Server 2017 Enterprise). Default is 2008R2.
HaType string
It has been deprecated from version 1.81.136. Instance type. DUAL (dual-server high availability), CLUSTER (cluster). Default is DUAL.

Deprecated: Deprecated

MaintenanceStartTime string
Start time of the maintenance in one day, format like HH:mm.
MaintenanceTimeSpan double
The timespan of maintenance in one day, unit is hour.
MaintenanceWeekSets List<double>
A list of integer indicates weekly maintenance. For example, [2,7] presents do weekly maintenance on every Tuesday and Sunday.
MultiZones bool
Indicate whether to deploy across availability zones.
Name string
Name of the SQL Server instance.
Period double
Purchase instance period in month. The value does not exceed 48.
ProjectId double
Project ID, default value is 0.
SecurityGroups List<string>
Security group bound to the instance.
SqlserverInstanceId string
ID of the resource.
SubnetId string
ID of subnet.
Tags Dictionary<string, string>
The tags of the SQL Server.
TimeZone string
System time zone, default: China Standard Time.
VoucherIds List<string>
An array of voucher IDs, currently only one can be used for a single order.
VpcId string
ID of VPC.
WaitSwitch double
It has been deprecated from version 1.81.2. The way to execute the allocation. Supported values include: 0 - execute immediately, 1 - execute in maintenance window.

Deprecated: Deprecated

Memory This property is required. float64
Memory size (in GB). Allowed value must be larger than memory that data source tencentcloud_sqlserver_specinfos provides.
Storage This property is required. float64
Disk size (in GB). Allowed value must be a multiple of 10. The storage must be set with the limit of storage_min and storage_max which data source tencentcloud_sqlserver_specinfos provides.
AutoRenew float64
Automatic renewal sign. 0 for normal renewal, 1 for automatic renewal (Default). Only valid when purchasing a prepaid instance.
AutoVoucher float64
Whether to use the voucher automatically; 1 for yes, 0 for no, the default is 0.
AvailabilityZone string
Availability zone.
ChargeType string
Pay type of the SQL Server instance. Available values PREPAID, POSTPAID_BY_HOUR.
EngineVersion string
Version of the SQL Server database engine. Allowed values are 2008R2(SQL Server 2008 Enterprise), 2012SP3(SQL Server 2012 Enterprise), 2016SP1 (SQL Server 2016 Enterprise), 201602(SQL Server 2016 Standard) and 2017(SQL Server 2017 Enterprise). Default is 2008R2.
HaType string
It has been deprecated from version 1.81.136. Instance type. DUAL (dual-server high availability), CLUSTER (cluster). Default is DUAL.

Deprecated: Deprecated

MaintenanceStartTime string
Start time of the maintenance in one day, format like HH:mm.
MaintenanceTimeSpan float64
The timespan of maintenance in one day, unit is hour.
MaintenanceWeekSets []float64
A list of integer indicates weekly maintenance. For example, [2,7] presents do weekly maintenance on every Tuesday and Sunday.
MultiZones bool
Indicate whether to deploy across availability zones.
Name string
Name of the SQL Server instance.
Period float64
Purchase instance period in month. The value does not exceed 48.
ProjectId float64
Project ID, default value is 0.
SecurityGroups []string
Security group bound to the instance.
SqlserverInstanceId string
ID of the resource.
SubnetId string
ID of subnet.
Tags map[string]string
The tags of the SQL Server.
TimeZone string
System time zone, default: China Standard Time.
VoucherIds []string
An array of voucher IDs, currently only one can be used for a single order.
VpcId string
ID of VPC.
WaitSwitch float64
It has been deprecated from version 1.81.2. The way to execute the allocation. Supported values include: 0 - execute immediately, 1 - execute in maintenance window.

Deprecated: Deprecated

memory This property is required. Double
Memory size (in GB). Allowed value must be larger than memory that data source tencentcloud_sqlserver_specinfos provides.
storage This property is required. Double
Disk size (in GB). Allowed value must be a multiple of 10. The storage must be set with the limit of storage_min and storage_max which data source tencentcloud_sqlserver_specinfos provides.
autoRenew Double
Automatic renewal sign. 0 for normal renewal, 1 for automatic renewal (Default). Only valid when purchasing a prepaid instance.
autoVoucher Double
Whether to use the voucher automatically; 1 for yes, 0 for no, the default is 0.
availabilityZone String
Availability zone.
chargeType String
Pay type of the SQL Server instance. Available values PREPAID, POSTPAID_BY_HOUR.
engineVersion String
Version of the SQL Server database engine. Allowed values are 2008R2(SQL Server 2008 Enterprise), 2012SP3(SQL Server 2012 Enterprise), 2016SP1 (SQL Server 2016 Enterprise), 201602(SQL Server 2016 Standard) and 2017(SQL Server 2017 Enterprise). Default is 2008R2.
haType String
It has been deprecated from version 1.81.136. Instance type. DUAL (dual-server high availability), CLUSTER (cluster). Default is DUAL.

Deprecated: Deprecated

maintenanceStartTime String
Start time of the maintenance in one day, format like HH:mm.
maintenanceTimeSpan Double
The timespan of maintenance in one day, unit is hour.
maintenanceWeekSets List<Double>
A list of integer indicates weekly maintenance. For example, [2,7] presents do weekly maintenance on every Tuesday and Sunday.
multiZones Boolean
Indicate whether to deploy across availability zones.
name String
Name of the SQL Server instance.
period Double
Purchase instance period in month. The value does not exceed 48.
projectId Double
Project ID, default value is 0.
securityGroups List<String>
Security group bound to the instance.
sqlserverInstanceId String
ID of the resource.
subnetId String
ID of subnet.
tags Map<String,String>
The tags of the SQL Server.
timeZone String
System time zone, default: China Standard Time.
voucherIds List<String>
An array of voucher IDs, currently only one can be used for a single order.
vpcId String
ID of VPC.
waitSwitch Double
It has been deprecated from version 1.81.2. The way to execute the allocation. Supported values include: 0 - execute immediately, 1 - execute in maintenance window.

Deprecated: Deprecated

memory This property is required. number
Memory size (in GB). Allowed value must be larger than memory that data source tencentcloud_sqlserver_specinfos provides.
storage This property is required. number
Disk size (in GB). Allowed value must be a multiple of 10. The storage must be set with the limit of storage_min and storage_max which data source tencentcloud_sqlserver_specinfos provides.
autoRenew number
Automatic renewal sign. 0 for normal renewal, 1 for automatic renewal (Default). Only valid when purchasing a prepaid instance.
autoVoucher number
Whether to use the voucher automatically; 1 for yes, 0 for no, the default is 0.
availabilityZone string
Availability zone.
chargeType string
Pay type of the SQL Server instance. Available values PREPAID, POSTPAID_BY_HOUR.
engineVersion string
Version of the SQL Server database engine. Allowed values are 2008R2(SQL Server 2008 Enterprise), 2012SP3(SQL Server 2012 Enterprise), 2016SP1 (SQL Server 2016 Enterprise), 201602(SQL Server 2016 Standard) and 2017(SQL Server 2017 Enterprise). Default is 2008R2.
haType string
It has been deprecated from version 1.81.136. Instance type. DUAL (dual-server high availability), CLUSTER (cluster). Default is DUAL.

Deprecated: Deprecated

maintenanceStartTime string
Start time of the maintenance in one day, format like HH:mm.
maintenanceTimeSpan number
The timespan of maintenance in one day, unit is hour.
maintenanceWeekSets number[]
A list of integer indicates weekly maintenance. For example, [2,7] presents do weekly maintenance on every Tuesday and Sunday.
multiZones boolean
Indicate whether to deploy across availability zones.
name string
Name of the SQL Server instance.
period number
Purchase instance period in month. The value does not exceed 48.
projectId number
Project ID, default value is 0.
securityGroups string[]
Security group bound to the instance.
sqlserverInstanceId string
ID of the resource.
subnetId string
ID of subnet.
tags {[key: string]: string}
The tags of the SQL Server.
timeZone string
System time zone, default: China Standard Time.
voucherIds string[]
An array of voucher IDs, currently only one can be used for a single order.
vpcId string
ID of VPC.
waitSwitch number
It has been deprecated from version 1.81.2. The way to execute the allocation. Supported values include: 0 - execute immediately, 1 - execute in maintenance window.

Deprecated: Deprecated

memory This property is required. float
Memory size (in GB). Allowed value must be larger than memory that data source tencentcloud_sqlserver_specinfos provides.
storage This property is required. float
Disk size (in GB). Allowed value must be a multiple of 10. The storage must be set with the limit of storage_min and storage_max which data source tencentcloud_sqlserver_specinfos provides.
auto_renew float
Automatic renewal sign. 0 for normal renewal, 1 for automatic renewal (Default). Only valid when purchasing a prepaid instance.
auto_voucher float
Whether to use the voucher automatically; 1 for yes, 0 for no, the default is 0.
availability_zone str
Availability zone.
charge_type str
Pay type of the SQL Server instance. Available values PREPAID, POSTPAID_BY_HOUR.
engine_version str
Version of the SQL Server database engine. Allowed values are 2008R2(SQL Server 2008 Enterprise), 2012SP3(SQL Server 2012 Enterprise), 2016SP1 (SQL Server 2016 Enterprise), 201602(SQL Server 2016 Standard) and 2017(SQL Server 2017 Enterprise). Default is 2008R2.
ha_type str
It has been deprecated from version 1.81.136. Instance type. DUAL (dual-server high availability), CLUSTER (cluster). Default is DUAL.

Deprecated: Deprecated

maintenance_start_time str
Start time of the maintenance in one day, format like HH:mm.
maintenance_time_span float
The timespan of maintenance in one day, unit is hour.
maintenance_week_sets Sequence[float]
A list of integer indicates weekly maintenance. For example, [2,7] presents do weekly maintenance on every Tuesday and Sunday.
multi_zones bool
Indicate whether to deploy across availability zones.
name str
Name of the SQL Server instance.
period float
Purchase instance period in month. The value does not exceed 48.
project_id float
Project ID, default value is 0.
security_groups Sequence[str]
Security group bound to the instance.
sqlserver_instance_id str
ID of the resource.
subnet_id str
ID of subnet.
tags Mapping[str, str]
The tags of the SQL Server.
time_zone str
System time zone, default: China Standard Time.
voucher_ids Sequence[str]
An array of voucher IDs, currently only one can be used for a single order.
vpc_id str
ID of VPC.
wait_switch float
It has been deprecated from version 1.81.2. The way to execute the allocation. Supported values include: 0 - execute immediately, 1 - execute in maintenance window.

Deprecated: Deprecated

memory This property is required. Number
Memory size (in GB). Allowed value must be larger than memory that data source tencentcloud_sqlserver_specinfos provides.
storage This property is required. Number
Disk size (in GB). Allowed value must be a multiple of 10. The storage must be set with the limit of storage_min and storage_max which data source tencentcloud_sqlserver_specinfos provides.
autoRenew Number
Automatic renewal sign. 0 for normal renewal, 1 for automatic renewal (Default). Only valid when purchasing a prepaid instance.
autoVoucher Number
Whether to use the voucher automatically; 1 for yes, 0 for no, the default is 0.
availabilityZone String
Availability zone.
chargeType String
Pay type of the SQL Server instance. Available values PREPAID, POSTPAID_BY_HOUR.
engineVersion String
Version of the SQL Server database engine. Allowed values are 2008R2(SQL Server 2008 Enterprise), 2012SP3(SQL Server 2012 Enterprise), 2016SP1 (SQL Server 2016 Enterprise), 201602(SQL Server 2016 Standard) and 2017(SQL Server 2017 Enterprise). Default is 2008R2.
haType String
It has been deprecated from version 1.81.136. Instance type. DUAL (dual-server high availability), CLUSTER (cluster). Default is DUAL.

Deprecated: Deprecated

maintenanceStartTime String
Start time of the maintenance in one day, format like HH:mm.
maintenanceTimeSpan Number
The timespan of maintenance in one day, unit is hour.
maintenanceWeekSets List<Number>
A list of integer indicates weekly maintenance. For example, [2,7] presents do weekly maintenance on every Tuesday and Sunday.
multiZones Boolean
Indicate whether to deploy across availability zones.
name String
Name of the SQL Server instance.
period Number
Purchase instance period in month. The value does not exceed 48.
projectId Number
Project ID, default value is 0.
securityGroups List<String>
Security group bound to the instance.
sqlserverInstanceId String
ID of the resource.
subnetId String
ID of subnet.
tags Map<String>
The tags of the SQL Server.
timeZone String
System time zone, default: China Standard Time.
voucherIds List<String>
An array of voucher IDs, currently only one can be used for a single order.
vpcId String
ID of VPC.
waitSwitch Number
It has been deprecated from version 1.81.2. The way to execute the allocation. Supported values include: 0 - execute immediately, 1 - execute in maintenance window.

Deprecated: Deprecated

Outputs

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

CreateTime string
Create time of the SQL Server instance.
DnsPodDomain string
Internet address domain name.
Id string
The provider-assigned unique ID for this managed resource.
RoFlag string
Readonly flag. RO (read-only instance), MASTER (primary instance with read-only instances). If it is left empty, it refers to an instance which is not read-only and has no RO group.
Status double
Status of the SQL Server instance. 1 for applying, 2 for running, 3 for running with limit, 4 for isolated, 5 for recycling, 6 for recycled, 7 for running with task, 8 for off-line, 9 for expanding, 10 for migrating, 11 for readonly, 12 for rebooting.
TgwWanVport double
External port number.
Vip string
IP for private access.
Vport double
Port for private access.
CreateTime string
Create time of the SQL Server instance.
DnsPodDomain string
Internet address domain name.
Id string
The provider-assigned unique ID for this managed resource.
RoFlag string
Readonly flag. RO (read-only instance), MASTER (primary instance with read-only instances). If it is left empty, it refers to an instance which is not read-only and has no RO group.
Status float64
Status of the SQL Server instance. 1 for applying, 2 for running, 3 for running with limit, 4 for isolated, 5 for recycling, 6 for recycled, 7 for running with task, 8 for off-line, 9 for expanding, 10 for migrating, 11 for readonly, 12 for rebooting.
TgwWanVport float64
External port number.
Vip string
IP for private access.
Vport float64
Port for private access.
createTime String
Create time of the SQL Server instance.
dnsPodDomain String
Internet address domain name.
id String
The provider-assigned unique ID for this managed resource.
roFlag String
Readonly flag. RO (read-only instance), MASTER (primary instance with read-only instances). If it is left empty, it refers to an instance which is not read-only and has no RO group.
status Double
Status of the SQL Server instance. 1 for applying, 2 for running, 3 for running with limit, 4 for isolated, 5 for recycling, 6 for recycled, 7 for running with task, 8 for off-line, 9 for expanding, 10 for migrating, 11 for readonly, 12 for rebooting.
tgwWanVport Double
External port number.
vip String
IP for private access.
vport Double
Port for private access.
createTime string
Create time of the SQL Server instance.
dnsPodDomain string
Internet address domain name.
id string
The provider-assigned unique ID for this managed resource.
roFlag string
Readonly flag. RO (read-only instance), MASTER (primary instance with read-only instances). If it is left empty, it refers to an instance which is not read-only and has no RO group.
status number
Status of the SQL Server instance. 1 for applying, 2 for running, 3 for running with limit, 4 for isolated, 5 for recycling, 6 for recycled, 7 for running with task, 8 for off-line, 9 for expanding, 10 for migrating, 11 for readonly, 12 for rebooting.
tgwWanVport number
External port number.
vip string
IP for private access.
vport number
Port for private access.
create_time str
Create time of the SQL Server instance.
dns_pod_domain str
Internet address domain name.
id str
The provider-assigned unique ID for this managed resource.
ro_flag str
Readonly flag. RO (read-only instance), MASTER (primary instance with read-only instances). If it is left empty, it refers to an instance which is not read-only and has no RO group.
status float
Status of the SQL Server instance. 1 for applying, 2 for running, 3 for running with limit, 4 for isolated, 5 for recycling, 6 for recycled, 7 for running with task, 8 for off-line, 9 for expanding, 10 for migrating, 11 for readonly, 12 for rebooting.
tgw_wan_vport float
External port number.
vip str
IP for private access.
vport float
Port for private access.
createTime String
Create time of the SQL Server instance.
dnsPodDomain String
Internet address domain name.
id String
The provider-assigned unique ID for this managed resource.
roFlag String
Readonly flag. RO (read-only instance), MASTER (primary instance with read-only instances). If it is left empty, it refers to an instance which is not read-only and has no RO group.
status Number
Status of the SQL Server instance. 1 for applying, 2 for running, 3 for running with limit, 4 for isolated, 5 for recycling, 6 for recycled, 7 for running with task, 8 for off-line, 9 for expanding, 10 for migrating, 11 for readonly, 12 for rebooting.
tgwWanVport Number
External port number.
vip String
IP for private access.
vport Number
Port for private access.

Look up Existing SqlserverInstance Resource

Get an existing SqlserverInstance resource’s state with the given name, ID, and optional extra properties used to qualify the lookup.

public static get(name: string, id: Input<ID>, state?: SqlserverInstanceState, opts?: CustomResourceOptions): SqlserverInstance
@staticmethod
def get(resource_name: str,
        id: str,
        opts: Optional[ResourceOptions] = None,
        auto_renew: Optional[float] = None,
        auto_voucher: Optional[float] = None,
        availability_zone: Optional[str] = None,
        charge_type: Optional[str] = None,
        create_time: Optional[str] = None,
        dns_pod_domain: Optional[str] = None,
        engine_version: Optional[str] = None,
        ha_type: Optional[str] = None,
        maintenance_start_time: Optional[str] = None,
        maintenance_time_span: Optional[float] = None,
        maintenance_week_sets: Optional[Sequence[float]] = None,
        memory: Optional[float] = None,
        multi_zones: Optional[bool] = None,
        name: Optional[str] = None,
        period: Optional[float] = None,
        project_id: Optional[float] = None,
        ro_flag: Optional[str] = None,
        security_groups: Optional[Sequence[str]] = None,
        sqlserver_instance_id: Optional[str] = None,
        status: Optional[float] = None,
        storage: Optional[float] = None,
        subnet_id: Optional[str] = None,
        tags: Optional[Mapping[str, str]] = None,
        tgw_wan_vport: Optional[float] = None,
        time_zone: Optional[str] = None,
        vip: Optional[str] = None,
        voucher_ids: Optional[Sequence[str]] = None,
        vpc_id: Optional[str] = None,
        vport: Optional[float] = None,
        wait_switch: Optional[float] = None) -> SqlserverInstance
func GetSqlserverInstance(ctx *Context, name string, id IDInput, state *SqlserverInstanceState, opts ...ResourceOption) (*SqlserverInstance, error)
public static SqlserverInstance Get(string name, Input<string> id, SqlserverInstanceState? state, CustomResourceOptions? opts = null)
public static SqlserverInstance get(String name, Output<String> id, SqlserverInstanceState state, CustomResourceOptions options)
resources:  _:    type: tencentcloud:SqlserverInstance    get:      id: ${id}
name This property is required.
The unique name of the resulting resource.
id This property is required.
The unique provider ID of the resource to lookup.
state
Any extra arguments used during the lookup.
opts
A bag of options that control this resource's behavior.
resource_name This property is required.
The unique name of the resulting resource.
id This property is required.
The unique provider ID of the resource to lookup.
name This property is required.
The unique name of the resulting resource.
id This property is required.
The unique provider ID of the resource to lookup.
state
Any extra arguments used during the lookup.
opts
A bag of options that control this resource's behavior.
name This property is required.
The unique name of the resulting resource.
id This property is required.
The unique provider ID of the resource to lookup.
state
Any extra arguments used during the lookup.
opts
A bag of options that control this resource's behavior.
name This property is required.
The unique name of the resulting resource.
id This property is required.
The unique provider ID of the resource to lookup.
state
Any extra arguments used during the lookup.
opts
A bag of options that control this resource's behavior.
The following state arguments are supported:
AutoRenew double
Automatic renewal sign. 0 for normal renewal, 1 for automatic renewal (Default). Only valid when purchasing a prepaid instance.
AutoVoucher double
Whether to use the voucher automatically; 1 for yes, 0 for no, the default is 0.
AvailabilityZone string
Availability zone.
ChargeType string
Pay type of the SQL Server instance. Available values PREPAID, POSTPAID_BY_HOUR.
CreateTime string
Create time of the SQL Server instance.
DnsPodDomain string
Internet address domain name.
EngineVersion string
Version of the SQL Server database engine. Allowed values are 2008R2(SQL Server 2008 Enterprise), 2012SP3(SQL Server 2012 Enterprise), 2016SP1 (SQL Server 2016 Enterprise), 201602(SQL Server 2016 Standard) and 2017(SQL Server 2017 Enterprise). Default is 2008R2.
HaType string
It has been deprecated from version 1.81.136. Instance type. DUAL (dual-server high availability), CLUSTER (cluster). Default is DUAL.

Deprecated: Deprecated

MaintenanceStartTime string
Start time of the maintenance in one day, format like HH:mm.
MaintenanceTimeSpan double
The timespan of maintenance in one day, unit is hour.
MaintenanceWeekSets List<double>
A list of integer indicates weekly maintenance. For example, [2,7] presents do weekly maintenance on every Tuesday and Sunday.
Memory double
Memory size (in GB). Allowed value must be larger than memory that data source tencentcloud_sqlserver_specinfos provides.
MultiZones bool
Indicate whether to deploy across availability zones.
Name string
Name of the SQL Server instance.
Period double
Purchase instance period in month. The value does not exceed 48.
ProjectId double
Project ID, default value is 0.
RoFlag string
Readonly flag. RO (read-only instance), MASTER (primary instance with read-only instances). If it is left empty, it refers to an instance which is not read-only and has no RO group.
SecurityGroups List<string>
Security group bound to the instance.
SqlserverInstanceId string
ID of the resource.
Status double
Status of the SQL Server instance. 1 for applying, 2 for running, 3 for running with limit, 4 for isolated, 5 for recycling, 6 for recycled, 7 for running with task, 8 for off-line, 9 for expanding, 10 for migrating, 11 for readonly, 12 for rebooting.
Storage double
Disk size (in GB). Allowed value must be a multiple of 10. The storage must be set with the limit of storage_min and storage_max which data source tencentcloud_sqlserver_specinfos provides.
SubnetId string
ID of subnet.
Tags Dictionary<string, string>
The tags of the SQL Server.
TgwWanVport double
External port number.
TimeZone string
System time zone, default: China Standard Time.
Vip string
IP for private access.
VoucherIds List<string>
An array of voucher IDs, currently only one can be used for a single order.
VpcId string
ID of VPC.
Vport double
Port for private access.
WaitSwitch double
It has been deprecated from version 1.81.2. The way to execute the allocation. Supported values include: 0 - execute immediately, 1 - execute in maintenance window.

Deprecated: Deprecated

AutoRenew float64
Automatic renewal sign. 0 for normal renewal, 1 for automatic renewal (Default). Only valid when purchasing a prepaid instance.
AutoVoucher float64
Whether to use the voucher automatically; 1 for yes, 0 for no, the default is 0.
AvailabilityZone string
Availability zone.
ChargeType string
Pay type of the SQL Server instance. Available values PREPAID, POSTPAID_BY_HOUR.
CreateTime string
Create time of the SQL Server instance.
DnsPodDomain string
Internet address domain name.
EngineVersion string
Version of the SQL Server database engine. Allowed values are 2008R2(SQL Server 2008 Enterprise), 2012SP3(SQL Server 2012 Enterprise), 2016SP1 (SQL Server 2016 Enterprise), 201602(SQL Server 2016 Standard) and 2017(SQL Server 2017 Enterprise). Default is 2008R2.
HaType string
It has been deprecated from version 1.81.136. Instance type. DUAL (dual-server high availability), CLUSTER (cluster). Default is DUAL.

Deprecated: Deprecated

MaintenanceStartTime string
Start time of the maintenance in one day, format like HH:mm.
MaintenanceTimeSpan float64
The timespan of maintenance in one day, unit is hour.
MaintenanceWeekSets []float64
A list of integer indicates weekly maintenance. For example, [2,7] presents do weekly maintenance on every Tuesday and Sunday.
Memory float64
Memory size (in GB). Allowed value must be larger than memory that data source tencentcloud_sqlserver_specinfos provides.
MultiZones bool
Indicate whether to deploy across availability zones.
Name string
Name of the SQL Server instance.
Period float64
Purchase instance period in month. The value does not exceed 48.
ProjectId float64
Project ID, default value is 0.
RoFlag string
Readonly flag. RO (read-only instance), MASTER (primary instance with read-only instances). If it is left empty, it refers to an instance which is not read-only and has no RO group.
SecurityGroups []string
Security group bound to the instance.
SqlserverInstanceId string
ID of the resource.
Status float64
Status of the SQL Server instance. 1 for applying, 2 for running, 3 for running with limit, 4 for isolated, 5 for recycling, 6 for recycled, 7 for running with task, 8 for off-line, 9 for expanding, 10 for migrating, 11 for readonly, 12 for rebooting.
Storage float64
Disk size (in GB). Allowed value must be a multiple of 10. The storage must be set with the limit of storage_min and storage_max which data source tencentcloud_sqlserver_specinfos provides.
SubnetId string
ID of subnet.
Tags map[string]string
The tags of the SQL Server.
TgwWanVport float64
External port number.
TimeZone string
System time zone, default: China Standard Time.
Vip string
IP for private access.
VoucherIds []string
An array of voucher IDs, currently only one can be used for a single order.
VpcId string
ID of VPC.
Vport float64
Port for private access.
WaitSwitch float64
It has been deprecated from version 1.81.2. The way to execute the allocation. Supported values include: 0 - execute immediately, 1 - execute in maintenance window.

Deprecated: Deprecated

autoRenew Double
Automatic renewal sign. 0 for normal renewal, 1 for automatic renewal (Default). Only valid when purchasing a prepaid instance.
autoVoucher Double
Whether to use the voucher automatically; 1 for yes, 0 for no, the default is 0.
availabilityZone String
Availability zone.
chargeType String
Pay type of the SQL Server instance. Available values PREPAID, POSTPAID_BY_HOUR.
createTime String
Create time of the SQL Server instance.
dnsPodDomain String
Internet address domain name.
engineVersion String
Version of the SQL Server database engine. Allowed values are 2008R2(SQL Server 2008 Enterprise), 2012SP3(SQL Server 2012 Enterprise), 2016SP1 (SQL Server 2016 Enterprise), 201602(SQL Server 2016 Standard) and 2017(SQL Server 2017 Enterprise). Default is 2008R2.
haType String
It has been deprecated from version 1.81.136. Instance type. DUAL (dual-server high availability), CLUSTER (cluster). Default is DUAL.

Deprecated: Deprecated

maintenanceStartTime String
Start time of the maintenance in one day, format like HH:mm.
maintenanceTimeSpan Double
The timespan of maintenance in one day, unit is hour.
maintenanceWeekSets List<Double>
A list of integer indicates weekly maintenance. For example, [2,7] presents do weekly maintenance on every Tuesday and Sunday.
memory Double
Memory size (in GB). Allowed value must be larger than memory that data source tencentcloud_sqlserver_specinfos provides.
multiZones Boolean
Indicate whether to deploy across availability zones.
name String
Name of the SQL Server instance.
period Double
Purchase instance period in month. The value does not exceed 48.
projectId Double
Project ID, default value is 0.
roFlag String
Readonly flag. RO (read-only instance), MASTER (primary instance with read-only instances). If it is left empty, it refers to an instance which is not read-only and has no RO group.
securityGroups List<String>
Security group bound to the instance.
sqlserverInstanceId String
ID of the resource.
status Double
Status of the SQL Server instance. 1 for applying, 2 for running, 3 for running with limit, 4 for isolated, 5 for recycling, 6 for recycled, 7 for running with task, 8 for off-line, 9 for expanding, 10 for migrating, 11 for readonly, 12 for rebooting.
storage Double
Disk size (in GB). Allowed value must be a multiple of 10. The storage must be set with the limit of storage_min and storage_max which data source tencentcloud_sqlserver_specinfos provides.
subnetId String
ID of subnet.
tags Map<String,String>
The tags of the SQL Server.
tgwWanVport Double
External port number.
timeZone String
System time zone, default: China Standard Time.
vip String
IP for private access.
voucherIds List<String>
An array of voucher IDs, currently only one can be used for a single order.
vpcId String
ID of VPC.
vport Double
Port for private access.
waitSwitch Double
It has been deprecated from version 1.81.2. The way to execute the allocation. Supported values include: 0 - execute immediately, 1 - execute in maintenance window.

Deprecated: Deprecated

autoRenew number
Automatic renewal sign. 0 for normal renewal, 1 for automatic renewal (Default). Only valid when purchasing a prepaid instance.
autoVoucher number
Whether to use the voucher automatically; 1 for yes, 0 for no, the default is 0.
availabilityZone string
Availability zone.
chargeType string
Pay type of the SQL Server instance. Available values PREPAID, POSTPAID_BY_HOUR.
createTime string
Create time of the SQL Server instance.
dnsPodDomain string
Internet address domain name.
engineVersion string
Version of the SQL Server database engine. Allowed values are 2008R2(SQL Server 2008 Enterprise), 2012SP3(SQL Server 2012 Enterprise), 2016SP1 (SQL Server 2016 Enterprise), 201602(SQL Server 2016 Standard) and 2017(SQL Server 2017 Enterprise). Default is 2008R2.
haType string
It has been deprecated from version 1.81.136. Instance type. DUAL (dual-server high availability), CLUSTER (cluster). Default is DUAL.

Deprecated: Deprecated

maintenanceStartTime string
Start time of the maintenance in one day, format like HH:mm.
maintenanceTimeSpan number
The timespan of maintenance in one day, unit is hour.
maintenanceWeekSets number[]
A list of integer indicates weekly maintenance. For example, [2,7] presents do weekly maintenance on every Tuesday and Sunday.
memory number
Memory size (in GB). Allowed value must be larger than memory that data source tencentcloud_sqlserver_specinfos provides.
multiZones boolean
Indicate whether to deploy across availability zones.
name string
Name of the SQL Server instance.
period number
Purchase instance period in month. The value does not exceed 48.
projectId number
Project ID, default value is 0.
roFlag string
Readonly flag. RO (read-only instance), MASTER (primary instance with read-only instances). If it is left empty, it refers to an instance which is not read-only and has no RO group.
securityGroups string[]
Security group bound to the instance.
sqlserverInstanceId string
ID of the resource.
status number
Status of the SQL Server instance. 1 for applying, 2 for running, 3 for running with limit, 4 for isolated, 5 for recycling, 6 for recycled, 7 for running with task, 8 for off-line, 9 for expanding, 10 for migrating, 11 for readonly, 12 for rebooting.
storage number
Disk size (in GB). Allowed value must be a multiple of 10. The storage must be set with the limit of storage_min and storage_max which data source tencentcloud_sqlserver_specinfos provides.
subnetId string
ID of subnet.
tags {[key: string]: string}
The tags of the SQL Server.
tgwWanVport number
External port number.
timeZone string
System time zone, default: China Standard Time.
vip string
IP for private access.
voucherIds string[]
An array of voucher IDs, currently only one can be used for a single order.
vpcId string
ID of VPC.
vport number
Port for private access.
waitSwitch number
It has been deprecated from version 1.81.2. The way to execute the allocation. Supported values include: 0 - execute immediately, 1 - execute in maintenance window.

Deprecated: Deprecated

auto_renew float
Automatic renewal sign. 0 for normal renewal, 1 for automatic renewal (Default). Only valid when purchasing a prepaid instance.
auto_voucher float
Whether to use the voucher automatically; 1 for yes, 0 for no, the default is 0.
availability_zone str
Availability zone.
charge_type str
Pay type of the SQL Server instance. Available values PREPAID, POSTPAID_BY_HOUR.
create_time str
Create time of the SQL Server instance.
dns_pod_domain str
Internet address domain name.
engine_version str
Version of the SQL Server database engine. Allowed values are 2008R2(SQL Server 2008 Enterprise), 2012SP3(SQL Server 2012 Enterprise), 2016SP1 (SQL Server 2016 Enterprise), 201602(SQL Server 2016 Standard) and 2017(SQL Server 2017 Enterprise). Default is 2008R2.
ha_type str
It has been deprecated from version 1.81.136. Instance type. DUAL (dual-server high availability), CLUSTER (cluster). Default is DUAL.

Deprecated: Deprecated

maintenance_start_time str
Start time of the maintenance in one day, format like HH:mm.
maintenance_time_span float
The timespan of maintenance in one day, unit is hour.
maintenance_week_sets Sequence[float]
A list of integer indicates weekly maintenance. For example, [2,7] presents do weekly maintenance on every Tuesday and Sunday.
memory float
Memory size (in GB). Allowed value must be larger than memory that data source tencentcloud_sqlserver_specinfos provides.
multi_zones bool
Indicate whether to deploy across availability zones.
name str
Name of the SQL Server instance.
period float
Purchase instance period in month. The value does not exceed 48.
project_id float
Project ID, default value is 0.
ro_flag str
Readonly flag. RO (read-only instance), MASTER (primary instance with read-only instances). If it is left empty, it refers to an instance which is not read-only and has no RO group.
security_groups Sequence[str]
Security group bound to the instance.
sqlserver_instance_id str
ID of the resource.
status float
Status of the SQL Server instance. 1 for applying, 2 for running, 3 for running with limit, 4 for isolated, 5 for recycling, 6 for recycled, 7 for running with task, 8 for off-line, 9 for expanding, 10 for migrating, 11 for readonly, 12 for rebooting.
storage float
Disk size (in GB). Allowed value must be a multiple of 10. The storage must be set with the limit of storage_min and storage_max which data source tencentcloud_sqlserver_specinfos provides.
subnet_id str
ID of subnet.
tags Mapping[str, str]
The tags of the SQL Server.
tgw_wan_vport float
External port number.
time_zone str
System time zone, default: China Standard Time.
vip str
IP for private access.
voucher_ids Sequence[str]
An array of voucher IDs, currently only one can be used for a single order.
vpc_id str
ID of VPC.
vport float
Port for private access.
wait_switch float
It has been deprecated from version 1.81.2. The way to execute the allocation. Supported values include: 0 - execute immediately, 1 - execute in maintenance window.

Deprecated: Deprecated

autoRenew Number
Automatic renewal sign. 0 for normal renewal, 1 for automatic renewal (Default). Only valid when purchasing a prepaid instance.
autoVoucher Number
Whether to use the voucher automatically; 1 for yes, 0 for no, the default is 0.
availabilityZone String
Availability zone.
chargeType String
Pay type of the SQL Server instance. Available values PREPAID, POSTPAID_BY_HOUR.
createTime String
Create time of the SQL Server instance.
dnsPodDomain String
Internet address domain name.
engineVersion String
Version of the SQL Server database engine. Allowed values are 2008R2(SQL Server 2008 Enterprise), 2012SP3(SQL Server 2012 Enterprise), 2016SP1 (SQL Server 2016 Enterprise), 201602(SQL Server 2016 Standard) and 2017(SQL Server 2017 Enterprise). Default is 2008R2.
haType String
It has been deprecated from version 1.81.136. Instance type. DUAL (dual-server high availability), CLUSTER (cluster). Default is DUAL.

Deprecated: Deprecated

maintenanceStartTime String
Start time of the maintenance in one day, format like HH:mm.
maintenanceTimeSpan Number
The timespan of maintenance in one day, unit is hour.
maintenanceWeekSets List<Number>
A list of integer indicates weekly maintenance. For example, [2,7] presents do weekly maintenance on every Tuesday and Sunday.
memory Number
Memory size (in GB). Allowed value must be larger than memory that data source tencentcloud_sqlserver_specinfos provides.
multiZones Boolean
Indicate whether to deploy across availability zones.
name String
Name of the SQL Server instance.
period Number
Purchase instance period in month. The value does not exceed 48.
projectId Number
Project ID, default value is 0.
roFlag String
Readonly flag. RO (read-only instance), MASTER (primary instance with read-only instances). If it is left empty, it refers to an instance which is not read-only and has no RO group.
securityGroups List<String>
Security group bound to the instance.
sqlserverInstanceId String
ID of the resource.
status Number
Status of the SQL Server instance. 1 for applying, 2 for running, 3 for running with limit, 4 for isolated, 5 for recycling, 6 for recycled, 7 for running with task, 8 for off-line, 9 for expanding, 10 for migrating, 11 for readonly, 12 for rebooting.
storage Number
Disk size (in GB). Allowed value must be a multiple of 10. The storage must be set with the limit of storage_min and storage_max which data source tencentcloud_sqlserver_specinfos provides.
subnetId String
ID of subnet.
tags Map<String>
The tags of the SQL Server.
tgwWanVport Number
External port number.
timeZone String
System time zone, default: China Standard Time.
vip String
IP for private access.
voucherIds List<String>
An array of voucher IDs, currently only one can be used for a single order.
vpcId String
ID of VPC.
vport Number
Port for private access.
waitSwitch Number
It has been deprecated from version 1.81.2. The way to execute the allocation. Supported values include: 0 - execute immediately, 1 - execute in maintenance window.

Deprecated: Deprecated

Import

SQL Server instance can be imported using the id, e.g.

$ pulumi import tencentcloud:index/sqlserverInstance:SqlserverInstance example mssql-3cdq7kx5
Copy

To learn more about importing existing cloud resources, see Importing resources.

Package Details

Repository
tencentcloud tencentcloudstack/terraform-provider-tencentcloud
License
Notes
This Pulumi package is based on the tencentcloud Terraform Provider.