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

tencentcloud.SqlserverGeneralCloudInstance

Explore with Pulumi AI

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

    Provides a resource to create a sqlserver general_cloud_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 securityGroup = new tencentcloud.SecurityGroup("securityGroup", {description: "desc."});
const example = new tencentcloud.SqlserverGeneralCloudInstance("example", {
    zone: zones.then(zones => zones.zones?.[4]?.name),
    memory: 4,
    storage: 100,
    cpu: 2,
    machineType: "CLOUD_HSSD",
    instanceChargeType: "POSTPAID",
    projectId: 0,
    subnetId: subnet.subnetId,
    vpcId: vpc.vpcId,
    dbVersion: "2008R2",
    securityGroupLists: [securityGroup.securityGroupId],
    weeklies: [
        1,
        2,
        3,
        5,
        6,
        7,
    ],
    startTime: "00:00",
    span: 6,
    resourceTags: [{
        tagKey: "test",
        tagValue: "test",
    }],
    collation: "Chinese_PRC_CI_AS",
    timeZone: "China Standard Time",
});

    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)
security_group = tencentcloud.SecurityGroup("securityGroup", description="desc.")
example = tencentcloud.SqlserverGeneralCloudInstance("example",
    zone=zones.zones[4].name,
    memory=4,
    storage=100,
    cpu=2,
    machine_type="CLOUD_HSSD",
    instance_charge_type="POSTPAID",
    project_id=0,
    subnet_id=subnet.subnet_id,
    vpc_id=vpc.vpc_id,
    db_version="2008R2",
    security_group_lists=[security_group.security_group_id],
    weeklies=[
        1,
        2,
        3,
        5,
        6,
        7,
    ],
    start_time="00:00",
    span=6,
    resource_tags=[{
        "tag_key": "test",
        "tag_value": "test",
    }],
    collation="Chinese_PRC_CI_AS",
    time_zone="China Standard Time")

    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
		}
		securityGroup, err := tencentcloud.NewSecurityGroup(ctx, "securityGroup", &tencentcloud.SecurityGroupArgs{
			Description: pulumi.String("desc."),
		})
		if err != nil {
			return err
		}
		_, err = tencentcloud.NewSqlserverGeneralCloudInstance(ctx, "example", &tencentcloud.SqlserverGeneralCloudInstanceArgs{
			Zone:               pulumi.String(zones.Zones[4].Name),
			Memory:             pulumi.Float64(4),
			Storage:            pulumi.Float64(100),
			Cpu:                pulumi.Float64(2),
			MachineType:        pulumi.String("CLOUD_HSSD"),
			InstanceChargeType: pulumi.String("POSTPAID"),
			ProjectId:          pulumi.Float64(0),
			SubnetId:           subnet.SubnetId,
			VpcId:              vpc.VpcId,
			DbVersion:          pulumi.String("2008R2"),
			SecurityGroupLists: pulumi.StringArray{
				securityGroup.SecurityGroupId,
			},
			Weeklies: pulumi.Float64Array{
				pulumi.Float64(1),
				pulumi.Float64(2),
				pulumi.Float64(3),
				pulumi.Float64(5),
				pulumi.Float64(6),
				pulumi.Float64(7),
			},
			StartTime: pulumi.String("00:00"),
			Span:      pulumi.Float64(6),
			ResourceTags: tencentcloud.SqlserverGeneralCloudInstanceResourceTagArray{
				&tencentcloud.SqlserverGeneralCloudInstanceResourceTagArgs{
					TagKey:   pulumi.String("test"),
					TagValue: pulumi.String("test"),
				},
			},
			Collation: pulumi.String("Chinese_PRC_CI_AS"),
			TimeZone:  pulumi.String("China Standard Time"),
		})
		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 securityGroup = new Tencentcloud.SecurityGroup("securityGroup", new()
    {
        Description = "desc.",
    });

    var example = new Tencentcloud.SqlserverGeneralCloudInstance("example", new()
    {
        Zone = zones.Apply(getAvailabilityZonesByProductResult => getAvailabilityZonesByProductResult.Zones[4]?.Name),
        Memory = 4,
        Storage = 100,
        Cpu = 2,
        MachineType = "CLOUD_HSSD",
        InstanceChargeType = "POSTPAID",
        ProjectId = 0,
        SubnetId = subnet.SubnetId,
        VpcId = vpc.VpcId,
        DbVersion = "2008R2",
        SecurityGroupLists = new[]
        {
            securityGroup.SecurityGroupId,
        },
        Weeklies = new[]
        {
            1,
            2,
            3,
            5,
            6,
            7,
        },
        StartTime = "00:00",
        Span = 6,
        ResourceTags = new[]
        {
            new Tencentcloud.Inputs.SqlserverGeneralCloudInstanceResourceTagArgs
            {
                TagKey = "test",
                TagValue = "test",
            },
        },
        Collation = "Chinese_PRC_CI_AS",
        TimeZone = "China Standard Time",
    });

});

    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.SecurityGroup;
import com.pulumi.tencentcloud.SecurityGroupArgs;
import com.pulumi.tencentcloud.SqlserverGeneralCloudInstance;
import com.pulumi.tencentcloud.SqlserverGeneralCloudInstanceArgs;
import com.pulumi.tencentcloud.inputs.SqlserverGeneralCloudInstanceResourceTagArgs;
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 securityGroup = new SecurityGroup("securityGroup", SecurityGroupArgs.builder()
            .description("desc.")
            .build());

        var example = new SqlserverGeneralCloudInstance("example", SqlserverGeneralCloudInstanceArgs.builder()
            .zone(zones.applyValue(getAvailabilityZonesByProductResult -> getAvailabilityZonesByProductResult.zones()[4].name()))
            .memory(4)
            .storage(100)
            .cpu(2)
            .machineType("CLOUD_HSSD")
            .instanceChargeType("POSTPAID")
            .projectId(0)
            .subnetId(subnet.subnetId())
            .vpcId(vpc.vpcId())
            .dbVersion("2008R2")
            .securityGroupLists(securityGroup.securityGroupId())
            .weeklies(            
                1,
                2,
                3,
                5,
                6,
                7)
            .startTime("00:00")
            .span(6)
            .resourceTags(SqlserverGeneralCloudInstanceResourceTagArgs.builder()
                .tagKey("test")
                .tagValue("test")
                .build())
            .collation("Chinese_PRC_CI_AS")
            .timeZone("China Standard Time")
            .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
  securityGroup:
    type: tencentcloud:SecurityGroup
    properties:
      description: desc.
  example:
    type: tencentcloud:SqlserverGeneralCloudInstance
    properties:
      zone: ${zones.zones[4].name}
      memory: 4
      storage: 100
      cpu: 2
      machineType: CLOUD_HSSD
      instanceChargeType: POSTPAID
      projectId: 0
      subnetId: ${subnet.subnetId}
      vpcId: ${vpc.vpcId}
      dbVersion: 2008R2
      securityGroupLists:
        - ${securityGroup.securityGroupId}
      weeklies:
        - 1
        - 2
        - 3
        - 5
        - 6
        - 7
      startTime: 00:00
      span: 6
      resourceTags:
        - tagKey: test
          tagValue: test
      collation: Chinese_PRC_CI_AS
      timeZone: China Standard Time
variables:
  zones:
    fn::invoke:
      function: tencentcloud:getAvailabilityZonesByProduct
      arguments:
        product: sqlserver

    Create SqlserverGeneralCloudInstance Resource

    Resources are created with functions called constructors. To learn more about declaring and configuring resources, see Resources.

    Constructor syntax

    new SqlserverGeneralCloudInstance(name: string, args: SqlserverGeneralCloudInstanceArgs, opts?: CustomResourceOptions);
    @overload
def SqlserverGeneralCloudInstance(resource_name: str,
                                  args: SqlserverGeneralCloudInstanceArgs,
                                  opts: Optional[ResourceOptions] = None)

@overload
def SqlserverGeneralCloudInstance(resource_name: str,
                                  opts: Optional[ResourceOptions] = None,
                                  machine_type: Optional[str] = None,
                                  zone: Optional[str] = None,
                                  cpu: Optional[float] = None,
                                  storage: Optional[float] = None,
                                  memory: Optional[float] = None,
                                  name: Optional[str] = None,
                                  security_group_lists: Optional[Sequence[str]] = None,
                                  instance_charge_type: Optional[str] = None,
                                  dr_zones: Optional[Sequence[str]] = None,
                                  disk_encrypt_flag: Optional[float] = None,
                                  multi_nodes: Optional[bool] = None,
                                  multi_zones: Optional[bool] = None,
                                  auto_renew_flag: Optional[float] = None,
                                  period: Optional[float] = None,
                                  project_id: Optional[float] = None,
                                  resource_tags: Optional[Sequence[SqlserverGeneralCloudInstanceResourceTagArgs]] = None,
                                  ha_type: Optional[str] = None,
                                  span: Optional[float] = None,
                                  sqlserver_general_cloud_instance_id: Optional[str] = None,
                                  start_time: Optional[str] = None,
                                  db_version: Optional[str] = None,
                                  subnet_id: Optional[str] = None,
                                  time_zone: Optional[str] = None,
                                  vpc_id: Optional[str] = None,
                                  weeklies: Optional[Sequence[float]] = None,
                                  collation: Optional[str] = None)
    func NewSqlserverGeneralCloudInstance(ctx *Context, name string, args SqlserverGeneralCloudInstanceArgs, opts ...ResourceOption) (*SqlserverGeneralCloudInstance, error)
    public SqlserverGeneralCloudInstance(string name, SqlserverGeneralCloudInstanceArgs args, CustomResourceOptions? opts = null)
    public SqlserverGeneralCloudInstance(String name, SqlserverGeneralCloudInstanceArgs args)
public SqlserverGeneralCloudInstance(String name, SqlserverGeneralCloudInstanceArgs args, CustomResourceOptions options)

    type: tencentcloud:SqlserverGeneralCloudInstance
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 SqlserverGeneralCloudInstanceArgs
    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 SqlserverGeneralCloudInstanceArgs
    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 SqlserverGeneralCloudInstanceArgs
    The arguments to resource properties.
    opts ResourceOption
    Bag of options to control resource's behavior.
    name string
    The unique name of the resource.
    args SqlserverGeneralCloudInstanceArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    name String
    The unique name of the resource.
    args SqlserverGeneralCloudInstanceArgs
    The arguments to resource properties.
    options CustomResourceOptions
    Bag of options to control resource's behavior.

    SqlserverGeneralCloudInstance 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 SqlserverGeneralCloudInstance resource accepts the following input properties:

    Cpu double
    Cpu, unit: CORE.
    MachineType string
    The host disk type of the purchased instance, CLOUD_HSSD-enhanced SSD cloud disk for virtual machines, CLOUD_TSSD-extremely fast SSD cloud disk for virtual machines, CLOUD_BSSD-universal SSD cloud disk for virtual machines.
    Memory double
    Memory, unit: GB.
    Storage double
    instance disk storage, unit: GB.
    Zone string
    Instance AZ, such as ap-guangzhou-1 (Guangzhou Zone 1). Purchasable AZs for an instance can be obtained through the DescribeZones API.
    AutoRenewFlag double
    Automatic renewal flag: 0-normal renewal 1-automatic renewal, the default is 1 automatic renewal. Valid only when purchasing a prepaid instance. Valid only when the 'instance_charge_type' parameter value is 'PREPAID'.
    Collation string
    System character set collation, default: Chinese_PRC_CI_AS.
    DbVersion string
    sqlserver version, currently all supported versions are: 2008R2 (SQL Server 2008 R2 Enterprise), 2012SP3 (SQL Server 2012 Enterprise), 201202 (SQL Server 2012 Standard), 2014SP2 (SQL Server 2014 Enterprise), 201402 (SQL Server 2014 Standard), 2016SP1 (SQL Server 2016 Enterprise), 201602 (SQL Server 2016 Standard), 2017 (SQL Server 2017 Enterprise), 201702 (SQL Server 2017 Standard), 2019 (SQL Server 2019 Enterprise), 201902 (SQL Server 2019 Standard). Each region supports different versions for sale, and the version information that can be sold in each region can be pulled through the DescribeProductConfig interface. If left blank, the default version is 2008R2.
    DiskEncryptFlag double
    Disk encryption identification, 0-not encrypted, 1-encrypted.
    DrZones List<string>
    The standby node availability area is empty by default. When MultiNodes = true, the primary node and standby node availability areas cannot all be the same. The minimum number of standby availability areas set is 2, and the maximum number is no more than 5.
    HaType string
    It has been deprecated from version 1.81.2. Upgrade the high-availability architecture of sqlserver, upgrade from mirror disaster recovery to always on cluster disaster recovery, only support 2017 and above and support always on high-availability instances, do not support downgrading to mirror disaster recovery, CLUSTER-upgrade to always on capacity Disaster, if not filled, the high-availability architecture will not be modified.

    Deprecated: Deprecated

    InstanceChargeType string
    Payment mode, the value supports PREPAID (prepaid), POSTPAID (postpaid).
    MultiNodes bool
    Whether it is a multi-node architecture instance, the default value is false. When MultiNodes = true, the parameter MultiZones must be true.
    MultiZones bool
    Whether to deploy across availability zones, the default value is false.
    Name string
    Name of the SQL Server instance.
    Period double
    Purchase instance period, the default value is 1, which means one month. The value cannot exceed 48. Valid only when the 'instance_charge_type' parameter value is 'PREPAID'.
    ProjectId double
    project ID.
    ResourceTags List<SqlserverGeneralCloudInstanceResourceTag>
    A collection of tags bound to the new instance.
    SecurityGroupLists List<string>
    Security group list, fill in the security group ID in the form of sg-xxx.
    Span double
    Maintainable time window configuration, duration, unit: hour.
    SqlserverGeneralCloudInstanceId string
    ID of the resource.
    StartTime string
    Maintainable time window configuration, daily maintainable start time.
    SubnetId string
    VPC subnet ID, in the form of subnet-bdoe83fa; SubnetId and VpcId need to be set at the same time or not set at the same time.
    TimeZone string
    System time zone, default: China Standard Time.
    VpcId string
    VPC network ID, in the form of vpc-dsp338hz; SubnetId and VpcId need to be set at the same time or not set at the same time.
    Weeklies List<double>
    Maintainable time window configuration, in weeks, indicates the days of the week that allow maintenance, 1-7 represent Monday to weekend respectively.
    Cpu float64
    Cpu, unit: CORE.
    MachineType string
    The host disk type of the purchased instance, CLOUD_HSSD-enhanced SSD cloud disk for virtual machines, CLOUD_TSSD-extremely fast SSD cloud disk for virtual machines, CLOUD_BSSD-universal SSD cloud disk for virtual machines.
    Memory float64
    Memory, unit: GB.
    Storage float64
    instance disk storage, unit: GB.
    Zone string
    Instance AZ, such as ap-guangzhou-1 (Guangzhou Zone 1). Purchasable AZs for an instance can be obtained through the DescribeZones API.
    AutoRenewFlag float64
    Automatic renewal flag: 0-normal renewal 1-automatic renewal, the default is 1 automatic renewal. Valid only when purchasing a prepaid instance. Valid only when the 'instance_charge_type' parameter value is 'PREPAID'.
    Collation string
    System character set collation, default: Chinese_PRC_CI_AS.
    DbVersion string
    sqlserver version, currently all supported versions are: 2008R2 (SQL Server 2008 R2 Enterprise), 2012SP3 (SQL Server 2012 Enterprise), 201202 (SQL Server 2012 Standard), 2014SP2 (SQL Server 2014 Enterprise), 201402 (SQL Server 2014 Standard), 2016SP1 (SQL Server 2016 Enterprise), 201602 (SQL Server 2016 Standard), 2017 (SQL Server 2017 Enterprise), 201702 (SQL Server 2017 Standard), 2019 (SQL Server 2019 Enterprise), 201902 (SQL Server 2019 Standard). Each region supports different versions for sale, and the version information that can be sold in each region can be pulled through the DescribeProductConfig interface. If left blank, the default version is 2008R2.
    DiskEncryptFlag float64
    Disk encryption identification, 0-not encrypted, 1-encrypted.
    DrZones []string
    The standby node availability area is empty by default. When MultiNodes = true, the primary node and standby node availability areas cannot all be the same. The minimum number of standby availability areas set is 2, and the maximum number is no more than 5.
    HaType string
    It has been deprecated from version 1.81.2. Upgrade the high-availability architecture of sqlserver, upgrade from mirror disaster recovery to always on cluster disaster recovery, only support 2017 and above and support always on high-availability instances, do not support downgrading to mirror disaster recovery, CLUSTER-upgrade to always on capacity Disaster, if not filled, the high-availability architecture will not be modified.

    Deprecated: Deprecated

    InstanceChargeType string
    Payment mode, the value supports PREPAID (prepaid), POSTPAID (postpaid).
    MultiNodes bool
    Whether it is a multi-node architecture instance, the default value is false. When MultiNodes = true, the parameter MultiZones must be true.
    MultiZones bool
    Whether to deploy across availability zones, the default value is false.
    Name string
    Name of the SQL Server instance.
    Period float64
    Purchase instance period, the default value is 1, which means one month. The value cannot exceed 48. Valid only when the 'instance_charge_type' parameter value is 'PREPAID'.
    ProjectId float64
    project ID.
    ResourceTags []SqlserverGeneralCloudInstanceResourceTagArgs
    A collection of tags bound to the new instance.
    SecurityGroupLists []string
    Security group list, fill in the security group ID in the form of sg-xxx.
    Span float64
    Maintainable time window configuration, duration, unit: hour.
    SqlserverGeneralCloudInstanceId string
    ID of the resource.
    StartTime string
    Maintainable time window configuration, daily maintainable start time.
    SubnetId string
    VPC subnet ID, in the form of subnet-bdoe83fa; SubnetId and VpcId need to be set at the same time or not set at the same time.
    TimeZone string
    System time zone, default: China Standard Time.
    VpcId string
    VPC network ID, in the form of vpc-dsp338hz; SubnetId and VpcId need to be set at the same time or not set at the same time.
    Weeklies []float64
    Maintainable time window configuration, in weeks, indicates the days of the week that allow maintenance, 1-7 represent Monday to weekend respectively.
    cpu Double
    Cpu, unit: CORE.
    machineType String
    The host disk type of the purchased instance, CLOUD_HSSD-enhanced SSD cloud disk for virtual machines, CLOUD_TSSD-extremely fast SSD cloud disk for virtual machines, CLOUD_BSSD-universal SSD cloud disk for virtual machines.
    memory Double
    Memory, unit: GB.
    storage Double
    instance disk storage, unit: GB.
    zone String
    Instance AZ, such as ap-guangzhou-1 (Guangzhou Zone 1). Purchasable AZs for an instance can be obtained through the DescribeZones API.
    autoRenewFlag Double
    Automatic renewal flag: 0-normal renewal 1-automatic renewal, the default is 1 automatic renewal. Valid only when purchasing a prepaid instance. Valid only when the 'instance_charge_type' parameter value is 'PREPAID'.
    collation String
    System character set collation, default: Chinese_PRC_CI_AS.
    dbVersion String
    sqlserver version, currently all supported versions are: 2008R2 (SQL Server 2008 R2 Enterprise), 2012SP3 (SQL Server 2012 Enterprise), 201202 (SQL Server 2012 Standard), 2014SP2 (SQL Server 2014 Enterprise), 201402 (SQL Server 2014 Standard), 2016SP1 (SQL Server 2016 Enterprise), 201602 (SQL Server 2016 Standard), 2017 (SQL Server 2017 Enterprise), 201702 (SQL Server 2017 Standard), 2019 (SQL Server 2019 Enterprise), 201902 (SQL Server 2019 Standard). Each region supports different versions for sale, and the version information that can be sold in each region can be pulled through the DescribeProductConfig interface. If left blank, the default version is 2008R2.
    diskEncryptFlag Double
    Disk encryption identification, 0-not encrypted, 1-encrypted.
    drZones List<String>
    The standby node availability area is empty by default. When MultiNodes = true, the primary node and standby node availability areas cannot all be the same. The minimum number of standby availability areas set is 2, and the maximum number is no more than 5.
    haType String
    It has been deprecated from version 1.81.2. Upgrade the high-availability architecture of sqlserver, upgrade from mirror disaster recovery to always on cluster disaster recovery, only support 2017 and above and support always on high-availability instances, do not support downgrading to mirror disaster recovery, CLUSTER-upgrade to always on capacity Disaster, if not filled, the high-availability architecture will not be modified.

    Deprecated: Deprecated

    instanceChargeType String
    Payment mode, the value supports PREPAID (prepaid), POSTPAID (postpaid).
    multiNodes Boolean
    Whether it is a multi-node architecture instance, the default value is false. When MultiNodes = true, the parameter MultiZones must be true.
    multiZones Boolean
    Whether to deploy across availability zones, the default value is false.
    name String
    Name of the SQL Server instance.
    period Double
    Purchase instance period, the default value is 1, which means one month. The value cannot exceed 48. Valid only when the 'instance_charge_type' parameter value is 'PREPAID'.
    projectId Double
    project ID.
    resourceTags List<SqlserverGeneralCloudInstanceResourceTag>
    A collection of tags bound to the new instance.
    securityGroupLists List<String>
    Security group list, fill in the security group ID in the form of sg-xxx.
    span Double
    Maintainable time window configuration, duration, unit: hour.
    sqlserverGeneralCloudInstanceId String
    ID of the resource.
    startTime String
    Maintainable time window configuration, daily maintainable start time.
    subnetId String
    VPC subnet ID, in the form of subnet-bdoe83fa; SubnetId and VpcId need to be set at the same time or not set at the same time.
    timeZone String
    System time zone, default: China Standard Time.
    vpcId String
    VPC network ID, in the form of vpc-dsp338hz; SubnetId and VpcId need to be set at the same time or not set at the same time.
    weeklies List<Double>
    Maintainable time window configuration, in weeks, indicates the days of the week that allow maintenance, 1-7 represent Monday to weekend respectively.
    cpu number
    Cpu, unit: CORE.
    machineType string
    The host disk type of the purchased instance, CLOUD_HSSD-enhanced SSD cloud disk for virtual machines, CLOUD_TSSD-extremely fast SSD cloud disk for virtual machines, CLOUD_BSSD-universal SSD cloud disk for virtual machines.
    memory number
    Memory, unit: GB.
    storage number
    instance disk storage, unit: GB.
    zone string
    Instance AZ, such as ap-guangzhou-1 (Guangzhou Zone 1). Purchasable AZs for an instance can be obtained through the DescribeZones API.
    autoRenewFlag number
    Automatic renewal flag: 0-normal renewal 1-automatic renewal, the default is 1 automatic renewal. Valid only when purchasing a prepaid instance. Valid only when the 'instance_charge_type' parameter value is 'PREPAID'.
    collation string
    System character set collation, default: Chinese_PRC_CI_AS.
    dbVersion string
    sqlserver version, currently all supported versions are: 2008R2 (SQL Server 2008 R2 Enterprise), 2012SP3 (SQL Server 2012 Enterprise), 201202 (SQL Server 2012 Standard), 2014SP2 (SQL Server 2014 Enterprise), 201402 (SQL Server 2014 Standard), 2016SP1 (SQL Server 2016 Enterprise), 201602 (SQL Server 2016 Standard), 2017 (SQL Server 2017 Enterprise), 201702 (SQL Server 2017 Standard), 2019 (SQL Server 2019 Enterprise), 201902 (SQL Server 2019 Standard). Each region supports different versions for sale, and the version information that can be sold in each region can be pulled through the DescribeProductConfig interface. If left blank, the default version is 2008R2.
    diskEncryptFlag number
    Disk encryption identification, 0-not encrypted, 1-encrypted.
    drZones string[]
    The standby node availability area is empty by default. When MultiNodes = true, the primary node and standby node availability areas cannot all be the same. The minimum number of standby availability areas set is 2, and the maximum number is no more than 5.
    haType string
    It has been deprecated from version 1.81.2. Upgrade the high-availability architecture of sqlserver, upgrade from mirror disaster recovery to always on cluster disaster recovery, only support 2017 and above and support always on high-availability instances, do not support downgrading to mirror disaster recovery, CLUSTER-upgrade to always on capacity Disaster, if not filled, the high-availability architecture will not be modified.

    Deprecated: Deprecated

    instanceChargeType string
    Payment mode, the value supports PREPAID (prepaid), POSTPAID (postpaid).
    multiNodes boolean
    Whether it is a multi-node architecture instance, the default value is false. When MultiNodes = true, the parameter MultiZones must be true.
    multiZones boolean
    Whether to deploy across availability zones, the default value is false.
    name string
    Name of the SQL Server instance.
    period number
    Purchase instance period, the default value is 1, which means one month. The value cannot exceed 48. Valid only when the 'instance_charge_type' parameter value is 'PREPAID'.
    projectId number
    project ID.
    resourceTags SqlserverGeneralCloudInstanceResourceTag[]
    A collection of tags bound to the new instance.
    securityGroupLists string[]
    Security group list, fill in the security group ID in the form of sg-xxx.
    span number
    Maintainable time window configuration, duration, unit: hour.
    sqlserverGeneralCloudInstanceId string
    ID of the resource.
    startTime string
    Maintainable time window configuration, daily maintainable start time.
    subnetId string
    VPC subnet ID, in the form of subnet-bdoe83fa; SubnetId and VpcId need to be set at the same time or not set at the same time.
    timeZone string
    System time zone, default: China Standard Time.
    vpcId string
    VPC network ID, in the form of vpc-dsp338hz; SubnetId and VpcId need to be set at the same time or not set at the same time.
    weeklies number[]
    Maintainable time window configuration, in weeks, indicates the days of the week that allow maintenance, 1-7 represent Monday to weekend respectively.
    cpu float
    Cpu, unit: CORE.
    machine_type str
    The host disk type of the purchased instance, CLOUD_HSSD-enhanced SSD cloud disk for virtual machines, CLOUD_TSSD-extremely fast SSD cloud disk for virtual machines, CLOUD_BSSD-universal SSD cloud disk for virtual machines.
    memory float
    Memory, unit: GB.
    storage float
    instance disk storage, unit: GB.
    zone str
    Instance AZ, such as ap-guangzhou-1 (Guangzhou Zone 1). Purchasable AZs for an instance can be obtained through the DescribeZones API.
    auto_renew_flag float
    Automatic renewal flag: 0-normal renewal 1-automatic renewal, the default is 1 automatic renewal. Valid only when purchasing a prepaid instance. Valid only when the 'instance_charge_type' parameter value is 'PREPAID'.
    collation str
    System character set collation, default: Chinese_PRC_CI_AS.
    db_version str
    sqlserver version, currently all supported versions are: 2008R2 (SQL Server 2008 R2 Enterprise), 2012SP3 (SQL Server 2012 Enterprise), 201202 (SQL Server 2012 Standard), 2014SP2 (SQL Server 2014 Enterprise), 201402 (SQL Server 2014 Standard), 2016SP1 (SQL Server 2016 Enterprise), 201602 (SQL Server 2016 Standard), 2017 (SQL Server 2017 Enterprise), 201702 (SQL Server 2017 Standard), 2019 (SQL Server 2019 Enterprise), 201902 (SQL Server 2019 Standard). Each region supports different versions for sale, and the version information that can be sold in each region can be pulled through the DescribeProductConfig interface. If left blank, the default version is 2008R2.
    disk_encrypt_flag float
    Disk encryption identification, 0-not encrypted, 1-encrypted.
    dr_zones Sequence[str]
    The standby node availability area is empty by default. When MultiNodes = true, the primary node and standby node availability areas cannot all be the same. The minimum number of standby availability areas set is 2, and the maximum number is no more than 5.
    ha_type str
    It has been deprecated from version 1.81.2. Upgrade the high-availability architecture of sqlserver, upgrade from mirror disaster recovery to always on cluster disaster recovery, only support 2017 and above and support always on high-availability instances, do not support downgrading to mirror disaster recovery, CLUSTER-upgrade to always on capacity Disaster, if not filled, the high-availability architecture will not be modified.

    Deprecated: Deprecated

    instance_charge_type str
    Payment mode, the value supports PREPAID (prepaid), POSTPAID (postpaid).
    multi_nodes bool
    Whether it is a multi-node architecture instance, the default value is false. When MultiNodes = true, the parameter MultiZones must be true.
    multi_zones bool
    Whether to deploy across availability zones, the default value is false.
    name str
    Name of the SQL Server instance.
    period float
    Purchase instance period, the default value is 1, which means one month. The value cannot exceed 48. Valid only when the 'instance_charge_type' parameter value is 'PREPAID'.
    project_id float
    project ID.
    resource_tags Sequence[SqlserverGeneralCloudInstanceResourceTagArgs]
    A collection of tags bound to the new instance.
    security_group_lists Sequence[str]
    Security group list, fill in the security group ID in the form of sg-xxx.
    span float
    Maintainable time window configuration, duration, unit: hour.
    sqlserver_general_cloud_instance_id str
    ID of the resource.
    start_time str
    Maintainable time window configuration, daily maintainable start time.
    subnet_id str
    VPC subnet ID, in the form of subnet-bdoe83fa; SubnetId and VpcId need to be set at the same time or not set at the same time.
    time_zone str
    System time zone, default: China Standard Time.
    vpc_id str
    VPC network ID, in the form of vpc-dsp338hz; SubnetId and VpcId need to be set at the same time or not set at the same time.
    weeklies Sequence[float]
    Maintainable time window configuration, in weeks, indicates the days of the week that allow maintenance, 1-7 represent Monday to weekend respectively.
    cpu Number
    Cpu, unit: CORE.
    machineType String
    The host disk type of the purchased instance, CLOUD_HSSD-enhanced SSD cloud disk for virtual machines, CLOUD_TSSD-extremely fast SSD cloud disk for virtual machines, CLOUD_BSSD-universal SSD cloud disk for virtual machines.
    memory Number
    Memory, unit: GB.
    storage Number
    instance disk storage, unit: GB.
    zone String
    Instance AZ, such as ap-guangzhou-1 (Guangzhou Zone 1). Purchasable AZs for an instance can be obtained through the DescribeZones API.
    autoRenewFlag Number
    Automatic renewal flag: 0-normal renewal 1-automatic renewal, the default is 1 automatic renewal. Valid only when purchasing a prepaid instance. Valid only when the 'instance_charge_type' parameter value is 'PREPAID'.
    collation String
    System character set collation, default: Chinese_PRC_CI_AS.
    dbVersion String
    sqlserver version, currently all supported versions are: 2008R2 (SQL Server 2008 R2 Enterprise), 2012SP3 (SQL Server 2012 Enterprise), 201202 (SQL Server 2012 Standard), 2014SP2 (SQL Server 2014 Enterprise), 201402 (SQL Server 2014 Standard), 2016SP1 (SQL Server 2016 Enterprise), 201602 (SQL Server 2016 Standard), 2017 (SQL Server 2017 Enterprise), 201702 (SQL Server 2017 Standard), 2019 (SQL Server 2019 Enterprise), 201902 (SQL Server 2019 Standard). Each region supports different versions for sale, and the version information that can be sold in each region can be pulled through the DescribeProductConfig interface. If left blank, the default version is 2008R2.
    diskEncryptFlag Number
    Disk encryption identification, 0-not encrypted, 1-encrypted.
    drZones List<String>
    The standby node availability area is empty by default. When MultiNodes = true, the primary node and standby node availability areas cannot all be the same. The minimum number of standby availability areas set is 2, and the maximum number is no more than 5.
    haType String
    It has been deprecated from version 1.81.2. Upgrade the high-availability architecture of sqlserver, upgrade from mirror disaster recovery to always on cluster disaster recovery, only support 2017 and above and support always on high-availability instances, do not support downgrading to mirror disaster recovery, CLUSTER-upgrade to always on capacity Disaster, if not filled, the high-availability architecture will not be modified.

    Deprecated: Deprecated

    instanceChargeType String
    Payment mode, the value supports PREPAID (prepaid), POSTPAID (postpaid).
    multiNodes Boolean
    Whether it is a multi-node architecture instance, the default value is false. When MultiNodes = true, the parameter MultiZones must be true.
    multiZones Boolean
    Whether to deploy across availability zones, the default value is false.
    name String
    Name of the SQL Server instance.
    period Number
    Purchase instance period, the default value is 1, which means one month. The value cannot exceed 48. Valid only when the 'instance_charge_type' parameter value is 'PREPAID'.
    projectId Number
    project ID.
    resourceTags List<Property Map>
    A collection of tags bound to the new instance.
    securityGroupLists List<String>
    Security group list, fill in the security group ID in the form of sg-xxx.
    span Number
    Maintainable time window configuration, duration, unit: hour.
    sqlserverGeneralCloudInstanceId String
    ID of the resource.
    startTime String
    Maintainable time window configuration, daily maintainable start time.
    subnetId String
    VPC subnet ID, in the form of subnet-bdoe83fa; SubnetId and VpcId need to be set at the same time or not set at the same time.
    timeZone String
    System time zone, default: China Standard Time.
    vpcId String
    VPC network ID, in the form of vpc-dsp338hz; SubnetId and VpcId need to be set at the same time or not set at the same time.
    weeklies List<Number>
    Maintainable time window configuration, in weeks, indicates the days of the week that allow maintenance, 1-7 represent Monday to weekend respectively.

    Outputs

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

    DnsPodDomain string
    Internet address domain name.
    Id string
    The provider-assigned unique ID for this managed resource.
    TgwWanVport double
    External port number.
    DnsPodDomain string
    Internet address domain name.
    Id string
    The provider-assigned unique ID for this managed resource.
    TgwWanVport float64
    External port number.
    dnsPodDomain String
    Internet address domain name.
    id String
    The provider-assigned unique ID for this managed resource.
    tgwWanVport Double
    External port number.
    dnsPodDomain string
    Internet address domain name.
    id string
    The provider-assigned unique ID for this managed resource.
    tgwWanVport number
    External port number.
    dns_pod_domain str
    Internet address domain name.
    id str
    The provider-assigned unique ID for this managed resource.
    tgw_wan_vport float
    External port number.
    dnsPodDomain String
    Internet address domain name.
    id String
    The provider-assigned unique ID for this managed resource.
    tgwWanVport Number
    External port number.

    Look up Existing SqlserverGeneralCloudInstance Resource

    Get an existing SqlserverGeneralCloudInstance 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?: SqlserverGeneralCloudInstanceState, opts?: CustomResourceOptions): SqlserverGeneralCloudInstance
    @staticmethod
def get(resource_name: str,
        id: str,
        opts: Optional[ResourceOptions] = None,
        auto_renew_flag: Optional[float] = None,
        collation: Optional[str] = None,
        cpu: Optional[float] = None,
        db_version: Optional[str] = None,
        disk_encrypt_flag: Optional[float] = None,
        dns_pod_domain: Optional[str] = None,
        dr_zones: Optional[Sequence[str]] = None,
        ha_type: Optional[str] = None,
        instance_charge_type: Optional[str] = None,
        machine_type: Optional[str] = None,
        memory: Optional[float] = None,
        multi_nodes: Optional[bool] = None,
        multi_zones: Optional[bool] = None,
        name: Optional[str] = None,
        period: Optional[float] = None,
        project_id: Optional[float] = None,
        resource_tags: Optional[Sequence[SqlserverGeneralCloudInstanceResourceTagArgs]] = None,
        security_group_lists: Optional[Sequence[str]] = None,
        span: Optional[float] = None,
        sqlserver_general_cloud_instance_id: Optional[str] = None,
        start_time: Optional[str] = None,
        storage: Optional[float] = None,
        subnet_id: Optional[str] = None,
        tgw_wan_vport: Optional[float] = None,
        time_zone: Optional[str] = None,
        vpc_id: Optional[str] = None,
        weeklies: Optional[Sequence[float]] = None,
        zone: Optional[str] = None) -> SqlserverGeneralCloudInstance
    func GetSqlserverGeneralCloudInstance(ctx *Context, name string, id IDInput, state *SqlserverGeneralCloudInstanceState, opts ...ResourceOption) (*SqlserverGeneralCloudInstance, error)
    public static SqlserverGeneralCloudInstance Get(string name, Input<string> id, SqlserverGeneralCloudInstanceState? state, CustomResourceOptions? opts = null)
    public static SqlserverGeneralCloudInstance get(String name, Output<String> id, SqlserverGeneralCloudInstanceState state, CustomResourceOptions options)
    resources:  _:    type: tencentcloud:SqlserverGeneralCloudInstance    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:
    AutoRenewFlag double
    Automatic renewal flag: 0-normal renewal 1-automatic renewal, the default is 1 automatic renewal. Valid only when purchasing a prepaid instance. Valid only when the 'instance_charge_type' parameter value is 'PREPAID'.
    Collation string
    System character set collation, default: Chinese_PRC_CI_AS.
    Cpu double
    Cpu, unit: CORE.
    DbVersion string
    sqlserver version, currently all supported versions are: 2008R2 (SQL Server 2008 R2 Enterprise), 2012SP3 (SQL Server 2012 Enterprise), 201202 (SQL Server 2012 Standard), 2014SP2 (SQL Server 2014 Enterprise), 201402 (SQL Server 2014 Standard), 2016SP1 (SQL Server 2016 Enterprise), 201602 (SQL Server 2016 Standard), 2017 (SQL Server 2017 Enterprise), 201702 (SQL Server 2017 Standard), 2019 (SQL Server 2019 Enterprise), 201902 (SQL Server 2019 Standard). Each region supports different versions for sale, and the version information that can be sold in each region can be pulled through the DescribeProductConfig interface. If left blank, the default version is 2008R2.
    DiskEncryptFlag double
    Disk encryption identification, 0-not encrypted, 1-encrypted.
    DnsPodDomain string
    Internet address domain name.
    DrZones List<string>
    The standby node availability area is empty by default. When MultiNodes = true, the primary node and standby node availability areas cannot all be the same. The minimum number of standby availability areas set is 2, and the maximum number is no more than 5.
    HaType string
    It has been deprecated from version 1.81.2. Upgrade the high-availability architecture of sqlserver, upgrade from mirror disaster recovery to always on cluster disaster recovery, only support 2017 and above and support always on high-availability instances, do not support downgrading to mirror disaster recovery, CLUSTER-upgrade to always on capacity Disaster, if not filled, the high-availability architecture will not be modified.

    Deprecated: Deprecated

    InstanceChargeType string
    Payment mode, the value supports PREPAID (prepaid), POSTPAID (postpaid).
    MachineType string
    The host disk type of the purchased instance, CLOUD_HSSD-enhanced SSD cloud disk for virtual machines, CLOUD_TSSD-extremely fast SSD cloud disk for virtual machines, CLOUD_BSSD-universal SSD cloud disk for virtual machines.
    Memory double
    Memory, unit: GB.
    MultiNodes bool
    Whether it is a multi-node architecture instance, the default value is false. When MultiNodes = true, the parameter MultiZones must be true.
    MultiZones bool
    Whether to deploy across availability zones, the default value is false.
    Name string
    Name of the SQL Server instance.
    Period double
    Purchase instance period, the default value is 1, which means one month. The value cannot exceed 48. Valid only when the 'instance_charge_type' parameter value is 'PREPAID'.
    ProjectId double
    project ID.
    ResourceTags List<SqlserverGeneralCloudInstanceResourceTag>
    A collection of tags bound to the new instance.
    SecurityGroupLists List<string>
    Security group list, fill in the security group ID in the form of sg-xxx.
    Span double
    Maintainable time window configuration, duration, unit: hour.
    SqlserverGeneralCloudInstanceId string
    ID of the resource.
    StartTime string
    Maintainable time window configuration, daily maintainable start time.
    Storage double
    instance disk storage, unit: GB.
    SubnetId string
    VPC subnet ID, in the form of subnet-bdoe83fa; SubnetId and VpcId need to be set at the same time or not set at the same time.
    TgwWanVport double
    External port number.
    TimeZone string
    System time zone, default: China Standard Time.
    VpcId string
    VPC network ID, in the form of vpc-dsp338hz; SubnetId and VpcId need to be set at the same time or not set at the same time.
    Weeklies List<double>
    Maintainable time window configuration, in weeks, indicates the days of the week that allow maintenance, 1-7 represent Monday to weekend respectively.
    Zone string
    Instance AZ, such as ap-guangzhou-1 (Guangzhou Zone 1). Purchasable AZs for an instance can be obtained through the DescribeZones API.
    AutoRenewFlag float64
    Automatic renewal flag: 0-normal renewal 1-automatic renewal, the default is 1 automatic renewal. Valid only when purchasing a prepaid instance. Valid only when the 'instance_charge_type' parameter value is 'PREPAID'.
    Collation string
    System character set collation, default: Chinese_PRC_CI_AS.
    Cpu float64
    Cpu, unit: CORE.
    DbVersion string
    sqlserver version, currently all supported versions are: 2008R2 (SQL Server 2008 R2 Enterprise), 2012SP3 (SQL Server 2012 Enterprise), 201202 (SQL Server 2012 Standard), 2014SP2 (SQL Server 2014 Enterprise), 201402 (SQL Server 2014 Standard), 2016SP1 (SQL Server 2016 Enterprise), 201602 (SQL Server 2016 Standard), 2017 (SQL Server 2017 Enterprise), 201702 (SQL Server 2017 Standard), 2019 (SQL Server 2019 Enterprise), 201902 (SQL Server 2019 Standard). Each region supports different versions for sale, and the version information that can be sold in each region can be pulled through the DescribeProductConfig interface. If left blank, the default version is 2008R2.
    DiskEncryptFlag float64
    Disk encryption identification, 0-not encrypted, 1-encrypted.
    DnsPodDomain string
    Internet address domain name.
    DrZones []string
    The standby node availability area is empty by default. When MultiNodes = true, the primary node and standby node availability areas cannot all be the same. The minimum number of standby availability areas set is 2, and the maximum number is no more than 5.
    HaType string
    It has been deprecated from version 1.81.2. Upgrade the high-availability architecture of sqlserver, upgrade from mirror disaster recovery to always on cluster disaster recovery, only support 2017 and above and support always on high-availability instances, do not support downgrading to mirror disaster recovery, CLUSTER-upgrade to always on capacity Disaster, if not filled, the high-availability architecture will not be modified.

    Deprecated: Deprecated

    InstanceChargeType string
    Payment mode, the value supports PREPAID (prepaid), POSTPAID (postpaid).
    MachineType string
    The host disk type of the purchased instance, CLOUD_HSSD-enhanced SSD cloud disk for virtual machines, CLOUD_TSSD-extremely fast SSD cloud disk for virtual machines, CLOUD_BSSD-universal SSD cloud disk for virtual machines.
    Memory float64
    Memory, unit: GB.
    MultiNodes bool
    Whether it is a multi-node architecture instance, the default value is false. When MultiNodes = true, the parameter MultiZones must be true.
    MultiZones bool
    Whether to deploy across availability zones, the default value is false.
    Name string
    Name of the SQL Server instance.
    Period float64
    Purchase instance period, the default value is 1, which means one month. The value cannot exceed 48. Valid only when the 'instance_charge_type' parameter value is 'PREPAID'.
    ProjectId float64
    project ID.
    ResourceTags []SqlserverGeneralCloudInstanceResourceTagArgs
    A collection of tags bound to the new instance.
    SecurityGroupLists []string
    Security group list, fill in the security group ID in the form of sg-xxx.
    Span float64
    Maintainable time window configuration, duration, unit: hour.
    SqlserverGeneralCloudInstanceId string
    ID of the resource.
    StartTime string
    Maintainable time window configuration, daily maintainable start time.
    Storage float64
    instance disk storage, unit: GB.
    SubnetId string
    VPC subnet ID, in the form of subnet-bdoe83fa; SubnetId and VpcId need to be set at the same time or not set at the same time.
    TgwWanVport float64
    External port number.
    TimeZone string
    System time zone, default: China Standard Time.
    VpcId string
    VPC network ID, in the form of vpc-dsp338hz; SubnetId and VpcId need to be set at the same time or not set at the same time.
    Weeklies []float64
    Maintainable time window configuration, in weeks, indicates the days of the week that allow maintenance, 1-7 represent Monday to weekend respectively.
    Zone string
    Instance AZ, such as ap-guangzhou-1 (Guangzhou Zone 1). Purchasable AZs for an instance can be obtained through the DescribeZones API.
    autoRenewFlag Double
    Automatic renewal flag: 0-normal renewal 1-automatic renewal, the default is 1 automatic renewal. Valid only when purchasing a prepaid instance. Valid only when the 'instance_charge_type' parameter value is 'PREPAID'.
    collation String
    System character set collation, default: Chinese_PRC_CI_AS.
    cpu Double
    Cpu, unit: CORE.
    dbVersion String
    sqlserver version, currently all supported versions are: 2008R2 (SQL Server 2008 R2 Enterprise), 2012SP3 (SQL Server 2012 Enterprise), 201202 (SQL Server 2012 Standard), 2014SP2 (SQL Server 2014 Enterprise), 201402 (SQL Server 2014 Standard), 2016SP1 (SQL Server 2016 Enterprise), 201602 (SQL Server 2016 Standard), 2017 (SQL Server 2017 Enterprise), 201702 (SQL Server 2017 Standard), 2019 (SQL Server 2019 Enterprise), 201902 (SQL Server 2019 Standard). Each region supports different versions for sale, and the version information that can be sold in each region can be pulled through the DescribeProductConfig interface. If left blank, the default version is 2008R2.
    diskEncryptFlag Double
    Disk encryption identification, 0-not encrypted, 1-encrypted.
    dnsPodDomain String
    Internet address domain name.
    drZones List<String>
    The standby node availability area is empty by default. When MultiNodes = true, the primary node and standby node availability areas cannot all be the same. The minimum number of standby availability areas set is 2, and the maximum number is no more than 5.
    haType String
    It has been deprecated from version 1.81.2. Upgrade the high-availability architecture of sqlserver, upgrade from mirror disaster recovery to always on cluster disaster recovery, only support 2017 and above and support always on high-availability instances, do not support downgrading to mirror disaster recovery, CLUSTER-upgrade to always on capacity Disaster, if not filled, the high-availability architecture will not be modified.

    Deprecated: Deprecated

    instanceChargeType String
    Payment mode, the value supports PREPAID (prepaid), POSTPAID (postpaid).
    machineType String
    The host disk type of the purchased instance, CLOUD_HSSD-enhanced SSD cloud disk for virtual machines, CLOUD_TSSD-extremely fast SSD cloud disk for virtual machines, CLOUD_BSSD-universal SSD cloud disk for virtual machines.
    memory Double
    Memory, unit: GB.
    multiNodes Boolean
    Whether it is a multi-node architecture instance, the default value is false. When MultiNodes = true, the parameter MultiZones must be true.
    multiZones Boolean
    Whether to deploy across availability zones, the default value is false.
    name String
    Name of the SQL Server instance.
    period Double
    Purchase instance period, the default value is 1, which means one month. The value cannot exceed 48. Valid only when the 'instance_charge_type' parameter value is 'PREPAID'.
    projectId Double
    project ID.
    resourceTags List<SqlserverGeneralCloudInstanceResourceTag>
    A collection of tags bound to the new instance.
    securityGroupLists List<String>
    Security group list, fill in the security group ID in the form of sg-xxx.
    span Double
    Maintainable time window configuration, duration, unit: hour.
    sqlserverGeneralCloudInstanceId String
    ID of the resource.
    startTime String
    Maintainable time window configuration, daily maintainable start time.
    storage Double
    instance disk storage, unit: GB.
    subnetId String
    VPC subnet ID, in the form of subnet-bdoe83fa; SubnetId and VpcId need to be set at the same time or not set at the same time.
    tgwWanVport Double
    External port number.
    timeZone String
    System time zone, default: China Standard Time.
    vpcId String
    VPC network ID, in the form of vpc-dsp338hz; SubnetId and VpcId need to be set at the same time or not set at the same time.
    weeklies List<Double>
    Maintainable time window configuration, in weeks, indicates the days of the week that allow maintenance, 1-7 represent Monday to weekend respectively.
    zone String
    Instance AZ, such as ap-guangzhou-1 (Guangzhou Zone 1). Purchasable AZs for an instance can be obtained through the DescribeZones API.
    autoRenewFlag number
    Automatic renewal flag: 0-normal renewal 1-automatic renewal, the default is 1 automatic renewal. Valid only when purchasing a prepaid instance. Valid only when the 'instance_charge_type' parameter value is 'PREPAID'.
    collation string
    System character set collation, default: Chinese_PRC_CI_AS.
    cpu number
    Cpu, unit: CORE.
    dbVersion string
    sqlserver version, currently all supported versions are: 2008R2 (SQL Server 2008 R2 Enterprise), 2012SP3 (SQL Server 2012 Enterprise), 201202 (SQL Server 2012 Standard), 2014SP2 (SQL Server 2014 Enterprise), 201402 (SQL Server 2014 Standard), 2016SP1 (SQL Server 2016 Enterprise), 201602 (SQL Server 2016 Standard), 2017 (SQL Server 2017 Enterprise), 201702 (SQL Server 2017 Standard), 2019 (SQL Server 2019 Enterprise), 201902 (SQL Server 2019 Standard). Each region supports different versions for sale, and the version information that can be sold in each region can be pulled through the DescribeProductConfig interface. If left blank, the default version is 2008R2.
    diskEncryptFlag number
    Disk encryption identification, 0-not encrypted, 1-encrypted.
    dnsPodDomain string
    Internet address domain name.
    drZones string[]
    The standby node availability area is empty by default. When MultiNodes = true, the primary node and standby node availability areas cannot all be the same. The minimum number of standby availability areas set is 2, and the maximum number is no more than 5.
    haType string
    It has been deprecated from version 1.81.2. Upgrade the high-availability architecture of sqlserver, upgrade from mirror disaster recovery to always on cluster disaster recovery, only support 2017 and above and support always on high-availability instances, do not support downgrading to mirror disaster recovery, CLUSTER-upgrade to always on capacity Disaster, if not filled, the high-availability architecture will not be modified.

    Deprecated: Deprecated

    instanceChargeType string
    Payment mode, the value supports PREPAID (prepaid), POSTPAID (postpaid).
    machineType string
    The host disk type of the purchased instance, CLOUD_HSSD-enhanced SSD cloud disk for virtual machines, CLOUD_TSSD-extremely fast SSD cloud disk for virtual machines, CLOUD_BSSD-universal SSD cloud disk for virtual machines.
    memory number
    Memory, unit: GB.
    multiNodes boolean
    Whether it is a multi-node architecture instance, the default value is false. When MultiNodes = true, the parameter MultiZones must be true.
    multiZones boolean
    Whether to deploy across availability zones, the default value is false.
    name string
    Name of the SQL Server instance.
    period number
    Purchase instance period, the default value is 1, which means one month. The value cannot exceed 48. Valid only when the 'instance_charge_type' parameter value is 'PREPAID'.
    projectId number
    project ID.
    resourceTags SqlserverGeneralCloudInstanceResourceTag[]
    A collection of tags bound to the new instance.
    securityGroupLists string[]
    Security group list, fill in the security group ID in the form of sg-xxx.
    span number
    Maintainable time window configuration, duration, unit: hour.
    sqlserverGeneralCloudInstanceId string
    ID of the resource.
    startTime string
    Maintainable time window configuration, daily maintainable start time.
    storage number
    instance disk storage, unit: GB.
    subnetId string
    VPC subnet ID, in the form of subnet-bdoe83fa; SubnetId and VpcId need to be set at the same time or not set at the same time.
    tgwWanVport number
    External port number.
    timeZone string
    System time zone, default: China Standard Time.
    vpcId string
    VPC network ID, in the form of vpc-dsp338hz; SubnetId and VpcId need to be set at the same time or not set at the same time.
    weeklies number[]
    Maintainable time window configuration, in weeks, indicates the days of the week that allow maintenance, 1-7 represent Monday to weekend respectively.
    zone string
    Instance AZ, such as ap-guangzhou-1 (Guangzhou Zone 1). Purchasable AZs for an instance can be obtained through the DescribeZones API.
    auto_renew_flag float
    Automatic renewal flag: 0-normal renewal 1-automatic renewal, the default is 1 automatic renewal. Valid only when purchasing a prepaid instance. Valid only when the 'instance_charge_type' parameter value is 'PREPAID'.
    collation str
    System character set collation, default: Chinese_PRC_CI_AS.
    cpu float
    Cpu, unit: CORE.
    db_version str
    sqlserver version, currently all supported versions are: 2008R2 (SQL Server 2008 R2 Enterprise), 2012SP3 (SQL Server 2012 Enterprise), 201202 (SQL Server 2012 Standard), 2014SP2 (SQL Server 2014 Enterprise), 201402 (SQL Server 2014 Standard), 2016SP1 (SQL Server 2016 Enterprise), 201602 (SQL Server 2016 Standard), 2017 (SQL Server 2017 Enterprise), 201702 (SQL Server 2017 Standard), 2019 (SQL Server 2019 Enterprise), 201902 (SQL Server 2019 Standard). Each region supports different versions for sale, and the version information that can be sold in each region can be pulled through the DescribeProductConfig interface. If left blank, the default version is 2008R2.
    disk_encrypt_flag float
    Disk encryption identification, 0-not encrypted, 1-encrypted.
    dns_pod_domain str
    Internet address domain name.
    dr_zones Sequence[str]
    The standby node availability area is empty by default. When MultiNodes = true, the primary node and standby node availability areas cannot all be the same. The minimum number of standby availability areas set is 2, and the maximum number is no more than 5.
    ha_type str
    It has been deprecated from version 1.81.2. Upgrade the high-availability architecture of sqlserver, upgrade from mirror disaster recovery to always on cluster disaster recovery, only support 2017 and above and support always on high-availability instances, do not support downgrading to mirror disaster recovery, CLUSTER-upgrade to always on capacity Disaster, if not filled, the high-availability architecture will not be modified.

    Deprecated: Deprecated

    instance_charge_type str
    Payment mode, the value supports PREPAID (prepaid), POSTPAID (postpaid).
    machine_type str
    The host disk type of the purchased instance, CLOUD_HSSD-enhanced SSD cloud disk for virtual machines, CLOUD_TSSD-extremely fast SSD cloud disk for virtual machines, CLOUD_BSSD-universal SSD cloud disk for virtual machines.
    memory float
    Memory, unit: GB.
    multi_nodes bool
    Whether it is a multi-node architecture instance, the default value is false. When MultiNodes = true, the parameter MultiZones must be true.
    multi_zones bool
    Whether to deploy across availability zones, the default value is false.
    name str
    Name of the SQL Server instance.
    period float
    Purchase instance period, the default value is 1, which means one month. The value cannot exceed 48. Valid only when the 'instance_charge_type' parameter value is 'PREPAID'.
    project_id float
    project ID.
    resource_tags Sequence[SqlserverGeneralCloudInstanceResourceTagArgs]
    A collection of tags bound to the new instance.
    security_group_lists Sequence[str]
    Security group list, fill in the security group ID in the form of sg-xxx.
    span float
    Maintainable time window configuration, duration, unit: hour.
    sqlserver_general_cloud_instance_id str
    ID of the resource.
    start_time str
    Maintainable time window configuration, daily maintainable start time.
    storage float
    instance disk storage, unit: GB.
    subnet_id str
    VPC subnet ID, in the form of subnet-bdoe83fa; SubnetId and VpcId need to be set at the same time or not set at the same time.
    tgw_wan_vport float
    External port number.
    time_zone str
    System time zone, default: China Standard Time.
    vpc_id str
    VPC network ID, in the form of vpc-dsp338hz; SubnetId and VpcId need to be set at the same time or not set at the same time.
    weeklies Sequence[float]
    Maintainable time window configuration, in weeks, indicates the days of the week that allow maintenance, 1-7 represent Monday to weekend respectively.
    zone str
    Instance AZ, such as ap-guangzhou-1 (Guangzhou Zone 1). Purchasable AZs for an instance can be obtained through the DescribeZones API.
    autoRenewFlag Number
    Automatic renewal flag: 0-normal renewal 1-automatic renewal, the default is 1 automatic renewal. Valid only when purchasing a prepaid instance. Valid only when the 'instance_charge_type' parameter value is 'PREPAID'.
    collation String
    System character set collation, default: Chinese_PRC_CI_AS.
    cpu Number
    Cpu, unit: CORE.
    dbVersion String
    sqlserver version, currently all supported versions are: 2008R2 (SQL Server 2008 R2 Enterprise), 2012SP3 (SQL Server 2012 Enterprise), 201202 (SQL Server 2012 Standard), 2014SP2 (SQL Server 2014 Enterprise), 201402 (SQL Server 2014 Standard), 2016SP1 (SQL Server 2016 Enterprise), 201602 (SQL Server 2016 Standard), 2017 (SQL Server 2017 Enterprise), 201702 (SQL Server 2017 Standard), 2019 (SQL Server 2019 Enterprise), 201902 (SQL Server 2019 Standard). Each region supports different versions for sale, and the version information that can be sold in each region can be pulled through the DescribeProductConfig interface. If left blank, the default version is 2008R2.
    diskEncryptFlag Number
    Disk encryption identification, 0-not encrypted, 1-encrypted.
    dnsPodDomain String
    Internet address domain name.
    drZones List<String>
    The standby node availability area is empty by default. When MultiNodes = true, the primary node and standby node availability areas cannot all be the same. The minimum number of standby availability areas set is 2, and the maximum number is no more than 5.
    haType String
    It has been deprecated from version 1.81.2. Upgrade the high-availability architecture of sqlserver, upgrade from mirror disaster recovery to always on cluster disaster recovery, only support 2017 and above and support always on high-availability instances, do not support downgrading to mirror disaster recovery, CLUSTER-upgrade to always on capacity Disaster, if not filled, the high-availability architecture will not be modified.

    Deprecated: Deprecated

    instanceChargeType String
    Payment mode, the value supports PREPAID (prepaid), POSTPAID (postpaid).
    machineType String
    The host disk type of the purchased instance, CLOUD_HSSD-enhanced SSD cloud disk for virtual machines, CLOUD_TSSD-extremely fast SSD cloud disk for virtual machines, CLOUD_BSSD-universal SSD cloud disk for virtual machines.
    memory Number
    Memory, unit: GB.
    multiNodes Boolean
    Whether it is a multi-node architecture instance, the default value is false. When MultiNodes = true, the parameter MultiZones must be true.
    multiZones Boolean
    Whether to deploy across availability zones, the default value is false.
    name String
    Name of the SQL Server instance.
    period Number
    Purchase instance period, the default value is 1, which means one month. The value cannot exceed 48. Valid only when the 'instance_charge_type' parameter value is 'PREPAID'.
    projectId Number
    project ID.
    resourceTags List<Property Map>
    A collection of tags bound to the new instance.
    securityGroupLists List<String>
    Security group list, fill in the security group ID in the form of sg-xxx.
    span Number
    Maintainable time window configuration, duration, unit: hour.
    sqlserverGeneralCloudInstanceId String
    ID of the resource.
    startTime String
    Maintainable time window configuration, daily maintainable start time.
    storage Number
    instance disk storage, unit: GB.
    subnetId String
    VPC subnet ID, in the form of subnet-bdoe83fa; SubnetId and VpcId need to be set at the same time or not set at the same time.
    tgwWanVport Number
    External port number.
    timeZone String
    System time zone, default: China Standard Time.
    vpcId String
    VPC network ID, in the form of vpc-dsp338hz; SubnetId and VpcId need to be set at the same time or not set at the same time.
    weeklies List<Number>
    Maintainable time window configuration, in weeks, indicates the days of the week that allow maintenance, 1-7 represent Monday to weekend respectively.
    zone String
    Instance AZ, such as ap-guangzhou-1 (Guangzhou Zone 1). Purchasable AZs for an instance can be obtained through the DescribeZones API.

    Supporting Types

    SqlserverGeneralCloudInstanceResourceTag, SqlserverGeneralCloudInstanceResourceTagArgs

    TagKey string
    tag key.
    TagValue string
    tag value.
    TagKey string
    tag key.
    TagValue string
    tag value.
    tagKey String
    tag key.
    tagValue String
    tag value.
    tagKey string
    tag key.
    tagValue string
    tag value.
    tag_key str
    tag key.
    tag_value str
    tag value.
    tagKey String
    tag key.
    tagValue String
    tag value.

    Import

    sqlserver general_cloud_instance can be imported using the id, e.g.

    $ pulumi import tencentcloud:index/sqlserverGeneralCloudInstance:SqlserverGeneralCloudInstance example mssql-i9ma6oy7

    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