1. Packages
  2. Tencentcloud Provider
  3. API Docs
  4. getSqlserverPublishSubscribes
tencentcloud 1.81.189 published on Wednesday, Apr 30, 2025 by tencentcloudstack

tencentcloud.getSqlserverPublishSubscribes

Explore with Pulumi AI

tencentcloud logo
tencentcloud 1.81.189 published on Wednesday, Apr 30, 2025 by tencentcloudstack

    Use this data source to query Publish Subscribe 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 examplePubSqlserverGeneralCloudInstance = new tencentcloud.SqlserverGeneralCloudInstance("examplePubSqlserverGeneralCloudInstance", {
        zone: zones.then(zones => zones.zones?.[4]?.name),
        memory: 4,
        storage: 100,
        cpu: 2,
        machineType: "CLOUD_HSSD",
        instanceChargeType: "POSTPAID",
        projectId: 0,
        subnetId: subnet.subnetId,
        vpcId: vpc.vpcId,
        dbVersion: "2008R2",
        securityGroupLists: [securityGroup.securityGroupId],
        weeklies: [
            1,
            2,
            3,
            5,
            6,
            7,
        ],
        startTime: "00:00",
        span: 6,
        resourceTags: [{
            tagKey: "test",
            tagValue: "test",
        }],
        collation: "Chinese_PRC_CI_AS",
        timeZone: "China Standard Time",
    });
    const exampleSubSqlserverGeneralCloudInstance = new tencentcloud.SqlserverGeneralCloudInstance("exampleSubSqlserverGeneralCloudInstance", {
        zone: zones.then(zones => zones.zones?.[4]?.name),
        memory: 4,
        storage: 100,
        cpu: 2,
        machineType: "CLOUD_HSSD",
        instanceChargeType: "POSTPAID",
        projectId: 0,
        subnetId: subnet.subnetId,
        vpcId: vpc.vpcId,
        dbVersion: "2008R2",
        securityGroupLists: [securityGroup.securityGroupId],
        weeklies: [
            1,
            2,
            3,
            5,
            6,
            7,
        ],
        startTime: "00:00",
        span: 6,
        resourceTags: [{
            tagKey: "test",
            tagValue: "test",
        }],
        collation: "Chinese_PRC_CI_AS",
        timeZone: "China Standard Time",
    });
    const examplePubSqlserverDb = new tencentcloud.SqlserverDb("examplePubSqlserverDb", {
        instanceId: examplePubSqlserverGeneralCloudInstance.sqlserverGeneralCloudInstanceId,
        charset: "Chinese_PRC_BIN",
        remark: "test-remark",
    });
    const exampleSubSqlserverDb = new tencentcloud.SqlserverDb("exampleSubSqlserverDb", {
        instanceId: exampleSubSqlserverGeneralCloudInstance.sqlserverGeneralCloudInstanceId,
        charset: "Chinese_PRC_BIN",
        remark: "test-remark",
    });
    const exampleSqlserverPublishSubscribe = new tencentcloud.SqlserverPublishSubscribe("exampleSqlserverPublishSubscribe", {
        publishInstanceId: examplePubSqlserverGeneralCloudInstance.sqlserverGeneralCloudInstanceId,
        subscribeInstanceId: exampleSubSqlserverGeneralCloudInstance.sqlserverGeneralCloudInstanceId,
        publishSubscribeName: "example",
        deleteSubscribeDb: false,
        databaseTuples: [{
            publishDatabase: examplePubSqlserverDb.name,
            subscribeDatabase: exampleSubSqlserverDb.name,
        }],
    });
    const exampleSqlserverPublishSubscribes = tencentcloud.getSqlserverPublishSubscribesOutput({
        instanceId: exampleSqlserverPublishSubscribe.publishInstanceId,
    });
    
    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_pub_sqlserver_general_cloud_instance = tencentcloud.SqlserverGeneralCloudInstance("examplePubSqlserverGeneralCloudInstance",
        zone=zones.zones[4].name,
        memory=4,
        storage=100,
        cpu=2,
        machine_type="CLOUD_HSSD",
        instance_charge_type="POSTPAID",
        project_id=0,
        subnet_id=subnet.subnet_id,
        vpc_id=vpc.vpc_id,
        db_version="2008R2",
        security_group_lists=[security_group.security_group_id],
        weeklies=[
            1,
            2,
            3,
            5,
            6,
            7,
        ],
        start_time="00:00",
        span=6,
        resource_tags=[{
            "tag_key": "test",
            "tag_value": "test",
        }],
        collation="Chinese_PRC_CI_AS",
        time_zone="China Standard Time")
    example_sub_sqlserver_general_cloud_instance = tencentcloud.SqlserverGeneralCloudInstance("exampleSubSqlserverGeneralCloudInstance",
        zone=zones.zones[4].name,
        memory=4,
        storage=100,
        cpu=2,
        machine_type="CLOUD_HSSD",
        instance_charge_type="POSTPAID",
        project_id=0,
        subnet_id=subnet.subnet_id,
        vpc_id=vpc.vpc_id,
        db_version="2008R2",
        security_group_lists=[security_group.security_group_id],
        weeklies=[
            1,
            2,
            3,
            5,
            6,
            7,
        ],
        start_time="00:00",
        span=6,
        resource_tags=[{
            "tag_key": "test",
            "tag_value": "test",
        }],
        collation="Chinese_PRC_CI_AS",
        time_zone="China Standard Time")
    example_pub_sqlserver_db = tencentcloud.SqlserverDb("examplePubSqlserverDb",
        instance_id=example_pub_sqlserver_general_cloud_instance.sqlserver_general_cloud_instance_id,
        charset="Chinese_PRC_BIN",
        remark="test-remark")
    example_sub_sqlserver_db = tencentcloud.SqlserverDb("exampleSubSqlserverDb",
        instance_id=example_sub_sqlserver_general_cloud_instance.sqlserver_general_cloud_instance_id,
        charset="Chinese_PRC_BIN",
        remark="test-remark")
    example_sqlserver_publish_subscribe = tencentcloud.SqlserverPublishSubscribe("exampleSqlserverPublishSubscribe",
        publish_instance_id=example_pub_sqlserver_general_cloud_instance.sqlserver_general_cloud_instance_id,
        subscribe_instance_id=example_sub_sqlserver_general_cloud_instance.sqlserver_general_cloud_instance_id,
        publish_subscribe_name="example",
        delete_subscribe_db=False,
        database_tuples=[{
            "publish_database": example_pub_sqlserver_db.name,
            "subscribe_database": example_sub_sqlserver_db.name,
        }])
    example_sqlserver_publish_subscribes = tencentcloud.get_sqlserver_publish_subscribes_output(instance_id=example_sqlserver_publish_subscribe.publish_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
    		}
    		examplePubSqlserverGeneralCloudInstance, err := tencentcloud.NewSqlserverGeneralCloudInstance(ctx, "examplePubSqlserverGeneralCloudInstance", &tencentcloud.SqlserverGeneralCloudInstanceArgs{
    			Zone:               pulumi.String(zones.Zones[4].Name),
    			Memory:             pulumi.Float64(4),
    			Storage:            pulumi.Float64(100),
    			Cpu:                pulumi.Float64(2),
    			MachineType:        pulumi.String("CLOUD_HSSD"),
    			InstanceChargeType: pulumi.String("POSTPAID"),
    			ProjectId:          pulumi.Float64(0),
    			SubnetId:           subnet.SubnetId,
    			VpcId:              vpc.VpcId,
    			DbVersion:          pulumi.String("2008R2"),
    			SecurityGroupLists: pulumi.StringArray{
    				securityGroup.SecurityGroupId,
    			},
    			Weeklies: pulumi.Float64Array{
    				pulumi.Float64(1),
    				pulumi.Float64(2),
    				pulumi.Float64(3),
    				pulumi.Float64(5),
    				pulumi.Float64(6),
    				pulumi.Float64(7),
    			},
    			StartTime: pulumi.String("00:00"),
    			Span:      pulumi.Float64(6),
    			ResourceTags: tencentcloud.SqlserverGeneralCloudInstanceResourceTagArray{
    				&tencentcloud.SqlserverGeneralCloudInstanceResourceTagArgs{
    					TagKey:   pulumi.String("test"),
    					TagValue: pulumi.String("test"),
    				},
    			},
    			Collation: pulumi.String("Chinese_PRC_CI_AS"),
    			TimeZone:  pulumi.String("China Standard Time"),
    		})
    		if err != nil {
    			return err
    		}
    		exampleSubSqlserverGeneralCloudInstance, err := tencentcloud.NewSqlserverGeneralCloudInstance(ctx, "exampleSubSqlserverGeneralCloudInstance", &tencentcloud.SqlserverGeneralCloudInstanceArgs{
    			Zone:               pulumi.String(zones.Zones[4].Name),
    			Memory:             pulumi.Float64(4),
    			Storage:            pulumi.Float64(100),
    			Cpu:                pulumi.Float64(2),
    			MachineType:        pulumi.String("CLOUD_HSSD"),
    			InstanceChargeType: pulumi.String("POSTPAID"),
    			ProjectId:          pulumi.Float64(0),
    			SubnetId:           subnet.SubnetId,
    			VpcId:              vpc.VpcId,
    			DbVersion:          pulumi.String("2008R2"),
    			SecurityGroupLists: pulumi.StringArray{
    				securityGroup.SecurityGroupId,
    			},
    			Weeklies: pulumi.Float64Array{
    				pulumi.Float64(1),
    				pulumi.Float64(2),
    				pulumi.Float64(3),
    				pulumi.Float64(5),
    				pulumi.Float64(6),
    				pulumi.Float64(7),
    			},
    			StartTime: pulumi.String("00:00"),
    			Span:      pulumi.Float64(6),
    			ResourceTags: tencentcloud.SqlserverGeneralCloudInstanceResourceTagArray{
    				&tencentcloud.SqlserverGeneralCloudInstanceResourceTagArgs{
    					TagKey:   pulumi.String("test"),
    					TagValue: pulumi.String("test"),
    				},
    			},
    			Collation: pulumi.String("Chinese_PRC_CI_AS"),
    			TimeZone:  pulumi.String("China Standard Time"),
    		})
    		if err != nil {
    			return err
    		}
    		examplePubSqlserverDb, err := tencentcloud.NewSqlserverDb(ctx, "examplePubSqlserverDb", &tencentcloud.SqlserverDbArgs{
    			InstanceId: examplePubSqlserverGeneralCloudInstance.SqlserverGeneralCloudInstanceId,
    			Charset:    pulumi.String("Chinese_PRC_BIN"),
    			Remark:     pulumi.String("test-remark"),
    		})
    		if err != nil {
    			return err
    		}
    		exampleSubSqlserverDb, err := tencentcloud.NewSqlserverDb(ctx, "exampleSubSqlserverDb", &tencentcloud.SqlserverDbArgs{
    			InstanceId: exampleSubSqlserverGeneralCloudInstance.SqlserverGeneralCloudInstanceId,
    			Charset:    pulumi.String("Chinese_PRC_BIN"),
    			Remark:     pulumi.String("test-remark"),
    		})
    		if err != nil {
    			return err
    		}
    		exampleSqlserverPublishSubscribe, err := tencentcloud.NewSqlserverPublishSubscribe(ctx, "exampleSqlserverPublishSubscribe", &tencentcloud.SqlserverPublishSubscribeArgs{
    			PublishInstanceId:    examplePubSqlserverGeneralCloudInstance.SqlserverGeneralCloudInstanceId,
    			SubscribeInstanceId:  exampleSubSqlserverGeneralCloudInstance.SqlserverGeneralCloudInstanceId,
    			PublishSubscribeName: pulumi.String("example"),
    			DeleteSubscribeDb:    pulumi.Bool(false),
    			DatabaseTuples: tencentcloud.SqlserverPublishSubscribeDatabaseTupleArray{
    				&tencentcloud.SqlserverPublishSubscribeDatabaseTupleArgs{
    					PublishDatabase:   examplePubSqlserverDb.Name,
    					SubscribeDatabase: exampleSubSqlserverDb.Name,
    				},
    			},
    		})
    		if err != nil {
    			return err
    		}
    		_ = tencentcloud.GetSqlserverPublishSubscribesOutput(ctx, tencentcloud.GetSqlserverPublishSubscribesOutputArgs{
    			InstanceId: exampleSqlserverPublishSubscribe.PublishInstanceId,
    		}, 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 examplePubSqlserverGeneralCloudInstance = new Tencentcloud.SqlserverGeneralCloudInstance("examplePubSqlserverGeneralCloudInstance", new()
        {
            Zone = zones.Apply(getAvailabilityZonesByProductResult => getAvailabilityZonesByProductResult.Zones[4]?.Name),
            Memory = 4,
            Storage = 100,
            Cpu = 2,
            MachineType = "CLOUD_HSSD",
            InstanceChargeType = "POSTPAID",
            ProjectId = 0,
            SubnetId = subnet.SubnetId,
            VpcId = vpc.VpcId,
            DbVersion = "2008R2",
            SecurityGroupLists = new[]
            {
                securityGroup.SecurityGroupId,
            },
            Weeklies = new[]
            {
                1,
                2,
                3,
                5,
                6,
                7,
            },
            StartTime = "00:00",
            Span = 6,
            ResourceTags = new[]
            {
                new Tencentcloud.Inputs.SqlserverGeneralCloudInstanceResourceTagArgs
                {
                    TagKey = "test",
                    TagValue = "test",
                },
            },
            Collation = "Chinese_PRC_CI_AS",
            TimeZone = "China Standard Time",
        });
    
        var exampleSubSqlserverGeneralCloudInstance = new Tencentcloud.SqlserverGeneralCloudInstance("exampleSubSqlserverGeneralCloudInstance", new()
        {
            Zone = zones.Apply(getAvailabilityZonesByProductResult => getAvailabilityZonesByProductResult.Zones[4]?.Name),
            Memory = 4,
            Storage = 100,
            Cpu = 2,
            MachineType = "CLOUD_HSSD",
            InstanceChargeType = "POSTPAID",
            ProjectId = 0,
            SubnetId = subnet.SubnetId,
            VpcId = vpc.VpcId,
            DbVersion = "2008R2",
            SecurityGroupLists = new[]
            {
                securityGroup.SecurityGroupId,
            },
            Weeklies = new[]
            {
                1,
                2,
                3,
                5,
                6,
                7,
            },
            StartTime = "00:00",
            Span = 6,
            ResourceTags = new[]
            {
                new Tencentcloud.Inputs.SqlserverGeneralCloudInstanceResourceTagArgs
                {
                    TagKey = "test",
                    TagValue = "test",
                },
            },
            Collation = "Chinese_PRC_CI_AS",
            TimeZone = "China Standard Time",
        });
    
        var examplePubSqlserverDb = new Tencentcloud.SqlserverDb("examplePubSqlserverDb", new()
        {
            InstanceId = examplePubSqlserverGeneralCloudInstance.SqlserverGeneralCloudInstanceId,
            Charset = "Chinese_PRC_BIN",
            Remark = "test-remark",
        });
    
        var exampleSubSqlserverDb = new Tencentcloud.SqlserverDb("exampleSubSqlserverDb", new()
        {
            InstanceId = exampleSubSqlserverGeneralCloudInstance.SqlserverGeneralCloudInstanceId,
            Charset = "Chinese_PRC_BIN",
            Remark = "test-remark",
        });
    
        var exampleSqlserverPublishSubscribe = new Tencentcloud.SqlserverPublishSubscribe("exampleSqlserverPublishSubscribe", new()
        {
            PublishInstanceId = examplePubSqlserverGeneralCloudInstance.SqlserverGeneralCloudInstanceId,
            SubscribeInstanceId = exampleSubSqlserverGeneralCloudInstance.SqlserverGeneralCloudInstanceId,
            PublishSubscribeName = "example",
            DeleteSubscribeDb = false,
            DatabaseTuples = new[]
            {
                new Tencentcloud.Inputs.SqlserverPublishSubscribeDatabaseTupleArgs
                {
                    PublishDatabase = examplePubSqlserverDb.Name,
                    SubscribeDatabase = exampleSubSqlserverDb.Name,
                },
            },
        });
    
        var exampleSqlserverPublishSubscribes = Tencentcloud.GetSqlserverPublishSubscribes.Invoke(new()
        {
            InstanceId = exampleSqlserverPublishSubscribe.PublishInstanceId,
        });
    
    });
    
    package generated_program;
    
    import com.pulumi.Context;
    import com.pulumi.Pulumi;
    import com.pulumi.core.Output;
    import com.pulumi.tencentcloud.TencentcloudFunctions;
    import com.pulumi.tencentcloud.inputs.GetAvailabilityZonesByProductArgs;
    import com.pulumi.tencentcloud.Vpc;
    import com.pulumi.tencentcloud.VpcArgs;
    import com.pulumi.tencentcloud.Subnet;
    import com.pulumi.tencentcloud.SubnetArgs;
    import com.pulumi.tencentcloud.SecurityGroup;
    import com.pulumi.tencentcloud.SecurityGroupArgs;
    import com.pulumi.tencentcloud.SqlserverGeneralCloudInstance;
    import com.pulumi.tencentcloud.SqlserverGeneralCloudInstanceArgs;
    import com.pulumi.tencentcloud.inputs.SqlserverGeneralCloudInstanceResourceTagArgs;
    import com.pulumi.tencentcloud.SqlserverDb;
    import com.pulumi.tencentcloud.SqlserverDbArgs;
    import com.pulumi.tencentcloud.SqlserverPublishSubscribe;
    import com.pulumi.tencentcloud.SqlserverPublishSubscribeArgs;
    import com.pulumi.tencentcloud.inputs.SqlserverPublishSubscribeDatabaseTupleArgs;
    import com.pulumi.tencentcloud.inputs.GetSqlserverPublishSubscribesArgs;
    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 examplePubSqlserverGeneralCloudInstance = new SqlserverGeneralCloudInstance("examplePubSqlserverGeneralCloudInstance", SqlserverGeneralCloudInstanceArgs.builder()
                .zone(zones.applyValue(getAvailabilityZonesByProductResult -> getAvailabilityZonesByProductResult.zones()[4].name()))
                .memory(4)
                .storage(100)
                .cpu(2)
                .machineType("CLOUD_HSSD")
                .instanceChargeType("POSTPAID")
                .projectId(0)
                .subnetId(subnet.subnetId())
                .vpcId(vpc.vpcId())
                .dbVersion("2008R2")
                .securityGroupLists(securityGroup.securityGroupId())
                .weeklies(            
                    1,
                    2,
                    3,
                    5,
                    6,
                    7)
                .startTime("00:00")
                .span(6)
                .resourceTags(SqlserverGeneralCloudInstanceResourceTagArgs.builder()
                    .tagKey("test")
                    .tagValue("test")
                    .build())
                .collation("Chinese_PRC_CI_AS")
                .timeZone("China Standard Time")
                .build());
    
            var exampleSubSqlserverGeneralCloudInstance = new SqlserverGeneralCloudInstance("exampleSubSqlserverGeneralCloudInstance", SqlserverGeneralCloudInstanceArgs.builder()
                .zone(zones.applyValue(getAvailabilityZonesByProductResult -> getAvailabilityZonesByProductResult.zones()[4].name()))
                .memory(4)
                .storage(100)
                .cpu(2)
                .machineType("CLOUD_HSSD")
                .instanceChargeType("POSTPAID")
                .projectId(0)
                .subnetId(subnet.subnetId())
                .vpcId(vpc.vpcId())
                .dbVersion("2008R2")
                .securityGroupLists(securityGroup.securityGroupId())
                .weeklies(            
                    1,
                    2,
                    3,
                    5,
                    6,
                    7)
                .startTime("00:00")
                .span(6)
                .resourceTags(SqlserverGeneralCloudInstanceResourceTagArgs.builder()
                    .tagKey("test")
                    .tagValue("test")
                    .build())
                .collation("Chinese_PRC_CI_AS")
                .timeZone("China Standard Time")
                .build());
    
            var examplePubSqlserverDb = new SqlserverDb("examplePubSqlserverDb", SqlserverDbArgs.builder()
                .instanceId(examplePubSqlserverGeneralCloudInstance.sqlserverGeneralCloudInstanceId())
                .charset("Chinese_PRC_BIN")
                .remark("test-remark")
                .build());
    
            var exampleSubSqlserverDb = new SqlserverDb("exampleSubSqlserverDb", SqlserverDbArgs.builder()
                .instanceId(exampleSubSqlserverGeneralCloudInstance.sqlserverGeneralCloudInstanceId())
                .charset("Chinese_PRC_BIN")
                .remark("test-remark")
                .build());
    
            var exampleSqlserverPublishSubscribe = new SqlserverPublishSubscribe("exampleSqlserverPublishSubscribe", SqlserverPublishSubscribeArgs.builder()
                .publishInstanceId(examplePubSqlserverGeneralCloudInstance.sqlserverGeneralCloudInstanceId())
                .subscribeInstanceId(exampleSubSqlserverGeneralCloudInstance.sqlserverGeneralCloudInstanceId())
                .publishSubscribeName("example")
                .deleteSubscribeDb(false)
                .databaseTuples(SqlserverPublishSubscribeDatabaseTupleArgs.builder()
                    .publishDatabase(examplePubSqlserverDb.name())
                    .subscribeDatabase(exampleSubSqlserverDb.name())
                    .build())
                .build());
    
            final var exampleSqlserverPublishSubscribes = TencentcloudFunctions.getSqlserverPublishSubscribes(GetSqlserverPublishSubscribesArgs.builder()
                .instanceId(exampleSqlserverPublishSubscribe.publishInstanceId())
                .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.
      examplePubSqlserverGeneralCloudInstance:
        type: tencentcloud:SqlserverGeneralCloudInstance
        properties:
          zone: ${zones.zones[4].name}
          memory: 4
          storage: 100
          cpu: 2
          machineType: CLOUD_HSSD
          instanceChargeType: POSTPAID
          projectId: 0
          subnetId: ${subnet.subnetId}
          vpcId: ${vpc.vpcId}
          dbVersion: 2008R2
          securityGroupLists:
            - ${securityGroup.securityGroupId}
          weeklies:
            - 1
            - 2
            - 3
            - 5
            - 6
            - 7
          startTime: 00:00
          span: 6
          resourceTags:
            - tagKey: test
              tagValue: test
          collation: Chinese_PRC_CI_AS
          timeZone: China Standard Time
      exampleSubSqlserverGeneralCloudInstance:
        type: tencentcloud:SqlserverGeneralCloudInstance
        properties:
          zone: ${zones.zones[4].name}
          memory: 4
          storage: 100
          cpu: 2
          machineType: CLOUD_HSSD
          instanceChargeType: POSTPAID
          projectId: 0
          subnetId: ${subnet.subnetId}
          vpcId: ${vpc.vpcId}
          dbVersion: 2008R2
          securityGroupLists:
            - ${securityGroup.securityGroupId}
          weeklies:
            - 1
            - 2
            - 3
            - 5
            - 6
            - 7
          startTime: 00:00
          span: 6
          resourceTags:
            - tagKey: test
              tagValue: test
          collation: Chinese_PRC_CI_AS
          timeZone: China Standard Time
      examplePubSqlserverDb:
        type: tencentcloud:SqlserverDb
        properties:
          instanceId: ${examplePubSqlserverGeneralCloudInstance.sqlserverGeneralCloudInstanceId}
          charset: Chinese_PRC_BIN
          remark: test-remark
      exampleSubSqlserverDb:
        type: tencentcloud:SqlserverDb
        properties:
          instanceId: ${exampleSubSqlserverGeneralCloudInstance.sqlserverGeneralCloudInstanceId}
          charset: Chinese_PRC_BIN
          remark: test-remark
      exampleSqlserverPublishSubscribe:
        type: tencentcloud:SqlserverPublishSubscribe
        properties:
          publishInstanceId: ${examplePubSqlserverGeneralCloudInstance.sqlserverGeneralCloudInstanceId}
          subscribeInstanceId: ${exampleSubSqlserverGeneralCloudInstance.sqlserverGeneralCloudInstanceId}
          publishSubscribeName: example
          deleteSubscribeDb: false
          databaseTuples:
            - publishDatabase: ${examplePubSqlserverDb.name}
              subscribeDatabase: ${exampleSubSqlserverDb.name}
    variables:
      exampleSqlserverPublishSubscribes:
        fn::invoke:
          function: tencentcloud:getSqlserverPublishSubscribes
          arguments:
            instanceId: ${exampleSqlserverPublishSubscribe.publishInstanceId}
      zones:
        fn::invoke:
          function: tencentcloud:getAvailabilityZonesByProduct
          arguments:
            product: sqlserver
    

    Using getSqlserverPublishSubscribes

    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 getSqlserverPublishSubscribes(args: GetSqlserverPublishSubscribesArgs, opts?: InvokeOptions): Promise<GetSqlserverPublishSubscribesResult>
    function getSqlserverPublishSubscribesOutput(args: GetSqlserverPublishSubscribesOutputArgs, opts?: InvokeOptions): Output<GetSqlserverPublishSubscribesResult>
    def get_sqlserver_publish_subscribes(id: Optional[str] = None,
                                         instance_id: Optional[str] = None,
                                         pub_or_sub_instance_id: Optional[str] = None,
                                         pub_or_sub_instance_ip: Optional[str] = None,
                                         publish_database: Optional[str] = None,
                                         publish_subscribe_id: Optional[float] = None,
                                         publish_subscribe_name: Optional[str] = None,
                                         result_output_file: Optional[str] = None,
                                         subscribe_database: Optional[str] = None,
                                         opts: Optional[InvokeOptions] = None) -> GetSqlserverPublishSubscribesResult
    def get_sqlserver_publish_subscribes_output(id: Optional[pulumi.Input[str]] = None,
                                         instance_id: Optional[pulumi.Input[str]] = None,
                                         pub_or_sub_instance_id: Optional[pulumi.Input[str]] = None,
                                         pub_or_sub_instance_ip: Optional[pulumi.Input[str]] = None,
                                         publish_database: Optional[pulumi.Input[str]] = None,
                                         publish_subscribe_id: Optional[pulumi.Input[float]] = None,
                                         publish_subscribe_name: Optional[pulumi.Input[str]] = None,
                                         result_output_file: Optional[pulumi.Input[str]] = None,
                                         subscribe_database: Optional[pulumi.Input[str]] = None,
                                         opts: Optional[InvokeOptions] = None) -> Output[GetSqlserverPublishSubscribesResult]
    func GetSqlserverPublishSubscribes(ctx *Context, args *GetSqlserverPublishSubscribesArgs, opts ...InvokeOption) (*GetSqlserverPublishSubscribesResult, error)
    func GetSqlserverPublishSubscribesOutput(ctx *Context, args *GetSqlserverPublishSubscribesOutputArgs, opts ...InvokeOption) GetSqlserverPublishSubscribesResultOutput

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

    public static class GetSqlserverPublishSubscribes 
    {
        public static Task<GetSqlserverPublishSubscribesResult> InvokeAsync(GetSqlserverPublishSubscribesArgs args, InvokeOptions? opts = null)
        public static Output<GetSqlserverPublishSubscribesResult> Invoke(GetSqlserverPublishSubscribesInvokeArgs args, InvokeOptions? opts = null)
    }
    public static CompletableFuture<GetSqlserverPublishSubscribesResult> getSqlserverPublishSubscribes(GetSqlserverPublishSubscribesArgs args, InvokeOptions options)
    public static Output<GetSqlserverPublishSubscribesResult> getSqlserverPublishSubscribes(GetSqlserverPublishSubscribesArgs args, InvokeOptions options)
    
    fn::invoke:
      function: tencentcloud:index/getSqlserverPublishSubscribes:getSqlserverPublishSubscribes
      arguments:
        # arguments dictionary

    The following arguments are supported:

    InstanceId string
    ID of the SQL Server instance.
    Id string
    PubOrSubInstanceId string
    The subscribe/publish instance ID. It is related to whether the instance_id is a publish instance or a subscribe instance. when instance_id is a publish instance, this field is filtered according to the subscribe instance ID; when instance_id is a subscribe instance, this field is filtering according to the publish instance ID.
    PubOrSubInstanceIp string
    The intranet IP of the subscribe/publish instance. It is related to whether the instance_id is a publish instance or a subscribe instance. when instance_id is a publish instance, this field is filtered according to the intranet IP of the subscribe instance; when instance_id is a subscribe instance, this field is based on the publish instance intranet IP filter.
    PublishDatabase string
    Name of publish database.
    PublishSubscribeId double
    The id of the Publish and Subscribe.
    PublishSubscribeName string
    The name of the Publish and Subscribe.
    ResultOutputFile string
    Used to store results.
    SubscribeDatabase string
    Name of subscribe database.
    InstanceId string
    ID of the SQL Server instance.
    Id string
    PubOrSubInstanceId string
    The subscribe/publish instance ID. It is related to whether the instance_id is a publish instance or a subscribe instance. when instance_id is a publish instance, this field is filtered according to the subscribe instance ID; when instance_id is a subscribe instance, this field is filtering according to the publish instance ID.
    PubOrSubInstanceIp string
    The intranet IP of the subscribe/publish instance. It is related to whether the instance_id is a publish instance or a subscribe instance. when instance_id is a publish instance, this field is filtered according to the intranet IP of the subscribe instance; when instance_id is a subscribe instance, this field is based on the publish instance intranet IP filter.
    PublishDatabase string
    Name of publish database.
    PublishSubscribeId float64
    The id of the Publish and Subscribe.
    PublishSubscribeName string
    The name of the Publish and Subscribe.
    ResultOutputFile string
    Used to store results.
    SubscribeDatabase string
    Name of subscribe database.
    instanceId String
    ID of the SQL Server instance.
    id String
    pubOrSubInstanceId String
    The subscribe/publish instance ID. It is related to whether the instance_id is a publish instance or a subscribe instance. when instance_id is a publish instance, this field is filtered according to the subscribe instance ID; when instance_id is a subscribe instance, this field is filtering according to the publish instance ID.
    pubOrSubInstanceIp String
    The intranet IP of the subscribe/publish instance. It is related to whether the instance_id is a publish instance or a subscribe instance. when instance_id is a publish instance, this field is filtered according to the intranet IP of the subscribe instance; when instance_id is a subscribe instance, this field is based on the publish instance intranet IP filter.
    publishDatabase String
    Name of publish database.
    publishSubscribeId Double
    The id of the Publish and Subscribe.
    publishSubscribeName String
    The name of the Publish and Subscribe.
    resultOutputFile String
    Used to store results.
    subscribeDatabase String
    Name of subscribe database.
    instanceId string
    ID of the SQL Server instance.
    id string
    pubOrSubInstanceId string
    The subscribe/publish instance ID. It is related to whether the instance_id is a publish instance or a subscribe instance. when instance_id is a publish instance, this field is filtered according to the subscribe instance ID; when instance_id is a subscribe instance, this field is filtering according to the publish instance ID.
    pubOrSubInstanceIp string
    The intranet IP of the subscribe/publish instance. It is related to whether the instance_id is a publish instance or a subscribe instance. when instance_id is a publish instance, this field is filtered according to the intranet IP of the subscribe instance; when instance_id is a subscribe instance, this field is based on the publish instance intranet IP filter.
    publishDatabase string
    Name of publish database.
    publishSubscribeId number
    The id of the Publish and Subscribe.
    publishSubscribeName string
    The name of the Publish and Subscribe.
    resultOutputFile string
    Used to store results.
    subscribeDatabase string
    Name of subscribe database.
    instance_id str
    ID of the SQL Server instance.
    id str
    pub_or_sub_instance_id str
    The subscribe/publish instance ID. It is related to whether the instance_id is a publish instance or a subscribe instance. when instance_id is a publish instance, this field is filtered according to the subscribe instance ID; when instance_id is a subscribe instance, this field is filtering according to the publish instance ID.
    pub_or_sub_instance_ip str
    The intranet IP of the subscribe/publish instance. It is related to whether the instance_id is a publish instance or a subscribe instance. when instance_id is a publish instance, this field is filtered according to the intranet IP of the subscribe instance; when instance_id is a subscribe instance, this field is based on the publish instance intranet IP filter.
    publish_database str
    Name of publish database.
    publish_subscribe_id float
    The id of the Publish and Subscribe.
    publish_subscribe_name str
    The name of the Publish and Subscribe.
    result_output_file str
    Used to store results.
    subscribe_database str
    Name of subscribe database.
    instanceId String
    ID of the SQL Server instance.
    id String
    pubOrSubInstanceId String
    The subscribe/publish instance ID. It is related to whether the instance_id is a publish instance or a subscribe instance. when instance_id is a publish instance, this field is filtered according to the subscribe instance ID; when instance_id is a subscribe instance, this field is filtering according to the publish instance ID.
    pubOrSubInstanceIp String
    The intranet IP of the subscribe/publish instance. It is related to whether the instance_id is a publish instance or a subscribe instance. when instance_id is a publish instance, this field is filtered according to the intranet IP of the subscribe instance; when instance_id is a subscribe instance, this field is based on the publish instance intranet IP filter.
    publishDatabase String
    Name of publish database.
    publishSubscribeId Number
    The id of the Publish and Subscribe.
    publishSubscribeName String
    The name of the Publish and Subscribe.
    resultOutputFile String
    Used to store results.
    subscribeDatabase String
    Name of subscribe database.

    getSqlserverPublishSubscribes Result

    The following output properties are available:

    Id string
    InstanceId string
    PublishSubscribeLists List<GetSqlserverPublishSubscribesPublishSubscribeList>
    Publish and subscribe list. Each element contains the following attributes.
    PubOrSubInstanceId string
    PubOrSubInstanceIp string
    PublishDatabase string
    Name of the publish SQL Server instance.
    PublishSubscribeId double
    The id of the Publish and Subscribe.
    PublishSubscribeName string
    The name of the Publish and Subscribe.
    ResultOutputFile string
    SubscribeDatabase string
    Name of the subscribe SQL Server instance.
    Id string
    InstanceId string
    PublishSubscribeLists []GetSqlserverPublishSubscribesPublishSubscribeList
    Publish and subscribe list. Each element contains the following attributes.
    PubOrSubInstanceId string
    PubOrSubInstanceIp string
    PublishDatabase string
    Name of the publish SQL Server instance.
    PublishSubscribeId float64
    The id of the Publish and Subscribe.
    PublishSubscribeName string
    The name of the Publish and Subscribe.
    ResultOutputFile string
    SubscribeDatabase string
    Name of the subscribe SQL Server instance.
    id String
    instanceId String
    publishSubscribeLists List<GetSqlserverPublishSubscribesPublishSubscribeList>
    Publish and subscribe list. Each element contains the following attributes.
    pubOrSubInstanceId String
    pubOrSubInstanceIp String
    publishDatabase String
    Name of the publish SQL Server instance.
    publishSubscribeId Double
    The id of the Publish and Subscribe.
    publishSubscribeName String
    The name of the Publish and Subscribe.
    resultOutputFile String
    subscribeDatabase String
    Name of the subscribe SQL Server instance.
    id string
    instanceId string
    publishSubscribeLists GetSqlserverPublishSubscribesPublishSubscribeList[]
    Publish and subscribe list. Each element contains the following attributes.
    pubOrSubInstanceId string
    pubOrSubInstanceIp string
    publishDatabase string
    Name of the publish SQL Server instance.
    publishSubscribeId number
    The id of the Publish and Subscribe.
    publishSubscribeName string
    The name of the Publish and Subscribe.
    resultOutputFile string
    subscribeDatabase string
    Name of the subscribe SQL Server instance.
    id str
    instance_id str
    publish_subscribe_lists Sequence[GetSqlserverPublishSubscribesPublishSubscribeList]
    Publish and subscribe list. Each element contains the following attributes.
    pub_or_sub_instance_id str
    pub_or_sub_instance_ip str
    publish_database str
    Name of the publish SQL Server instance.
    publish_subscribe_id float
    The id of the Publish and Subscribe.
    publish_subscribe_name str
    The name of the Publish and Subscribe.
    result_output_file str
    subscribe_database str
    Name of the subscribe SQL Server instance.
    id String
    instanceId String
    publishSubscribeLists List<Property Map>
    Publish and subscribe list. Each element contains the following attributes.
    pubOrSubInstanceId String
    pubOrSubInstanceIp String
    publishDatabase String
    Name of the publish SQL Server instance.
    publishSubscribeId Number
    The id of the Publish and Subscribe.
    publishSubscribeName String
    The name of the Publish and Subscribe.
    resultOutputFile String
    subscribeDatabase String
    Name of the subscribe SQL Server instance.

    Supporting Types

    GetSqlserverPublishSubscribesPublishSubscribeList

    DatabaseTuples List<GetSqlserverPublishSubscribesPublishSubscribeListDatabaseTuple>
    Database Publish and Publish relationship list.
    PublishInstanceId string
    ID of the SQL Server instance which publish.
    PublishInstanceIp string
    IP of the the SQL Server instance which publish.
    PublishInstanceName string
    Name of the SQL Server instance which publish.
    PublishSubscribeId double
    The id of the Publish and Subscribe.
    PublishSubscribeName string
    The name of the Publish and Subscribe.
    SubscribeInstanceId string
    ID of the SQL Server instance which subscribe.
    SubscribeInstanceIp string
    IP of the SQL Server instance which subscribe.
    SubscribeInstanceName string
    Name of the SQL Server instance which subscribe.
    DatabaseTuples []GetSqlserverPublishSubscribesPublishSubscribeListDatabaseTuple
    Database Publish and Publish relationship list.
    PublishInstanceId string
    ID of the SQL Server instance which publish.
    PublishInstanceIp string
    IP of the the SQL Server instance which publish.
    PublishInstanceName string
    Name of the SQL Server instance which publish.
    PublishSubscribeId float64
    The id of the Publish and Subscribe.
    PublishSubscribeName string
    The name of the Publish and Subscribe.
    SubscribeInstanceId string
    ID of the SQL Server instance which subscribe.
    SubscribeInstanceIp string
    IP of the SQL Server instance which subscribe.
    SubscribeInstanceName string
    Name of the SQL Server instance which subscribe.
    databaseTuples List<GetSqlserverPublishSubscribesPublishSubscribeListDatabaseTuple>
    Database Publish and Publish relationship list.
    publishInstanceId String
    ID of the SQL Server instance which publish.
    publishInstanceIp String
    IP of the the SQL Server instance which publish.
    publishInstanceName String
    Name of the SQL Server instance which publish.
    publishSubscribeId Double
    The id of the Publish and Subscribe.
    publishSubscribeName String
    The name of the Publish and Subscribe.
    subscribeInstanceId String
    ID of the SQL Server instance which subscribe.
    subscribeInstanceIp String
    IP of the SQL Server instance which subscribe.
    subscribeInstanceName String
    Name of the SQL Server instance which subscribe.
    databaseTuples GetSqlserverPublishSubscribesPublishSubscribeListDatabaseTuple[]
    Database Publish and Publish relationship list.
    publishInstanceId string
    ID of the SQL Server instance which publish.
    publishInstanceIp string
    IP of the the SQL Server instance which publish.
    publishInstanceName string
    Name of the SQL Server instance which publish.
    publishSubscribeId number
    The id of the Publish and Subscribe.
    publishSubscribeName string
    The name of the Publish and Subscribe.
    subscribeInstanceId string
    ID of the SQL Server instance which subscribe.
    subscribeInstanceIp string
    IP of the SQL Server instance which subscribe.
    subscribeInstanceName string
    Name of the SQL Server instance which subscribe.
    database_tuples Sequence[GetSqlserverPublishSubscribesPublishSubscribeListDatabaseTuple]
    Database Publish and Publish relationship list.
    publish_instance_id str
    ID of the SQL Server instance which publish.
    publish_instance_ip str
    IP of the the SQL Server instance which publish.
    publish_instance_name str
    Name of the SQL Server instance which publish.
    publish_subscribe_id float
    The id of the Publish and Subscribe.
    publish_subscribe_name str
    The name of the Publish and Subscribe.
    subscribe_instance_id str
    ID of the SQL Server instance which subscribe.
    subscribe_instance_ip str
    IP of the SQL Server instance which subscribe.
    subscribe_instance_name str
    Name of the SQL Server instance which subscribe.
    databaseTuples List<Property Map>
    Database Publish and Publish relationship list.
    publishInstanceId String
    ID of the SQL Server instance which publish.
    publishInstanceIp String
    IP of the the SQL Server instance which publish.
    publishInstanceName String
    Name of the SQL Server instance which publish.
    publishSubscribeId Number
    The id of the Publish and Subscribe.
    publishSubscribeName String
    The name of the Publish and Subscribe.
    subscribeInstanceId String
    ID of the SQL Server instance which subscribe.
    subscribeInstanceIp String
    IP of the SQL Server instance which subscribe.
    subscribeInstanceName String
    Name of the SQL Server instance which subscribe.

    GetSqlserverPublishSubscribesPublishSubscribeListDatabaseTuple

    LastSyncTime string
    Last sync time.
    PublishDatabase string
    Name of publish database.
    Status string
    Publish and subscribe status between databases, valid values are running, success, fail, unknow.
    SubscribeDatabase string
    Name of subscribe database.
    LastSyncTime string
    Last sync time.
    PublishDatabase string
    Name of publish database.
    Status string
    Publish and subscribe status between databases, valid values are running, success, fail, unknow.
    SubscribeDatabase string
    Name of subscribe database.
    lastSyncTime String
    Last sync time.
    publishDatabase String
    Name of publish database.
    status String
    Publish and subscribe status between databases, valid values are running, success, fail, unknow.
    subscribeDatabase String
    Name of subscribe database.
    lastSyncTime string
    Last sync time.
    publishDatabase string
    Name of publish database.
    status string
    Publish and subscribe status between databases, valid values are running, success, fail, unknow.
    subscribeDatabase string
    Name of subscribe database.
    last_sync_time str
    Last sync time.
    publish_database str
    Name of publish database.
    status str
    Publish and subscribe status between databases, valid values are running, success, fail, unknow.
    subscribe_database str
    Name of subscribe database.
    lastSyncTime String
    Last sync time.
    publishDatabase String
    Name of publish database.
    status String
    Publish and subscribe status between databases, valid values are running, success, fail, unknow.
    subscribeDatabase String
    Name of subscribe database.

    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