过滤和重叠范围 [英] Filtered and Overlapping Scopes
问题描述
您好,
任何人都可以解释一下'为什么两个数据库不同步两个范围有一些共享数据?'。我在网站上找到了以下信息:
http://msdn.microsoft.com/ en-us / library / dd918682.aspx
Can anybody explain me 'Why two databases not syncronize two scopes that have some of the shared data?'. I found the following information on at the site : http://msdn.microsoft.com/en-us/library/dd918682.aspx
"
"
场景2:
-
范围1是
sales-WA
。此范围包括:产品
;
订单州= WA
;和order_details
,过滤器
州= WA
。
-
Scope 1 is
sales-WA
. This scope includes:products
;orders
, with a filter ofstate=WA
; andorder_details
, with a filter ofstate=WA
.
范围2是 sales-Northwest
。此范围包括:产品
;
订单
,过滤器州= WA或州= ID
;和
。
托运人
Scope 2 is sales-Northwest
. This scope includes: products
;
orders
, with a filter of state=WA OR state=ID
; and
shippers
.
在这种情况下,整个产品
表再次由两个范围共享。
orders
表位于两个范围内,并且过滤器重叠:两个范围共享满足过滤器的行
state = WA
。 托运人
和 order_details
表不在范围之间共享。
In this scenario, the entire products
table is again shared by both scopes. The
orders
table is in both scopes and the filters overlap: both scopes share the rows that satisfy the filter
state=WA
. The shippers
and order_details
tables are not shared between the scopes.
那里可以使用许多不同的方式来定义范围,但必须遵循以下原则:在同步拓扑中的一对数据库之间同步的任何数据只能属于一个范围。例如,在上面的场景2
中,数据库A和数据库B可以同步范围1;数据库A和数据库C可以同步范围2.
数据库A和数据库B也不能同步范围2,因为
和
产品订单
属于这两个范围的行。"
There are many different ways in which scopes can be defined, but the following principle must be followed: any data that is synchronized between a pair of databases in the synchronization topology can belong to only one scope. For example in Scenario 2
above, Database A and Database B could synchronize Scope 1; and Database A and Database C could synchronize Scope 2.
Database A and Database B cannot also synchronize Scope 2 because of the
products
and orders
rows that belong to both scopes."
我需要知道为什么会出现这种限制?
I need to know why this restriction should be?
为什么在首先发生范围同步的任何人都无法与其他数据库同步共享数据。然后将排除特定数据(共享)的其他范围的后续同步,因为该数据已经存在于目的地。
Why can't the shared data sync with the other database while anyone of the scope syncronization that happens first. And then subsequent syncs of the other scopes that particular data (shared) will be excluded as that data is already present at the destination.
请解释这个或任何链接背后的原因
Please explain me the reason behind this or any link will be appreciated.
在我的场景中,一些数据将在多个范围之间共享,这些范围需要在两个数据库中同步。
In my scenario some of the data is going to be shared between multiple scopes which needs to be syncronized in two databases.
-Ajinath
推荐答案
无法同步2个范围的原因对等体之间的重叠是因为它设置了一个循环,当scope2同步时,peer1在scope1中下载的更改将由peer1上载。这是
存储在数据库中的同步元数据的限制。我希望这能解释原因。
The reason why you cannot synchronize 2 scopes that overlap between peers is because it sets up a cycle where the changes downloaded by peer1 in scope1 will be uploaded by peer1 when scope2 is synchronized. This is a limitation of the sync metadata that is stored on the database. I hope this explains the reason.
这篇关于过滤和重叠范围的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!