如何确保使用Microsoft Sync Framework的同步成功？ [英] How to make sure synchronization using the Microsoft Sync Framework was successful?

问题描述

我正在使用 Microsoft Sync Framework 来同步表两个Microsoft SQL Server。我创建了一个测试应用程序，该应用程序每秒在远程服务器上的表中生成一行。利用Sync Framework的应用程序在本地服务器上运行。该测试应用程序在一整夜内在数据库中创建了约52000个条目。同步应用程序执行了对 SyncOrchestrator.Synchronize方法。当我通过在同步表和远程表上执行count语句来检查同步应用程序的结果时，结果是在同步表中缺少295行。我使用了 tablediff实用程序来确定丢失行的ID，然后使用这些ID查询跟踪表。在远程数据库上，跟踪表中每个缺少的ID都有一个条目，而在本地数据库上，在跟踪表中找不到丢失的行的ID。重新启动同步应用程序时，丢失的条目也不会更新。我以为Sync Framework会自动解决这些不一致问题，但不幸的是我似乎错了。

I am using the Microsoft Sync Framework to synchronize a table on two Microsoft SQL Servers. I have created a test application which generates one row per second in the table on the remote server. The application making use of the Sync Framework runs on the local server. The test application created about 52000 entries in the database over one night. The syncing application executed a call to the SyncOrchestrator.Synchronize Method every 15 seconds. When I checked the outcome of the synchronization application by executing a count statement on the synchronized table and the remote table, the result was that 295 rows were missing in the synchronized table. I used the tablediff Utility to determine the Ids of the missing rows and then queried the tracking table with those ids. On the remote database, there is an entry for every single missing id in the tracking table whereas on the local database the ids of the missing rows are nowhere to be found in the tracking table. When I restart the synchronization application, the missing entries don't get updated either. I thought the Sync Framework took care of these inconsistencies automatically but unfortunately I seem to be wrong.

是否可以使用任何内置方法来验证同步过程成功发生了吗？还有另一种验证数据一致性的方法吗？

Is there any built-in method I can use to verify that the synchronization process has taken place successfully? Is there another way of verifying data consistency?

推荐答案

在同时运行DML和同步时，更改枚举存在问题。如果有帮助，请查看此修补程序。

there's an issue with change enumeration when DMLs and synchronization are running concurrently. have a look at this hotfix if it helps.

这篇关于如何确保使用Microsoft Sync Framework的同步成功？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！