Sync Framework似乎挂起了 [英] Sync Framework seems to hang

问题描述

  我正在使用MSF 2.0，并且我正在使用内置的SqlSyncProvider将服务器关系数据库（SQL Server Enterprise）与本地关系数据库（SQL Server EXPRESS）同步。当数据库是新的时，它会在几秒钟内同步。然后，在插入一些数据后，它似乎永远同步。我等了大约30分钟，什么也没发生。然后，我创建了一个新的数据库并开始再次工作......过了一会儿，它又停止了工作。令我担心的是，数据库中插入的数据非常少（约10个寄存器），因此我怀疑真正的问题是其他问题。 

提前致谢
Paola

Hi,
   I´m using MSF 2.0, and i´m synchronizing a server relational DB (SQL Server Enterprise) with a local relational DB (SQL Server EXPRESS) using the builtin SqlSyncProvider. When the database is new, it synchronizes in few seconds. Then, after inserting some data, it seems to synchronize forever. I waited for about 30 minutes and nothing happened. Then, i created a new DB and started to work again..and again, after a while, it stop working. The thing that worries me is that the amout of data inserted in the database is really small (about 10 registers) so i´m suspecting that the real problem is something else. 

Thanks in advance
Paola

我注意到的一件事是，当我在数据库中添加表关系时出现了这个问题。因此，同步过程在数据库没有关系时起作用，并在我添加它们时停止工作。我怀疑关系之间可能存在循环，导致同步器停止工作。可以吗？如果这是真的，有没有办法在MSF中支持这种关系？

One thing that i noted is that this problem appeared when i added table relations in the database. So, the synchronization process works when the database doesn´t have relations, and stop working when i add them. I suspect that there can be a loop between the relations that can cause the synchronizer to stop working. Can it be the case? if this is true, is there a way to support this kind of relations in MSF?

推荐答案

表之间的关联（即RI-s）应该得到支持同步服务。你能不能试着解决这个案子？这种情况涉及多少个表？架构有多复杂？在进行更改或应用更改时，它似乎挂起了吗？

感谢
yunwen

the relateionships among tables ( i.e. RI-s ) should be supported by the sync services. could you please try to nail down this case a bit ? how many tables are involved in this case ? how complex the schema is ? does it seem hang when getting changes or applying changes ?

thanks
yunwen

这篇关于Sync Framework似乎挂起了的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！