Docs Home Pulumi IaC Pulumi ESC Pulumi Insights Pulumi Cloud Packages Tutorials
  1. Packages
  2. Tencentcloud Provider
  3. API Docs
  4. SqlserverInstance
tencentcloud 1.81.189 published on Wednesday, Apr 30, 2025 by tencentcloudstack
tencentcloudstack/terraform-provider-tencentcloud

tencentcloud.SqlserverInstance

Explore with Pulumi AI

tencentcloud logo
tencentcloud 1.81.189 published on Wednesday, Apr 30, 2025 by tencentcloudstack
tencentcloudstack/terraform-provider-tencentcloud

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

    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)

    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
	})
}

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

});

    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());

    }
}

    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

    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 string
    The unique name of the resource.
    args SqlserverInstanceArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    resource_name str
    The unique name of the resource.
    args SqlserverInstanceArgs
    The arguments to resource properties.
    opts ResourceOptions
    Bag of options to control resource's behavior.
    ctx Context
    Context object for the current deployment.
    name string
    The unique name of the resource.
    args SqlserverInstanceArgs
    The arguments to resource properties.
    opts ResourceOption
    Bag of options to control resource's behavior.
    name string
    The unique name of the resource.
    args SqlserverInstanceArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    name String
    The unique name of the resource.
    args SqlserverInstanceArgs
    The arguments to resource properties.
    options CustomResourceOptions
    Bag of options to control resource's behavior.

    SqlserverInstance Resource Properties

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

    Inputs

    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 double
    Memory size (in GB). Allowed value must be larger than memory that data source tencentcloud_sqlserver_specinfos provides.
    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.
    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 float64
    Memory size (in GB). Allowed value must be larger than memory that data source tencentcloud_sqlserver_specinfos provides.
    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.
    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 Double
    Memory size (in GB). Allowed value must be larger than memory that data source tencentcloud_sqlserver_specinfos provides.
    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.
    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 number
    Memory size (in GB). Allowed value must be larger than memory that data source tencentcloud_sqlserver_specinfos provides.
    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.
    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 float
    Memory size (in GB). Allowed value must be larger than memory that data source tencentcloud_sqlserver_specinfos provides.
    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.
    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 Number
    Memory size (in GB). Allowed value must be larger than memory that data source tencentcloud_sqlserver_specinfos provides.
    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.
    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
    The unique name of the resulting resource.
    id
    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
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    name
    The unique name of the resulting resource.
    id
    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
    The unique name of the resulting resource.
    id
    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
    The unique name of the resulting resource.
    id
    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

    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.
    tencentcloud logo
    tencentcloud 1.81.189 published on Wednesday, Apr 30, 2025 by tencentcloudstack
    tencentcloudstack/terraform-provider-tencentcloud