tencentcloud 1.81.189 published on Wednesday, Apr 30, 2025 by tencentcloudstack
tencentcloud.getSqlserverPublishSubscribes
Explore with Pulumi AI
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:
- 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_id
is a publish instance or a subscribe instance. wheninstance_id
is a publish instance, this field is filtered according to the subscribe instance ID; wheninstance_id
is 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_id
is a publish instance or a subscribe instance. wheninstance_id
is a publish instance, this field is filtered according to the intranet IP of the subscribe instance; wheninstance_id
is 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_id
is a publish instance or a subscribe instance. wheninstance_id
is a publish instance, this field is filtered according to the subscribe instance ID; wheninstance_id
is 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_id
is a publish instance or a subscribe instance. wheninstance_id
is a publish instance, this field is filtered according to the intranet IP of the subscribe instance; wheninstance_id
is 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_id
is a publish instance or a subscribe instance. wheninstance_id
is a publish instance, this field is filtered according to the subscribe instance ID; wheninstance_id
is 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_id
is a publish instance or a subscribe instance. wheninstance_id
is a publish instance, this field is filtered according to the intranet IP of the subscribe instance; wheninstance_id
is 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_id
is a publish instance or a subscribe instance. wheninstance_id
is a publish instance, this field is filtered according to the subscribe instance ID; wheninstance_id
is 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_id
is a publish instance or a subscribe instance. wheninstance_id
is a publish instance, this field is filtered according to the intranet IP of the subscribe instance; wheninstance_id
is 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_id
is a publish instance or a subscribe instance. wheninstance_id
is a publish instance, this field is filtered according to the subscribe instance ID; wheninstance_id
is 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_id
is a publish instance or a subscribe instance. wheninstance_id
is a publish instance, this field is filtered according to the intranet IP of the subscribe instance; wheninstance_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_ 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_id
is a publish instance or a subscribe instance. wheninstance_id
is a publish instance, this field is filtered according to the subscribe instance ID; wheninstance_id
is 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_id
is a publish instance or a subscribe instance. wheninstance_id
is a publish instance, this field is filtered according to the intranet IP of the subscribe instance; wheninstance_id
is 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
tencentcloud
Terraform Provider.
tencentcloud 1.81.189 published on Wednesday, Apr 30, 2025 by tencentcloudstack