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

tencentcloud.SqlserverBasicInstance

Explore with Pulumi AI

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

    Provides a SQL Server instance resource to create basic database instances.

    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.SqlserverBasicInstance("example", {
    availabilityZone: zones.then(zones => zones.zones?.[4]?.name),
    chargeType: "POSTPAID_BY_HOUR",
    vpcId: vpc.vpcId,
    subnetId: subnet.subnetId,
    projectId: 0,
    memory: 4,
    storage: 100,
    cpu: 2,
    machineType: "CLOUD_PREMIUM",
    maintenanceWeekSets: [
        1,
        2,
        3,
    ],
    maintenanceStartTime: "09:00",
    maintenanceTimeSpan: 3,
    securityGroups: [securityGroup.securityGroupId],
    tags: {
        test: "test",
    },
});

    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.SqlserverBasicInstance("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=4,
    storage=100,
    cpu=2,
    machine_type="CLOUD_PREMIUM",
    maintenance_week_sets=[
        1,
        2,
        3,
    ],
    maintenance_start_time="09:00",
    maintenance_time_span=3,
    security_groups=[security_group.security_group_id],
    tags={
        "test": "test",
    })

    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.NewSqlserverBasicInstance(ctx, "example", &tencentcloud.SqlserverBasicInstanceArgs{
			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(4),
			Storage:          pulumi.Float64(100),
			Cpu:              pulumi.Float64(2),
			MachineType:      pulumi.String("CLOUD_PREMIUM"),
			MaintenanceWeekSets: pulumi.Float64Array{
				pulumi.Float64(1),
				pulumi.Float64(2),
				pulumi.Float64(3),
			},
			MaintenanceStartTime: pulumi.String("09:00"),
			MaintenanceTimeSpan:  pulumi.Float64(3),
			SecurityGroups: pulumi.StringArray{
				securityGroup.SecurityGroupId,
			},
			Tags: pulumi.StringMap{
				"test": pulumi.String("test"),
			},
		})
		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.SqlserverBasicInstance("example", new()
    {
        AvailabilityZone = zones.Apply(getAvailabilityZonesByProductResult => getAvailabilityZonesByProductResult.Zones[4]?.Name),
        ChargeType = "POSTPAID_BY_HOUR",
        VpcId = vpc.VpcId,
        SubnetId = subnet.SubnetId,
        ProjectId = 0,
        Memory = 4,
        Storage = 100,
        Cpu = 2,
        MachineType = "CLOUD_PREMIUM",
        MaintenanceWeekSets = new[]
        {
            1,
            2,
            3,
        },
        MaintenanceStartTime = "09:00",
        MaintenanceTimeSpan = 3,
        SecurityGroups = new[]
        {
            securityGroup.SecurityGroupId,
        },
        Tags = 
        {
            { "test", "test" },
        },
    });

});

    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.SqlserverBasicInstance;
import com.pulumi.tencentcloud.SqlserverBasicInstanceArgs;
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 SqlserverBasicInstance("example", SqlserverBasicInstanceArgs.builder()
            .availabilityZone(zones.applyValue(getAvailabilityZonesByProductResult -> getAvailabilityZonesByProductResult.zones()[4].name()))
            .chargeType("POSTPAID_BY_HOUR")
            .vpcId(vpc.vpcId())
            .subnetId(subnet.subnetId())
            .projectId(0)
            .memory(4)
            .storage(100)
            .cpu(2)
            .machineType("CLOUD_PREMIUM")
            .maintenanceWeekSets(            
                1,
                2,
                3)
            .maintenanceStartTime("09:00")
            .maintenanceTimeSpan(3)
            .securityGroups(securityGroup.securityGroupId())
            .tags(Map.of("test", "test"))
            .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:SqlserverBasicInstance
    properties:
      availabilityZone: ${zones.zones[4].name}
      chargeType: POSTPAID_BY_HOUR
      vpcId: ${vpc.vpcId}
      subnetId: ${subnet.subnetId}
      projectId: 0
      memory: 4
      storage: 100
      cpu: 2
      machineType: CLOUD_PREMIUM
      maintenanceWeekSets:
        - 1
        - 2
        - 3
      maintenanceStartTime: 09:00
      maintenanceTimeSpan: 3
      securityGroups:
        - ${securityGroup.securityGroupId}
      tags:
        test: test
variables:
  zones:
    fn::invoke:
      function: tencentcloud:getAvailabilityZonesByProduct
      arguments:
        product: sqlserver

    Create SqlserverBasicInstance Resource

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

    Constructor syntax

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

@overload
def SqlserverBasicInstance(resource_name: str,
                           opts: Optional[ResourceOptions] = None,
                           cpu: Optional[float] = None,
                           storage: Optional[float] = None,
                           memory: Optional[float] = None,
                           machine_type: Optional[str] = None,
                           maintenance_week_sets: Optional[Sequence[float]] = None,
                           period: Optional[float] = None,
                           engine_version: Optional[str] = None,
                           charge_type: Optional[str] = None,
                           maintenance_start_time: Optional[str] = None,
                           maintenance_time_span: Optional[float] = None,
                           auto_renew: Optional[float] = None,
                           availability_zone: Optional[str] = None,
                           name: Optional[str] = None,
                           collation: Optional[str] = None,
                           project_id: Optional[float] = None,
                           security_groups: Optional[Sequence[str]] = None,
                           sqlserver_basic_instance_id: Optional[str] = None,
                           auto_voucher: Optional[float] = None,
                           subnet_id: Optional[str] = None,
                           tags: Optional[Mapping[str, str]] = None,
                           voucher_ids: Optional[Sequence[str]] = None,
                           vpc_id: Optional[str] = None)
    func NewSqlserverBasicInstance(ctx *Context, name string, args SqlserverBasicInstanceArgs, opts ...ResourceOption) (*SqlserverBasicInstance, error)
    public SqlserverBasicInstance(string name, SqlserverBasicInstanceArgs args, CustomResourceOptions? opts = null)
    public SqlserverBasicInstance(String name, SqlserverBasicInstanceArgs args)
public SqlserverBasicInstance(String name, SqlserverBasicInstanceArgs args, CustomResourceOptions options)

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

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

    Cpu double
    The CPU number of the SQL Server basic instance.
    MachineType string
    The host type of the purchased instance, CLOUD_PREMIUM for virtual machine high-performance cloud disk, CLOUD_SSD for virtual machine SSD cloud disk, CLOUD_HSSD for virtual machine enhanced cloud disk, CLOUD_BSSD for virtual machine general purpose SSD cloud disk.
    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, the default is 1 automatic renewal. 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 basic instance. For now, only POSTPAID_BY_HOUR is valid.
    Collation string
    System character set sorting rule, default: Chinese_PRC_CI_AS.
    EngineVersion string
    Version of the SQL Server basic 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.
    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, [1,7] presents do weekly maintenance on every Monday and Sunday.
    Name string
    Name of the SQL Server basic instance.
    Period double
    Purchase instance period, the default value is 1, which means one month. The value does not exceed 48.
    ProjectId double
    Project ID, default value is 0.
    SecurityGroups List<string>
    Security group bound to the instance.
    SqlserverBasicInstanceId string
    ID of the resource.
    SubnetId string
    ID of subnet.
    Tags Dictionary<string, string>
    The tags of the SQL Server basic instance.
    VoucherIds List<string>
    An array of voucher IDs, currently only one can be used for a single order.
    VpcId string
    ID of VPC.
    Cpu float64
    The CPU number of the SQL Server basic instance.
    MachineType string
    The host type of the purchased instance, CLOUD_PREMIUM for virtual machine high-performance cloud disk, CLOUD_SSD for virtual machine SSD cloud disk, CLOUD_HSSD for virtual machine enhanced cloud disk, CLOUD_BSSD for virtual machine general purpose SSD cloud disk.
    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, the default is 1 automatic renewal. 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 basic instance. For now, only POSTPAID_BY_HOUR is valid.
    Collation string
    System character set sorting rule, default: Chinese_PRC_CI_AS.
    EngineVersion string
    Version of the SQL Server basic 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.
    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, [1,7] presents do weekly maintenance on every Monday and Sunday.
    Name string
    Name of the SQL Server basic instance.
    Period float64
    Purchase instance period, the default value is 1, which means one month. The value does not exceed 48.
    ProjectId float64
    Project ID, default value is 0.
    SecurityGroups []string
    Security group bound to the instance.
    SqlserverBasicInstanceId string
    ID of the resource.
    SubnetId string
    ID of subnet.
    Tags map[string]string
    The tags of the SQL Server basic instance.
    VoucherIds []string
    An array of voucher IDs, currently only one can be used for a single order.
    VpcId string
    ID of VPC.
    cpu Double
    The CPU number of the SQL Server basic instance.
    machineType String
    The host type of the purchased instance, CLOUD_PREMIUM for virtual machine high-performance cloud disk, CLOUD_SSD for virtual machine SSD cloud disk, CLOUD_HSSD for virtual machine enhanced cloud disk, CLOUD_BSSD for virtual machine general purpose SSD cloud disk.
    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, the default is 1 automatic renewal. 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 basic instance. For now, only POSTPAID_BY_HOUR is valid.
    collation String
    System character set sorting rule, default: Chinese_PRC_CI_AS.
    engineVersion String
    Version of the SQL Server basic 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.
    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, [1,7] presents do weekly maintenance on every Monday and Sunday.
    name String
    Name of the SQL Server basic instance.
    period Double
    Purchase instance period, the default value is 1, which means one month. The value does not exceed 48.
    projectId Double
    Project ID, default value is 0.
    securityGroups List<String>
    Security group bound to the instance.
    sqlserverBasicInstanceId String
    ID of the resource.
    subnetId String
    ID of subnet.
    tags Map<String,String>
    The tags of the SQL Server basic instance.
    voucherIds List<String>
    An array of voucher IDs, currently only one can be used for a single order.
    vpcId String
    ID of VPC.
    cpu number
    The CPU number of the SQL Server basic instance.
    machineType string
    The host type of the purchased instance, CLOUD_PREMIUM for virtual machine high-performance cloud disk, CLOUD_SSD for virtual machine SSD cloud disk, CLOUD_HSSD for virtual machine enhanced cloud disk, CLOUD_BSSD for virtual machine general purpose SSD cloud disk.
    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, the default is 1 automatic renewal. 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 basic instance. For now, only POSTPAID_BY_HOUR is valid.
    collation string
    System character set sorting rule, default: Chinese_PRC_CI_AS.
    engineVersion string
    Version of the SQL Server basic 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.
    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, [1,7] presents do weekly maintenance on every Monday and Sunday.
    name string
    Name of the SQL Server basic instance.
    period number
    Purchase instance period, the default value is 1, which means one month. The value does not exceed 48.
    projectId number
    Project ID, default value is 0.
    securityGroups string[]
    Security group bound to the instance.
    sqlserverBasicInstanceId string
    ID of the resource.
    subnetId string
    ID of subnet.
    tags {[key: string]: string}
    The tags of the SQL Server basic instance.
    voucherIds string[]
    An array of voucher IDs, currently only one can be used for a single order.
    vpcId string
    ID of VPC.
    cpu float
    The CPU number of the SQL Server basic instance.
    machine_type str
    The host type of the purchased instance, CLOUD_PREMIUM for virtual machine high-performance cloud disk, CLOUD_SSD for virtual machine SSD cloud disk, CLOUD_HSSD for virtual machine enhanced cloud disk, CLOUD_BSSD for virtual machine general purpose SSD cloud disk.
    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, the default is 1 automatic renewal. 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 basic instance. For now, only POSTPAID_BY_HOUR is valid.
    collation str
    System character set sorting rule, default: Chinese_PRC_CI_AS.
    engine_version str
    Version of the SQL Server basic 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.
    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, [1,7] presents do weekly maintenance on every Monday and Sunday.
    name str
    Name of the SQL Server basic instance.
    period float
    Purchase instance period, the default value is 1, which means one 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_basic_instance_id str
    ID of the resource.
    subnet_id str
    ID of subnet.
    tags Mapping[str, str]
    The tags of the SQL Server basic instance.
    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.
    cpu Number
    The CPU number of the SQL Server basic instance.
    machineType String
    The host type of the purchased instance, CLOUD_PREMIUM for virtual machine high-performance cloud disk, CLOUD_SSD for virtual machine SSD cloud disk, CLOUD_HSSD for virtual machine enhanced cloud disk, CLOUD_BSSD for virtual machine general purpose SSD cloud disk.
    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, the default is 1 automatic renewal. 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 basic instance. For now, only POSTPAID_BY_HOUR is valid.
    collation String
    System character set sorting rule, default: Chinese_PRC_CI_AS.
    engineVersion String
    Version of the SQL Server basic 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.
    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, [1,7] presents do weekly maintenance on every Monday and Sunday.
    name String
    Name of the SQL Server basic instance.
    period Number
    Purchase instance period, the default value is 1, which means one month. The value does not exceed 48.
    projectId Number
    Project ID, default value is 0.
    securityGroups List<String>
    Security group bound to the instance.
    sqlserverBasicInstanceId String
    ID of the resource.
    subnetId String
    ID of subnet.
    tags Map<String>
    The tags of the SQL Server basic instance.
    voucherIds List<String>
    An array of voucher IDs, currently only one can be used for a single order.
    vpcId String
    ID of VPC.

    Outputs

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

    CreateTime string
    Create time of the SQL Server basic instance.
    DnsPodDomain string
    Internet address domain name.
    Id string
    The provider-assigned unique ID for this managed resource.
    Status double
    Status of the SQL Server basic 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 basic instance.
    DnsPodDomain string
    Internet address domain name.
    Id string
    The provider-assigned unique ID for this managed resource.
    Status float64
    Status of the SQL Server basic 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 basic instance.
    dnsPodDomain String
    Internet address domain name.
    id String
    The provider-assigned unique ID for this managed resource.
    status Double
    Status of the SQL Server basic 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 basic instance.
    dnsPodDomain string
    Internet address domain name.
    id string
    The provider-assigned unique ID for this managed resource.
    status number
    Status of the SQL Server basic 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 basic instance.
    dns_pod_domain str
    Internet address domain name.
    id str
    The provider-assigned unique ID for this managed resource.
    status float
    Status of the SQL Server basic 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 basic instance.
    dnsPodDomain String
    Internet address domain name.
    id String
    The provider-assigned unique ID for this managed resource.
    status Number
    Status of the SQL Server basic 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 SqlserverBasicInstance Resource

    Get an existing SqlserverBasicInstance 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?: SqlserverBasicInstanceState, opts?: CustomResourceOptions): SqlserverBasicInstance
    @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,
        collation: Optional[str] = None,
        cpu: Optional[float] = None,
        create_time: Optional[str] = None,
        dns_pod_domain: Optional[str] = None,
        engine_version: Optional[str] = None,
        machine_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,
        name: Optional[str] = None,
        period: Optional[float] = None,
        project_id: Optional[float] = None,
        security_groups: Optional[Sequence[str]] = None,
        sqlserver_basic_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,
        vip: Optional[str] = None,
        voucher_ids: Optional[Sequence[str]] = None,
        vpc_id: Optional[str] = None,
        vport: Optional[float] = None) -> SqlserverBasicInstance
    func GetSqlserverBasicInstance(ctx *Context, name string, id IDInput, state *SqlserverBasicInstanceState, opts ...ResourceOption) (*SqlserverBasicInstance, error)
    public static SqlserverBasicInstance Get(string name, Input<string> id, SqlserverBasicInstanceState? state, CustomResourceOptions? opts = null)
    public static SqlserverBasicInstance get(String name, Output<String> id, SqlserverBasicInstanceState state, CustomResourceOptions options)
    resources:  _:    type: tencentcloud:SqlserverBasicInstance    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, the default is 1 automatic renewal. 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 basic instance. For now, only POSTPAID_BY_HOUR is valid.
    Collation string
    System character set sorting rule, default: Chinese_PRC_CI_AS.
    Cpu double
    The CPU number of the SQL Server basic instance.
    CreateTime string
    Create time of the SQL Server basic instance.
    DnsPodDomain string
    Internet address domain name.
    EngineVersion string
    Version of the SQL Server basic 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.
    MachineType string
    The host type of the purchased instance, CLOUD_PREMIUM for virtual machine high-performance cloud disk, CLOUD_SSD for virtual machine SSD cloud disk, CLOUD_HSSD for virtual machine enhanced cloud disk, CLOUD_BSSD for virtual machine general purpose SSD cloud disk.
    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, [1,7] presents do weekly maintenance on every Monday and Sunday.
    Memory double
    Memory size (in GB). Allowed value must be larger than memory that data source tencentcloud_sqlserver_specinfos provides.
    Name string
    Name of the SQL Server basic instance.
    Period double
    Purchase instance period, the default value is 1, which means one month. The value does not exceed 48.
    ProjectId double
    Project ID, default value is 0.
    SecurityGroups List<string>
    Security group bound to the instance.
    SqlserverBasicInstanceId string
    ID of the resource.
    Status double
    Status of the SQL Server basic 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 basic instance.
    TgwWanVport double
    External port number.
    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.
    AutoRenew float64
    Automatic renewal sign. 0 for normal renewal, 1 for automatic renewal, the default is 1 automatic renewal. 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 basic instance. For now, only POSTPAID_BY_HOUR is valid.
    Collation string
    System character set sorting rule, default: Chinese_PRC_CI_AS.
    Cpu float64
    The CPU number of the SQL Server basic instance.
    CreateTime string
    Create time of the SQL Server basic instance.
    DnsPodDomain string
    Internet address domain name.
    EngineVersion string
    Version of the SQL Server basic 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.
    MachineType string
    The host type of the purchased instance, CLOUD_PREMIUM for virtual machine high-performance cloud disk, CLOUD_SSD for virtual machine SSD cloud disk, CLOUD_HSSD for virtual machine enhanced cloud disk, CLOUD_BSSD for virtual machine general purpose SSD cloud disk.
    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, [1,7] presents do weekly maintenance on every Monday and Sunday.
    Memory float64
    Memory size (in GB). Allowed value must be larger than memory that data source tencentcloud_sqlserver_specinfos provides.
    Name string
    Name of the SQL Server basic instance.
    Period float64
    Purchase instance period, the default value is 1, which means one month. The value does not exceed 48.
    ProjectId float64
    Project ID, default value is 0.
    SecurityGroups []string
    Security group bound to the instance.
    SqlserverBasicInstanceId string
    ID of the resource.
    Status float64
    Status of the SQL Server basic 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 basic instance.
    TgwWanVport float64
    External port number.
    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.
    autoRenew Double
    Automatic renewal sign. 0 for normal renewal, 1 for automatic renewal, the default is 1 automatic renewal. 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 basic instance. For now, only POSTPAID_BY_HOUR is valid.
    collation String
    System character set sorting rule, default: Chinese_PRC_CI_AS.
    cpu Double
    The CPU number of the SQL Server basic instance.
    createTime String
    Create time of the SQL Server basic instance.
    dnsPodDomain String
    Internet address domain name.
    engineVersion String
    Version of the SQL Server basic 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.
    machineType String
    The host type of the purchased instance, CLOUD_PREMIUM for virtual machine high-performance cloud disk, CLOUD_SSD for virtual machine SSD cloud disk, CLOUD_HSSD for virtual machine enhanced cloud disk, CLOUD_BSSD for virtual machine general purpose SSD cloud disk.
    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, [1,7] presents do weekly maintenance on every Monday and Sunday.
    memory Double
    Memory size (in GB). Allowed value must be larger than memory that data source tencentcloud_sqlserver_specinfos provides.
    name String
    Name of the SQL Server basic instance.
    period Double
    Purchase instance period, the default value is 1, which means one month. The value does not exceed 48.
    projectId Double
    Project ID, default value is 0.
    securityGroups List<String>
    Security group bound to the instance.
    sqlserverBasicInstanceId String
    ID of the resource.
    status Double
    Status of the SQL Server basic 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 basic instance.
    tgwWanVport Double
    External port number.
    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.
    autoRenew number
    Automatic renewal sign. 0 for normal renewal, 1 for automatic renewal, the default is 1 automatic renewal. 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 basic instance. For now, only POSTPAID_BY_HOUR is valid.
    collation string
    System character set sorting rule, default: Chinese_PRC_CI_AS.
    cpu number
    The CPU number of the SQL Server basic instance.
    createTime string
    Create time of the SQL Server basic instance.
    dnsPodDomain string
    Internet address domain name.
    engineVersion string
    Version of the SQL Server basic 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.
    machineType string
    The host type of the purchased instance, CLOUD_PREMIUM for virtual machine high-performance cloud disk, CLOUD_SSD for virtual machine SSD cloud disk, CLOUD_HSSD for virtual machine enhanced cloud disk, CLOUD_BSSD for virtual machine general purpose SSD cloud disk.
    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, [1,7] presents do weekly maintenance on every Monday and Sunday.
    memory number
    Memory size (in GB). Allowed value must be larger than memory that data source tencentcloud_sqlserver_specinfos provides.
    name string
    Name of the SQL Server basic instance.
    period number
    Purchase instance period, the default value is 1, which means one month. The value does not exceed 48.
    projectId number
    Project ID, default value is 0.
    securityGroups string[]
    Security group bound to the instance.
    sqlserverBasicInstanceId string
    ID of the resource.
    status number
    Status of the SQL Server basic 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 basic instance.
    tgwWanVport number
    External port number.
    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.
    auto_renew float
    Automatic renewal sign. 0 for normal renewal, 1 for automatic renewal, the default is 1 automatic renewal. 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 basic instance. For now, only POSTPAID_BY_HOUR is valid.
    collation str
    System character set sorting rule, default: Chinese_PRC_CI_AS.
    cpu float
    The CPU number of the SQL Server basic instance.
    create_time str
    Create time of the SQL Server basic instance.
    dns_pod_domain str
    Internet address domain name.
    engine_version str
    Version of the SQL Server basic 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.
    machine_type str
    The host type of the purchased instance, CLOUD_PREMIUM for virtual machine high-performance cloud disk, CLOUD_SSD for virtual machine SSD cloud disk, CLOUD_HSSD for virtual machine enhanced cloud disk, CLOUD_BSSD for virtual machine general purpose SSD cloud disk.
    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, [1,7] presents do weekly maintenance on every Monday and Sunday.
    memory float
    Memory size (in GB). Allowed value must be larger than memory that data source tencentcloud_sqlserver_specinfos provides.
    name str
    Name of the SQL Server basic instance.
    period float
    Purchase instance period, the default value is 1, which means one 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_basic_instance_id str
    ID of the resource.
    status float
    Status of the SQL Server basic 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 basic instance.
    tgw_wan_vport float
    External port number.
    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.
    autoRenew Number
    Automatic renewal sign. 0 for normal renewal, 1 for automatic renewal, the default is 1 automatic renewal. 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 basic instance. For now, only POSTPAID_BY_HOUR is valid.
    collation String
    System character set sorting rule, default: Chinese_PRC_CI_AS.
    cpu Number
    The CPU number of the SQL Server basic instance.
    createTime String
    Create time of the SQL Server basic instance.
    dnsPodDomain String
    Internet address domain name.
    engineVersion String
    Version of the SQL Server basic 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.
    machineType String
    The host type of the purchased instance, CLOUD_PREMIUM for virtual machine high-performance cloud disk, CLOUD_SSD for virtual machine SSD cloud disk, CLOUD_HSSD for virtual machine enhanced cloud disk, CLOUD_BSSD for virtual machine general purpose SSD cloud disk.
    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, [1,7] presents do weekly maintenance on every Monday and Sunday.
    memory Number
    Memory size (in GB). Allowed value must be larger than memory that data source tencentcloud_sqlserver_specinfos provides.
    name String
    Name of the SQL Server basic instance.
    period Number
    Purchase instance period, the default value is 1, which means one month. The value does not exceed 48.
    projectId Number
    Project ID, default value is 0.
    securityGroups List<String>
    Security group bound to the instance.
    sqlserverBasicInstanceId String
    ID of the resource.
    status Number
    Status of the SQL Server basic 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 basic instance.
    tgwWanVport Number
    External port number.
    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.

    Import

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

    $ pulumi import tencentcloud:index/sqlserverBasicInstance:SqlserverBasicInstance 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