使用静态过滤器合并复制-不从订户数据库中删除吗? [英] Merge Replication with Static Filters - Does not Delete from the subscriber database?

问题描述

我有一个合并复制设置，我已经应用了静态过滤器，以便仅将特定行从发布者(表)发送给订阅者，说"X"，过滤器是其中名称以(开头的子查询，选择返回的子查询'T')".现在，在同步之后，将应用过滤器并同步行.例如:订户将有以下3行.

I have a merge replication setup, I have applied static filters so as to send only specific rows to the subscribers from a publisher (table) say 'X' the filter is " where Name Starts with ( Select sub-query which returns 'T') ". Now after sync the filters are applied and the rows are synced. E.g: The subscribers will have the following 3 rows.

• ID名称
• 1个汤姆
• 2老虎
• 3蒂姆

现在，我转到发布服务器并删除第3行.然后再次同步.删除操作不会传播到订阅服务器，订阅服务器仍显示第三行.我缺少什么设置?

Now i go to the Publisher and delete the row 3. And sync again. The deletion is not propagated to the subscriber, and the subscriber still shows the 3rd row. What setting am I missing ?

推荐答案

大家好发现了我自己的查询中的问题.它在文章 https://support.microsoft.com/en-us/kb中记录/324362 . 子查询不适用于合并复制.

Hello guys found found the problem to my own query. It is documented in the article https://support.microsoft.com/en-us/kb/324362 . Sub-Queries do not work in the expected fashion with merge replication.

这篇关于使用静态过滤器合并复制-不从订户数据库中删除吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！