Docs Home Pulumi IaC Pulumi ESC Pulumi Insights Pulumi Cloud Packages Tutorials
  1. Packages
  2. Tencentcloud Provider
  3. API Docs
  4. getSqlserverDbs
tencentcloud 1.81.182 published on Monday, Apr 14, 2025 by tencentcloudstack
tencentcloudstack/terraform-provider-tencentcloud

tencentcloud.getSqlserverDbs

Explore with Pulumi AI

tencentcloud logo
tencentcloud 1.81.182 published on Monday, Apr 14, 2025 by tencentcloudstack
tencentcloudstack/terraform-provider-tencentcloud

    Use this data source to query DB resources for the specific SQL Server instance.

    Example Usage

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

const zones = tencentcloud.getAvailabilityZonesByProduct({
    product: "sqlserver",
});
const vpc = new tencentcloud.Vpc("vpc", {cidrBlock: "10.0.0.0/16"});
const subnet = new tencentcloud.Subnet("subnet", {
    availabilityZone: zones.then(zones => zones.zones?.[4]?.name),
    vpcId: vpc.vpcId,
    cidrBlock: "10.0.0.0/16",
    isMulticast: false,
});
const securityGroup = new tencentcloud.SecurityGroup("securityGroup", {description: "desc."});
const exampleSqlserverBasicInstance = new tencentcloud.SqlserverBasicInstance("exampleSqlserverBasicInstance", {
    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",
    },
});
const exampleSqlserverDb = new tencentcloud.SqlserverDb("exampleSqlserverDb", {
    instanceId: exampleSqlserverBasicInstance.sqlserverBasicInstanceId,
    charset: "Chinese_PRC_BIN",
    remark: "test-remark",
});
const exampleSqlserverDbs = tencentcloud.getSqlserverDbsOutput({
    instanceId: exampleSqlserverDb.instanceId,
});

    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_sqlserver_basic_instance = tencentcloud.SqlserverBasicInstance("exampleSqlserverBasicInstance",
    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",
    })
example_sqlserver_db = tencentcloud.SqlserverDb("exampleSqlserverDb",
    instance_id=example_sqlserver_basic_instance.sqlserver_basic_instance_id,
    charset="Chinese_PRC_BIN",
    remark="test-remark")
example_sqlserver_dbs = tencentcloud.get_sqlserver_dbs_output(instance_id=example_sqlserver_db.instance_id)

    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
		}
		exampleSqlserverBasicInstance, err := tencentcloud.NewSqlserverBasicInstance(ctx, "exampleSqlserverBasicInstance", &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
		}
		exampleSqlserverDb, err := tencentcloud.NewSqlserverDb(ctx, "exampleSqlserverDb", &tencentcloud.SqlserverDbArgs{
			InstanceId: exampleSqlserverBasicInstance.SqlserverBasicInstanceId,
			Charset:    pulumi.String("Chinese_PRC_BIN"),
			Remark:     pulumi.String("test-remark"),
		})
		if err != nil {
			return err
		}
		_ = tencentcloud.GetSqlserverDbsOutput(ctx, tencentcloud.GetSqlserverDbsOutputArgs{
			InstanceId: exampleSqlserverDb.InstanceId,
		}, nil)
		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 exampleSqlserverBasicInstance = new Tencentcloud.SqlserverBasicInstance("exampleSqlserverBasicInstance", 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" },
        },
    });

    var exampleSqlserverDb = new Tencentcloud.SqlserverDb("exampleSqlserverDb", new()
    {
        InstanceId = exampleSqlserverBasicInstance.SqlserverBasicInstanceId,
        Charset = "Chinese_PRC_BIN",
        Remark = "test-remark",
    });

    var exampleSqlserverDbs = Tencentcloud.GetSqlserverDbs.Invoke(new()
    {
        InstanceId = exampleSqlserverDb.InstanceId,
    });

});

    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 com.pulumi.tencentcloud.SqlserverDb;
import com.pulumi.tencentcloud.SqlserverDbArgs;
import com.pulumi.tencentcloud.inputs.GetSqlserverDbsArgs;
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 exampleSqlserverBasicInstance = new SqlserverBasicInstance("exampleSqlserverBasicInstance", 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());

        var exampleSqlserverDb = new SqlserverDb("exampleSqlserverDb", SqlserverDbArgs.builder()
            .instanceId(exampleSqlserverBasicInstance.sqlserverBasicInstanceId())
            .charset("Chinese_PRC_BIN")
            .remark("test-remark")
            .build());

        final var exampleSqlserverDbs = TencentcloudFunctions.getSqlserverDbs(GetSqlserverDbsArgs.builder()
            .instanceId(exampleSqlserverDb.instanceId())
            .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.
  exampleSqlserverBasicInstance:
    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
  exampleSqlserverDb:
    type: tencentcloud:SqlserverDb
    properties:
      instanceId: ${exampleSqlserverBasicInstance.sqlserverBasicInstanceId}
      charset: Chinese_PRC_BIN
      remark: test-remark
variables:
  exampleSqlserverDbs:
    fn::invoke:
      function: tencentcloud:getSqlserverDbs
      arguments:
        instanceId: ${exampleSqlserverDb.instanceId}
  zones:
    fn::invoke:
      function: tencentcloud:getAvailabilityZonesByProduct
      arguments:
        product: sqlserver

    Using getSqlserverDbs

    Two invocation forms are available. The direct form accepts plain arguments and either blocks until the result value is available, or returns a Promise-wrapped result. The output form accepts Input-wrapped arguments and returns an Output-wrapped result.

    function getSqlserverDbs(args: GetSqlserverDbsArgs, opts?: InvokeOptions): Promise<GetSqlserverDbsResult>
function getSqlserverDbsOutput(args: GetSqlserverDbsOutputArgs, opts?: InvokeOptions): Output<GetSqlserverDbsResult>
    def get_sqlserver_dbs(id: Optional[str] = None,
                      instance_id: Optional[str] = None,
                      result_output_file: Optional[str] = None,
                      opts: Optional[InvokeOptions] = None) -> GetSqlserverDbsResult
def get_sqlserver_dbs_output(id: Optional[pulumi.Input[str]] = None,
                      instance_id: Optional[pulumi.Input[str]] = None,
                      result_output_file: Optional[pulumi.Input[str]] = None,
                      opts: Optional[InvokeOptions] = None) -> Output[GetSqlserverDbsResult]
    func GetSqlserverDbs(ctx *Context, args *GetSqlserverDbsArgs, opts ...InvokeOption) (*GetSqlserverDbsResult, error)
func GetSqlserverDbsOutput(ctx *Context, args *GetSqlserverDbsOutputArgs, opts ...InvokeOption) GetSqlserverDbsResultOutput

    > Note: This function is named GetSqlserverDbs in the Go SDK.

    public static class GetSqlserverDbs 
{
    public static Task<GetSqlserverDbsResult> InvokeAsync(GetSqlserverDbsArgs args, InvokeOptions? opts = null)
    public static Output<GetSqlserverDbsResult> Invoke(GetSqlserverDbsInvokeArgs args, InvokeOptions? opts = null)
}
    public static CompletableFuture<GetSqlserverDbsResult> getSqlserverDbs(GetSqlserverDbsArgs args, InvokeOptions options)
public static Output<GetSqlserverDbsResult> getSqlserverDbs(GetSqlserverDbsArgs args, InvokeOptions options)

    fn::invoke:
  function: tencentcloud:index/getSqlserverDbs:getSqlserverDbs
  arguments:
    # arguments dictionary

    The following arguments are supported:

    InstanceId string
    SQL Server instance ID which DB belongs to.
    Id string
    ResultOutputFile string
    Used to store results.
    InstanceId string
    SQL Server instance ID which DB belongs to.
    Id string
    ResultOutputFile string
    Used to store results.
    instanceId String
    SQL Server instance ID which DB belongs to.
    id String
    resultOutputFile String
    Used to store results.
    instanceId string
    SQL Server instance ID which DB belongs to.
    id string
    resultOutputFile string
    Used to store results.
    instance_id str
    SQL Server instance ID which DB belongs to.
    id str
    result_output_file str
    Used to store results.
    instanceId String
    SQL Server instance ID which DB belongs to.
    id String
    resultOutputFile String
    Used to store results.

    getSqlserverDbs Result

    The following output properties are available:

    DbLists List<GetSqlserverDbsDbList>
    A list of dbs belong to the specific instance. Each element contains the following attributes:
    Id string
    InstanceId string
    SQL Server instance ID which DB belongs to.
    ResultOutputFile string
    DbLists []GetSqlserverDbsDbList
    A list of dbs belong to the specific instance. Each element contains the following attributes:
    Id string
    InstanceId string
    SQL Server instance ID which DB belongs to.
    ResultOutputFile string
    dbLists List<GetSqlserverDbsDbList>
    A list of dbs belong to the specific instance. Each element contains the following attributes:
    id String
    instanceId String
    SQL Server instance ID which DB belongs to.
    resultOutputFile String
    dbLists GetSqlserverDbsDbList[]
    A list of dbs belong to the specific instance. Each element contains the following attributes:
    id string
    instanceId string
    SQL Server instance ID which DB belongs to.
    resultOutputFile string
    db_lists Sequence[GetSqlserverDbsDbList]
    A list of dbs belong to the specific instance. Each element contains the following attributes:
    id str
    instance_id str
    SQL Server instance ID which DB belongs to.
    result_output_file str
    dbLists List<Property Map>
    A list of dbs belong to the specific instance. Each element contains the following attributes:
    id String
    instanceId String
    SQL Server instance ID which DB belongs to.
    resultOutputFile String

    Supporting Types

    GetSqlserverDbsDbList

    Charset string
    Character set DB uses, could be Chinese_PRC_CI_AS, Chinese_PRC_CS_AS, Chinese_PRC_BIN, Chinese_Taiwan_Stroke_CI_AS, SQL_Latin1_General_CP1_CI_AS, and SQL_Latin1_General_CP1_CS_AS.
    CreateTime string
    Database creation time.
    InstanceId string
    SQL Server instance ID which DB belongs to.
    Name string
    Name of DB.
    Remark string
    Remark of the DB.
    Status string
    Database status. Valid values are creating, running, modifying, dropping.
    Charset string
    Character set DB uses, could be Chinese_PRC_CI_AS, Chinese_PRC_CS_AS, Chinese_PRC_BIN, Chinese_Taiwan_Stroke_CI_AS, SQL_Latin1_General_CP1_CI_AS, and SQL_Latin1_General_CP1_CS_AS.
    CreateTime string
    Database creation time.
    InstanceId string
    SQL Server instance ID which DB belongs to.
    Name string
    Name of DB.
    Remark string
    Remark of the DB.
    Status string
    Database status. Valid values are creating, running, modifying, dropping.
    charset String
    Character set DB uses, could be Chinese_PRC_CI_AS, Chinese_PRC_CS_AS, Chinese_PRC_BIN, Chinese_Taiwan_Stroke_CI_AS, SQL_Latin1_General_CP1_CI_AS, and SQL_Latin1_General_CP1_CS_AS.
    createTime String
    Database creation time.
    instanceId String
    SQL Server instance ID which DB belongs to.
    name String
    Name of DB.
    remark String
    Remark of the DB.
    status String
    Database status. Valid values are creating, running, modifying, dropping.
    charset string
    Character set DB uses, could be Chinese_PRC_CI_AS, Chinese_PRC_CS_AS, Chinese_PRC_BIN, Chinese_Taiwan_Stroke_CI_AS, SQL_Latin1_General_CP1_CI_AS, and SQL_Latin1_General_CP1_CS_AS.
    createTime string
    Database creation time.
    instanceId string
    SQL Server instance ID which DB belongs to.
    name string
    Name of DB.
    remark string
    Remark of the DB.
    status string
    Database status. Valid values are creating, running, modifying, dropping.
    charset str
    Character set DB uses, could be Chinese_PRC_CI_AS, Chinese_PRC_CS_AS, Chinese_PRC_BIN, Chinese_Taiwan_Stroke_CI_AS, SQL_Latin1_General_CP1_CI_AS, and SQL_Latin1_General_CP1_CS_AS.
    create_time str
    Database creation time.
    instance_id str
    SQL Server instance ID which DB belongs to.
    name str
    Name of DB.
    remark str
    Remark of the DB.
    status str
    Database status. Valid values are creating, running, modifying, dropping.
    charset String
    Character set DB uses, could be Chinese_PRC_CI_AS, Chinese_PRC_CS_AS, Chinese_PRC_BIN, Chinese_Taiwan_Stroke_CI_AS, SQL_Latin1_General_CP1_CI_AS, and SQL_Latin1_General_CP1_CS_AS.
    createTime String
    Database creation time.
    instanceId String
    SQL Server instance ID which DB belongs to.
    name String
    Name of DB.
    remark String
    Remark of the DB.
    status String
    Database status. Valid values are creating, running, modifying, dropping.

    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.182 published on Monday, Apr 14, 2025 by tencentcloudstack
    tencentcloudstack/terraform-provider-tencentcloud