tencentcloud 1.82.34 published on Wednesday, Nov 5, 2025 by tencentcloudstack
tencentcloud.getSqlserverPublishSubscribes
Start a Neo task
Explain and create a tencentcloud.getSqlserverPublishSubscribes resource
tencentcloud 1.82.34 published on Wednesday, Nov 5, 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", {
name: "vpc-example",
cidrBlock: "10.0.0.0/16",
});
const subnet = new tencentcloud.Subnet("subnet", {
availabilityZone: zones.then(zones => zones.zones?.[4]?.name),
name: "subnet-example",
vpcId: vpc.vpcId,
cidrBlock: "10.0.0.0/16",
isMulticast: false,
});
const securityGroup = new tencentcloud.SecurityGroup("security_group", {
name: "sg-example",
description: "desc.",
});
const examplePub = new tencentcloud.SqlserverGeneralCloudInstance("example_pub", {
name: "tf-example-pub",
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 exampleSub = new tencentcloud.SqlserverGeneralCloudInstance("example_sub", {
name: "tf-example-sub",
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("example_pub", {
instanceId: examplePub.sqlserverGeneralCloudInstanceId,
name: "tf_example_db_pub",
charset: "Chinese_PRC_BIN",
remark: "test-remark",
});
const exampleSubSqlserverDb = new tencentcloud.SqlserverDb("example_sub", {
instanceId: exampleSub.sqlserverGeneralCloudInstanceId,
name: "tf_example_db_sub",
charset: "Chinese_PRC_BIN",
remark: "test-remark",
});
const exampleSqlserverPublishSubscribe = new tencentcloud.SqlserverPublishSubscribe("example", {
publishInstanceId: examplePub.sqlserverGeneralCloudInstanceId,
subscribeInstanceId: exampleSub.sqlserverGeneralCloudInstanceId,
publishSubscribeName: "example",
deleteSubscribeDb: false,
databaseTuples: [{
publishDatabase: examplePubSqlserverDb.name,
subscribeDatabase: exampleSubSqlserverDb.name,
}],
});
const example = 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",
name="vpc-example",
cidr_block="10.0.0.0/16")
subnet = tencentcloud.Subnet("subnet",
availability_zone=zones.zones[4].name,
name="subnet-example",
vpc_id=vpc.vpc_id,
cidr_block="10.0.0.0/16",
is_multicast=False)
security_group = tencentcloud.SecurityGroup("security_group",
name="sg-example",
description="desc.")
example_pub = tencentcloud.SqlserverGeneralCloudInstance("example_pub",
name="tf-example-pub",
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 = tencentcloud.SqlserverGeneralCloudInstance("example_sub",
name="tf-example-sub",
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("example_pub",
instance_id=example_pub.sqlserver_general_cloud_instance_id,
name="tf_example_db_pub",
charset="Chinese_PRC_BIN",
remark="test-remark")
example_sub_sqlserver_db = tencentcloud.SqlserverDb("example_sub",
instance_id=example_sub.sqlserver_general_cloud_instance_id,
name="tf_example_db_sub",
charset="Chinese_PRC_BIN",
remark="test-remark")
example_sqlserver_publish_subscribe = tencentcloud.SqlserverPublishSubscribe("example",
publish_instance_id=example_pub.sqlserver_general_cloud_instance_id,
subscribe_instance_id=example_sub.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 = 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{
Name: pulumi.String("vpc-example"),
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),
Name: pulumi.String("subnet-example"),
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, "security_group", &tencentcloud.SecurityGroupArgs{
Name: pulumi.String("sg-example"),
Description: pulumi.String("desc."),
})
if err != nil {
return err
}
examplePub, err := tencentcloud.NewSqlserverGeneralCloudInstance(ctx, "example_pub", &tencentcloud.SqlserverGeneralCloudInstanceArgs{
Name: pulumi.String("tf-example-pub"),
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
}
exampleSub, err := tencentcloud.NewSqlserverGeneralCloudInstance(ctx, "example_sub", &tencentcloud.SqlserverGeneralCloudInstanceArgs{
Name: pulumi.String("tf-example-sub"),
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, "example_pub", &tencentcloud.SqlserverDbArgs{
InstanceId: examplePub.SqlserverGeneralCloudInstanceId,
Name: pulumi.String("tf_example_db_pub"),
Charset: pulumi.String("Chinese_PRC_BIN"),
Remark: pulumi.String("test-remark"),
})
if err != nil {
return err
}
exampleSubSqlserverDb, err := tencentcloud.NewSqlserverDb(ctx, "example_sub", &tencentcloud.SqlserverDbArgs{
InstanceId: exampleSub.SqlserverGeneralCloudInstanceId,
Name: pulumi.String("tf_example_db_sub"),
Charset: pulumi.String("Chinese_PRC_BIN"),
Remark: pulumi.String("test-remark"),
})
if err != nil {
return err
}
exampleSqlserverPublishSubscribe, err := tencentcloud.NewSqlserverPublishSubscribe(ctx, "example", &tencentcloud.SqlserverPublishSubscribeArgs{
PublishInstanceId: examplePub.SqlserverGeneralCloudInstanceId,
SubscribeInstanceId: exampleSub.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()
{
Name = "vpc-example",
CidrBlock = "10.0.0.0/16",
});
var subnet = new Tencentcloud.Subnet("subnet", new()
{
AvailabilityZone = zones.Apply(getAvailabilityZonesByProductResult => getAvailabilityZonesByProductResult.Zones[4]?.Name),
Name = "subnet-example",
VpcId = vpc.VpcId,
CidrBlock = "10.0.0.0/16",
IsMulticast = false,
});
var securityGroup = new Tencentcloud.SecurityGroup("security_group", new()
{
Name = "sg-example",
Description = "desc.",
});
var examplePub = new Tencentcloud.SqlserverGeneralCloudInstance("example_pub", new()
{
Name = "tf-example-pub",
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 exampleSub = new Tencentcloud.SqlserverGeneralCloudInstance("example_sub", new()
{
Name = "tf-example-sub",
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("example_pub", new()
{
InstanceId = examplePub.SqlserverGeneralCloudInstanceId,
Name = "tf_example_db_pub",
Charset = "Chinese_PRC_BIN",
Remark = "test-remark",
});
var exampleSubSqlserverDb = new Tencentcloud.SqlserverDb("example_sub", new()
{
InstanceId = exampleSub.SqlserverGeneralCloudInstanceId,
Name = "tf_example_db_sub",
Charset = "Chinese_PRC_BIN",
Remark = "test-remark",
});
var exampleSqlserverPublishSubscribe = new Tencentcloud.SqlserverPublishSubscribe("example", new()
{
PublishInstanceId = examplePub.SqlserverGeneralCloudInstanceId,
SubscribeInstanceId = exampleSub.SqlserverGeneralCloudInstanceId,
PublishSubscribeName = "example",
DeleteSubscribeDb = false,
DatabaseTuples = new[]
{
new Tencentcloud.Inputs.SqlserverPublishSubscribeDatabaseTupleArgs
{
PublishDatabase = examplePubSqlserverDb.Name,
SubscribeDatabase = exampleSubSqlserverDb.Name,
},
},
});
var example = 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()
.name("vpc-example")
.cidrBlock("10.0.0.0/16")
.build());
var subnet = new Subnet("subnet", SubnetArgs.builder()
.availabilityZone(zones.zones()[4].name())
.name("subnet-example")
.vpcId(vpc.vpcId())
.cidrBlock("10.0.0.0/16")
.isMulticast(false)
.build());
var securityGroup = new SecurityGroup("securityGroup", SecurityGroupArgs.builder()
.name("sg-example")
.description("desc.")
.build());
var examplePub = new SqlserverGeneralCloudInstance("examplePub", SqlserverGeneralCloudInstanceArgs.builder()
.name("tf-example-pub")
.zone(zones.zones()[4].name())
.memory(4.0)
.storage(100.0)
.cpu(2.0)
.machineType("CLOUD_HSSD")
.instanceChargeType("POSTPAID")
.projectId(0.0)
.subnetId(subnet.subnetId())
.vpcId(vpc.vpcId())
.dbVersion("2008R2")
.securityGroupLists(securityGroup.securityGroupId())
.weeklies(
1.0,
2.0,
3.0,
5.0,
6.0,
7.0)
.startTime("00:00")
.span(6.0)
.resourceTags(SqlserverGeneralCloudInstanceResourceTagArgs.builder()
.tagKey("test")
.tagValue("test")
.build())
.collation("Chinese_PRC_CI_AS")
.timeZone("China Standard Time")
.build());
var exampleSub = new SqlserverGeneralCloudInstance("exampleSub", SqlserverGeneralCloudInstanceArgs.builder()
.name("tf-example-sub")
.zone(zones.zones()[4].name())
.memory(4.0)
.storage(100.0)
.cpu(2.0)
.machineType("CLOUD_HSSD")
.instanceChargeType("POSTPAID")
.projectId(0.0)
.subnetId(subnet.subnetId())
.vpcId(vpc.vpcId())
.dbVersion("2008R2")
.securityGroupLists(securityGroup.securityGroupId())
.weeklies(
1.0,
2.0,
3.0,
5.0,
6.0,
7.0)
.startTime("00:00")
.span(6.0)
.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(examplePub.sqlserverGeneralCloudInstanceId())
.name("tf_example_db_pub")
.charset("Chinese_PRC_BIN")
.remark("test-remark")
.build());
var exampleSubSqlserverDb = new SqlserverDb("exampleSubSqlserverDb", SqlserverDbArgs.builder()
.instanceId(exampleSub.sqlserverGeneralCloudInstanceId())
.name("tf_example_db_sub")
.charset("Chinese_PRC_BIN")
.remark("test-remark")
.build());
var exampleSqlserverPublishSubscribe = new SqlserverPublishSubscribe("exampleSqlserverPublishSubscribe", SqlserverPublishSubscribeArgs.builder()
.publishInstanceId(examplePub.sqlserverGeneralCloudInstanceId())
.subscribeInstanceId(exampleSub.sqlserverGeneralCloudInstanceId())
.publishSubscribeName("example")
.deleteSubscribeDb(false)
.databaseTuples(SqlserverPublishSubscribeDatabaseTupleArgs.builder()
.publishDatabase(examplePubSqlserverDb.name())
.subscribeDatabase(exampleSubSqlserverDb.name())
.build())
.build());
final var example = TencentcloudFunctions.getSqlserverPublishSubscribes(GetSqlserverPublishSubscribesArgs.builder()
.instanceId(exampleSqlserverPublishSubscribe.publishInstanceId())
.build());
}
}
resources:
vpc:
type: tencentcloud:Vpc
properties:
name: vpc-example
cidrBlock: 10.0.0.0/16
subnet:
type: tencentcloud:Subnet
properties:
availabilityZone: ${zones.zones[4].name}
name: subnet-example
vpcId: ${vpc.vpcId}
cidrBlock: 10.0.0.0/16
isMulticast: false
securityGroup:
type: tencentcloud:SecurityGroup
name: security_group
properties:
name: sg-example
description: desc.
examplePub:
type: tencentcloud:SqlserverGeneralCloudInstance
name: example_pub
properties:
name: tf-example-pub
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
exampleSub:
type: tencentcloud:SqlserverGeneralCloudInstance
name: example_sub
properties:
name: tf-example-sub
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
name: example_pub
properties:
instanceId: ${examplePub.sqlserverGeneralCloudInstanceId}
name: tf_example_db_pub
charset: Chinese_PRC_BIN
remark: test-remark
exampleSubSqlserverDb:
type: tencentcloud:SqlserverDb
name: example_sub
properties:
instanceId: ${exampleSub.sqlserverGeneralCloudInstanceId}
name: tf_example_db_sub
charset: Chinese_PRC_BIN
remark: test-remark
exampleSqlserverPublishSubscribe:
type: tencentcloud:SqlserverPublishSubscribe
name: example
properties:
publishInstanceId: ${examplePub.sqlserverGeneralCloudInstanceId}
subscribeInstanceId: ${exampleSub.sqlserverGeneralCloudInstanceId}
publishSubscribeName: example
deleteSubscribeDb: false
databaseTuples:
- publishDatabase: ${examplePubSqlserverDb.name}
subscribeDatabase: ${exampleSubSqlserverDb.name}
variables:
example:
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 dictionaryThe following arguments are supported:
- Instance
Id string - ID of the SQL Server instance.
- Id string
- Pub
Or stringSub Instance Id - The subscribe/publish instance ID. It is related to whether the
instance_idis a publish instance or a subscribe instance. wheninstance_idis a publish instance, this field is filtered according to the subscribe instance ID; wheninstance_idis a subscribe instance, this field is filtering according to the publish instance ID. - Pub
Or stringSub Instance Ip - The intranet IP of the subscribe/publish instance. It is related to whether the
instance_idis a publish instance or a subscribe instance. wheninstance_idis a publish instance, this field is filtered according to the intranet IP of the subscribe instance; wheninstance_idis a subscribe instance, this field is based on the publish instance intranet IP filter. - Publish
Database string - Name of publish database.
- Publish
Subscribe doubleId - The id of the Publish and Subscribe.
- Publish
Subscribe stringName - The name of the Publish and Subscribe.
- Result
Output stringFile - Used to store results.
- Subscribe
Database string - Name of subscribe database.
- Instance
Id string - ID of the SQL Server instance.
- Id string
- Pub
Or stringSub Instance Id - The subscribe/publish instance ID. It is related to whether the
instance_idis a publish instance or a subscribe instance. wheninstance_idis a publish instance, this field is filtered according to the subscribe instance ID; wheninstance_idis a subscribe instance, this field is filtering according to the publish instance ID. - Pub
Or stringSub Instance Ip - The intranet IP of the subscribe/publish instance. It is related to whether the
instance_idis a publish instance or a subscribe instance. wheninstance_idis a publish instance, this field is filtered according to the intranet IP of the subscribe instance; wheninstance_idis a subscribe instance, this field is based on the publish instance intranet IP filter. - Publish
Database string - Name of publish database.
- Publish
Subscribe float64Id - The id of the Publish and Subscribe.
- Publish
Subscribe stringName - The name of the Publish and Subscribe.
- Result
Output stringFile - Used to store results.
- Subscribe
Database string - Name of subscribe database.
- instance
Id String - ID of the SQL Server instance.
- id String
- pub
Or StringSub Instance Id - The subscribe/publish instance ID. It is related to whether the
instance_idis a publish instance or a subscribe instance. wheninstance_idis a publish instance, this field is filtered according to the subscribe instance ID; wheninstance_idis a subscribe instance, this field is filtering according to the publish instance ID. - pub
Or StringSub Instance Ip - The intranet IP of the subscribe/publish instance. It is related to whether the
instance_idis a publish instance or a subscribe instance. wheninstance_idis a publish instance, this field is filtered according to the intranet IP of the subscribe instance; wheninstance_idis a subscribe instance, this field is based on the publish instance intranet IP filter. - publish
Database String - Name of publish database.
- publish
Subscribe DoubleId - The id of the Publish and Subscribe.
- publish
Subscribe StringName - The name of the Publish and Subscribe.
- result
Output StringFile - Used to store results.
- subscribe
Database String - Name of subscribe database.
- instance
Id string - ID of the SQL Server instance.
- id string
- pub
Or stringSub Instance Id - The subscribe/publish instance ID. It is related to whether the
instance_idis a publish instance or a subscribe instance. wheninstance_idis a publish instance, this field is filtered according to the subscribe instance ID; wheninstance_idis a subscribe instance, this field is filtering according to the publish instance ID. - pub
Or stringSub Instance Ip - The intranet IP of the subscribe/publish instance. It is related to whether the
instance_idis a publish instance or a subscribe instance. wheninstance_idis a publish instance, this field is filtered according to the intranet IP of the subscribe instance; wheninstance_idis a subscribe instance, this field is based on the publish instance intranet IP filter. - publish
Database string - Name of publish database.
- publish
Subscribe numberId - The id of the Publish and Subscribe.
- publish
Subscribe stringName - The name of the Publish and Subscribe.
- result
Output stringFile - Used to store results.
- subscribe
Database string - Name of subscribe database.
- instance_
id str - ID of the SQL Server instance.
- id str
- pub_
or_ strsub_ instance_ id - The subscribe/publish instance ID. It is related to whether the
instance_idis a publish instance or a subscribe instance. wheninstance_idis a publish instance, this field is filtered according to the subscribe instance ID; wheninstance_idis a subscribe instance, this field is filtering according to the publish instance ID. - pub_
or_ strsub_ instance_ ip - The intranet IP of the subscribe/publish instance. It is related to whether the
instance_idis a publish instance or a subscribe instance. wheninstance_idis a publish instance, this field is filtered according to the intranet IP of the subscribe instance; wheninstance_idis a subscribe instance, this field is based on the publish instance intranet IP filter. - publish_
database str - Name of publish database.
- publish_
subscribe_ floatid - The id of the Publish and Subscribe.
- publish_
subscribe_ strname - The name of the Publish and Subscribe.
- result_
output_ strfile - Used to store results.
- subscribe_
database str - Name of subscribe database.
- instance
Id String - ID of the SQL Server instance.
- id String
- pub
Or StringSub Instance Id - The subscribe/publish instance ID. It is related to whether the
instance_idis a publish instance or a subscribe instance. wheninstance_idis a publish instance, this field is filtered according to the subscribe instance ID; wheninstance_idis a subscribe instance, this field is filtering according to the publish instance ID. - pub
Or StringSub Instance Ip - The intranet IP of the subscribe/publish instance. It is related to whether the
instance_idis a publish instance or a subscribe instance. wheninstance_idis a publish instance, this field is filtered according to the intranet IP of the subscribe instance; wheninstance_idis a subscribe instance, this field is based on the publish instance intranet IP filter. - publish
Database String - Name of publish database.
- publish
Subscribe NumberId - The id of the Publish and Subscribe.
- publish
Subscribe StringName - The name of the Publish and Subscribe.
- result
Output StringFile - Used to store results.
- subscribe
Database String - Name of subscribe database.
getSqlserverPublishSubscribes Result
The following output properties are available:
- Id string
- Instance
Id string - Publish
Subscribe List<GetLists Sqlserver Publish Subscribes Publish Subscribe List> - Publish and subscribe list. Each element contains the following attributes.
- Pub
Or stringSub Instance Id - Pub
Or stringSub Instance Ip - Publish
Database string - Name of the publish SQL Server instance.
- Publish
Subscribe doubleId - The id of the Publish and Subscribe.
- Publish
Subscribe stringName - The name of the Publish and Subscribe.
- Result
Output stringFile - Subscribe
Database string - Name of the subscribe SQL Server instance.
- Id string
- Instance
Id string - Publish
Subscribe []GetLists Sqlserver Publish Subscribes Publish Subscribe List - Publish and subscribe list. Each element contains the following attributes.
- Pub
Or stringSub Instance Id - Pub
Or stringSub Instance Ip - Publish
Database string - Name of the publish SQL Server instance.
- Publish
Subscribe float64Id - The id of the Publish and Subscribe.
- Publish
Subscribe stringName - The name of the Publish and Subscribe.
- Result
Output stringFile - Subscribe
Database string - Name of the subscribe SQL Server instance.
- id String
- instance
Id String - publish
Subscribe List<GetLists Sqlserver Publish Subscribes Publish Subscribe List> - Publish and subscribe list. Each element contains the following attributes.
- pub
Or StringSub Instance Id - pub
Or StringSub Instance Ip - publish
Database String - Name of the publish SQL Server instance.
- publish
Subscribe DoubleId - The id of the Publish and Subscribe.
- publish
Subscribe StringName - The name of the Publish and Subscribe.
- result
Output StringFile - subscribe
Database String - Name of the subscribe SQL Server instance.
- id string
- instance
Id string - publish
Subscribe GetLists Sqlserver Publish Subscribes Publish Subscribe List[] - Publish and subscribe list. Each element contains the following attributes.
- pub
Or stringSub Instance Id - pub
Or stringSub Instance Ip - publish
Database string - Name of the publish SQL Server instance.
- publish
Subscribe numberId - The id of the Publish and Subscribe.
- publish
Subscribe stringName - The name of the Publish and Subscribe.
- result
Output stringFile - subscribe
Database string - Name of the subscribe SQL Server instance.
- id str
- instance_
id str - publish_
subscribe_ Sequence[Getlists Sqlserver Publish Subscribes Publish Subscribe List] - Publish and subscribe list. Each element contains the following attributes.
- pub_
or_ strsub_ instance_ id - pub_
or_ strsub_ instance_ ip - publish_
database str - Name of the publish SQL Server instance.
- publish_
subscribe_ floatid - The id of the Publish and Subscribe.
- publish_
subscribe_ strname - The name of the Publish and Subscribe.
- result_
output_ strfile - subscribe_
database str - Name of the subscribe SQL Server instance.
- id String
- instance
Id String - publish
Subscribe List<Property Map>Lists - Publish and subscribe list. Each element contains the following attributes.
- pub
Or StringSub Instance Id - pub
Or StringSub Instance Ip - publish
Database String - Name of the publish SQL Server instance.
- publish
Subscribe NumberId - The id of the Publish and Subscribe.
- publish
Subscribe StringName - The name of the Publish and Subscribe.
- result
Output StringFile - subscribe
Database String - Name of the subscribe SQL Server instance.
Supporting Types
GetSqlserverPublishSubscribesPublishSubscribeList
- Database
Tuples List<GetSqlserver Publish Subscribes Publish Subscribe List Database Tuple> - Database Publish and Publish relationship list.
- Publish
Instance stringId - ID of the SQL Server instance which publish.
- Publish
Instance stringIp - IP of the the SQL Server instance which publish.
- Publish
Instance stringName - Name of the SQL Server instance which publish.
- Publish
Subscribe doubleId - The id of the Publish and Subscribe.
- Publish
Subscribe stringName - The name of the Publish and Subscribe.
- Subscribe
Instance stringId - ID of the SQL Server instance which subscribe.
- Subscribe
Instance stringIp - IP of the SQL Server instance which subscribe.
- Subscribe
Instance stringName - Name of the SQL Server instance which subscribe.
- Database
Tuples []GetSqlserver Publish Subscribes Publish Subscribe List Database Tuple - Database Publish and Publish relationship list.
- Publish
Instance stringId - ID of the SQL Server instance which publish.
- Publish
Instance stringIp - IP of the the SQL Server instance which publish.
- Publish
Instance stringName - Name of the SQL Server instance which publish.
- Publish
Subscribe float64Id - The id of the Publish and Subscribe.
- Publish
Subscribe stringName - The name of the Publish and Subscribe.
- Subscribe
Instance stringId - ID of the SQL Server instance which subscribe.
- Subscribe
Instance stringIp - IP of the SQL Server instance which subscribe.
- Subscribe
Instance stringName - Name of the SQL Server instance which subscribe.
- database
Tuples List<GetSqlserver Publish Subscribes Publish Subscribe List Database Tuple> - Database Publish and Publish relationship list.
- publish
Instance StringId - ID of the SQL Server instance which publish.
- publish
Instance StringIp - IP of the the SQL Server instance which publish.
- publish
Instance StringName - Name of the SQL Server instance which publish.
- publish
Subscribe DoubleId - The id of the Publish and Subscribe.
- publish
Subscribe StringName - The name of the Publish and Subscribe.
- subscribe
Instance StringId - ID of the SQL Server instance which subscribe.
- subscribe
Instance StringIp - IP of the SQL Server instance which subscribe.
- subscribe
Instance StringName - Name of the SQL Server instance which subscribe.
- database
Tuples GetSqlserver Publish Subscribes Publish Subscribe List Database Tuple[] - Database Publish and Publish relationship list.
- publish
Instance stringId - ID of the SQL Server instance which publish.
- publish
Instance stringIp - IP of the the SQL Server instance which publish.
- publish
Instance stringName - Name of the SQL Server instance which publish.
- publish
Subscribe numberId - The id of the Publish and Subscribe.
- publish
Subscribe stringName - The name of the Publish and Subscribe.
- subscribe
Instance stringId - ID of the SQL Server instance which subscribe.
- subscribe
Instance stringIp - IP of the SQL Server instance which subscribe.
- subscribe
Instance stringName - Name of the SQL Server instance which subscribe.
- database_
tuples Sequence[GetSqlserver Publish Subscribes Publish Subscribe List Database Tuple] - Database Publish and Publish relationship list.
- publish_
instance_ strid - ID of the SQL Server instance which publish.
- publish_
instance_ strip - IP of the the SQL Server instance which publish.
- publish_
instance_ strname - Name of the SQL Server instance which publish.
- publish_
subscribe_ floatid - The id of the Publish and Subscribe.
- publish_
subscribe_ strname - The name of the Publish and Subscribe.
- subscribe_
instance_ strid - ID of the SQL Server instance which subscribe.
- subscribe_
instance_ strip - IP of the SQL Server instance which subscribe.
- subscribe_
instance_ strname - Name of the SQL Server instance which subscribe.
- database
Tuples List<Property Map> - Database Publish and Publish relationship list.
- publish
Instance StringId - ID of the SQL Server instance which publish.
- publish
Instance StringIp - IP of the the SQL Server instance which publish.
- publish
Instance StringName - Name of the SQL Server instance which publish.
- publish
Subscribe NumberId - The id of the Publish and Subscribe.
- publish
Subscribe StringName - The name of the Publish and Subscribe.
- subscribe
Instance StringId - ID of the SQL Server instance which subscribe.
- subscribe
Instance StringIp - IP of the SQL Server instance which subscribe.
- subscribe
Instance StringName - Name of the SQL Server instance which subscribe.
GetSqlserverPublishSubscribesPublishSubscribeListDatabaseTuple
- Last
Sync stringTime - Last sync time.
- Publish
Database string - Name of publish database.
- Status string
- Publish and subscribe status between databases, valid values are
running,success,fail,unknow. - Subscribe
Database string - Name of subscribe database.
- Last
Sync stringTime - Last sync time.
- Publish
Database string - Name of publish database.
- Status string
- Publish and subscribe status between databases, valid values are
running,success,fail,unknow. - Subscribe
Database string - Name of subscribe database.
- last
Sync StringTime - Last sync time.
- publish
Database String - Name of publish database.
- status String
- Publish and subscribe status between databases, valid values are
running,success,fail,unknow. - subscribe
Database String - Name of subscribe database.
- last
Sync stringTime - Last sync time.
- publish
Database string - Name of publish database.
- status string
- Publish and subscribe status between databases, valid values are
running,success,fail,unknow. - subscribe
Database string - Name of subscribe database.
- last_
sync_ strtime - 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.
- last
Sync StringTime - Last sync time.
- publish
Database String - Name of publish database.
- status String
- Publish and subscribe status between databases, valid values are
running,success,fail,unknow. - subscribe
Database String - Name of subscribe database.
Package Details
- Repository
- tencentcloud tencentcloudstack/terraform-provider-tencentcloud
- License
- Notes
- This Pulumi package is based on the
tencentcloudTerraform Provider.
tencentcloud 1.82.34 published on Wednesday, Nov 5, 2025 by tencentcloudstack
