1. Packages
  2. Tencentcloud Provider
  3. API Docs
  4. getSqlserverDbs
tencentcloud 1.81.182 published on Monday, Apr 14, 2025 by tencentcloudstack

tencentcloud.getSqlserverDbs

Explore with Pulumi AI

tencentcloud 1.81.182 published on Monday, Apr 14, 2025 by tencentcloudstack

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,
});
Copy
import pulumi
import pulumi_tencentcloud as tencentcloud

zones = tencentcloud.get_availability_zones_by_product(product="sqlserver")
vpc = tencentcloud.Vpc("vpc", cidr_block="10.0.0.0/16")
subnet = tencentcloud.Subnet("subnet",
    availability_zone=zones.zones[4].name,
    vpc_id=vpc.vpc_id,
    cidr_block="10.0.0.0/16",
    is_multicast=False)
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)
Copy
package main

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

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		zones, err := tencentcloud.GetAvailabilityZonesByProduct(ctx, &tencentcloud.GetAvailabilityZonesByProductArgs{
			Product: "sqlserver",
		}, nil)
		if err != nil {
			return err
		}
		vpc, err := tencentcloud.NewVpc(ctx, "vpc", &tencentcloud.VpcArgs{
			CidrBlock: pulumi.String("10.0.0.0/16"),
		})
		if err != nil {
			return err
		}
		subnet, err := tencentcloud.NewSubnet(ctx, "subnet", &tencentcloud.SubnetArgs{
			AvailabilityZone: pulumi.String(zones.Zones[4].Name),
			VpcId:            vpc.VpcId,
			CidrBlock:        pulumi.String("10.0.0.0/16"),
			IsMulticast:      pulumi.Bool(false),
		})
		if err != nil {
			return err
		}
		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
	})
}
Copy
using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Tencentcloud = Pulumi.Tencentcloud;

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

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

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

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

});
Copy
package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.tencentcloud.TencentcloudFunctions;
import com.pulumi.tencentcloud.inputs.GetAvailabilityZonesByProductArgs;
import com.pulumi.tencentcloud.Vpc;
import com.pulumi.tencentcloud.VpcArgs;
import com.pulumi.tencentcloud.Subnet;
import com.pulumi.tencentcloud.SubnetArgs;
import com.pulumi.tencentcloud.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());

    }
}
Copy
resources:
  vpc:
    type: tencentcloud:Vpc
    properties:
      cidrBlock: 10.0.0.0/16
  subnet:
    type: tencentcloud:Subnet
    properties:
      availabilityZone: ${zones.zones[4].name}
      vpcId: ${vpc.vpcId}
      cidrBlock: 10.0.0.0/16
      isMulticast: false
  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
Copy

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>
Copy
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]
Copy
func GetSqlserverDbs(ctx *Context, args *GetSqlserverDbsArgs, opts ...InvokeOption) (*GetSqlserverDbsResult, error)
func GetSqlserverDbsOutput(ctx *Context, args *GetSqlserverDbsOutputArgs, opts ...InvokeOption) GetSqlserverDbsResultOutput
Copy

> 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)
}
Copy
public static CompletableFuture<GetSqlserverDbsResult> getSqlserverDbs(GetSqlserverDbsArgs args, InvokeOptions options)
public static Output<GetSqlserverDbsResult> getSqlserverDbs(GetSqlserverDbsArgs args, InvokeOptions options)
Copy
fn::invoke:
  function: tencentcloud:index/getSqlserverDbs:getSqlserverDbs
  arguments:
    # arguments dictionary
Copy

The following arguments are supported:

InstanceId This property is required. string
SQL Server instance ID which DB belongs to.
Id string
ResultOutputFile string
Used to store results.
InstanceId This property is required. string
SQL Server instance ID which DB belongs to.
Id string
ResultOutputFile string
Used to store results.
instanceId This property is required. String
SQL Server instance ID which DB belongs to.
id String
resultOutputFile String
Used to store results.
instanceId This property is required. string
SQL Server instance ID which DB belongs to.
id string
resultOutputFile string
Used to store results.
instance_id This property is required. str
SQL Server instance ID which DB belongs to.
id str
result_output_file str
Used to store results.
instanceId This property is required. 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 This property is required. 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 This property is required. string
Database creation time.
InstanceId This property is required. string
SQL Server instance ID which DB belongs to.
Name This property is required. string
Name of DB.
Remark This property is required. string
Remark of the DB.
Status This property is required. string
Database status. Valid values are creating, running, modifying, dropping.
Charset This property is required. 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 This property is required. string
Database creation time.
InstanceId This property is required. string
SQL Server instance ID which DB belongs to.
Name This property is required. string
Name of DB.
Remark This property is required. string
Remark of the DB.
Status This property is required. string
Database status. Valid values are creating, running, modifying, dropping.
charset This property is required. 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 This property is required. String
Database creation time.
instanceId This property is required. String
SQL Server instance ID which DB belongs to.
name This property is required. String
Name of DB.
remark This property is required. String
Remark of the DB.
status This property is required. String
Database status. Valid values are creating, running, modifying, dropping.
charset This property is required. 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 This property is required. string
Database creation time.
instanceId This property is required. string
SQL Server instance ID which DB belongs to.
name This property is required. string
Name of DB.
remark This property is required. string
Remark of the DB.
status This property is required. string
Database status. Valid values are creating, running, modifying, dropping.
charset This property is required. 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 This property is required. str
Database creation time.
instance_id This property is required. str
SQL Server instance ID which DB belongs to.
name This property is required. str
Name of DB.
remark This property is required. str
Remark of the DB.
status This property is required. str
Database status. Valid values are creating, running, modifying, dropping.
charset This property is required. 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 This property is required. String
Database creation time.
instanceId This property is required. String
SQL Server instance ID which DB belongs to.
name This property is required. String
Name of DB.
remark This property is required. String
Remark of the DB.
status This property is required. 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 1.81.182 published on Monday, Apr 14, 2025 by tencentcloudstack