多种SQL复制类型 [英] Multiple SQL replication types

问题描述

我们目前有两个利用合并复制的SQL数据库.我们想从一个数据库到另一个数据库建立一个单独的事务复制.这可能吗?如果是这样，我们是否需要与我们的分销商进行任何更改?

We currently have two SQL databases that are utilizing a merge replication. We would like to setup a separate transactional replication off one of the databases to a third database. Is this possible? If so, do we need to change anything with our distributor?

谢谢！

推荐答案

是可以的.分发服务器不需要任何更改.

Yes this is possible. Nothing needs to change with the Distributor.

但是，如果您有一个Merge节点从事务复制拓扑接收数据，则需要确保将Merge文章的属性 @published_in_tran_pub 设置为 true ，以确保合并触发器正确触发.听起来这不适用于您的情况，除非第三个数据库是合并发布者/订阅者.

However, if you ever have a Merge node receive data from a Transactional Replication topology then you will need to make sure the property @published_in_tran_pub for your Merge articles is set to true to ensure the Merge triggers fire properly. It sounds like this won't apply in your case unless the third database is a Merge publisher/subscriber.

这篇关于多种SQL复制类型的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！