- You use Microsoft Sync Framework 2.1 to perform database synchronization between a Microsoft SQL Server source database and a destination database.
- A DML operation that changes the source database data and the data synchronization operation occur at the same time.
In this scenario, non-convergence may occur between the databases.
Snapshot transactions are internally used to determine the committed data changes. The changes that are identified are enumerated and sent to the destination database. In a short time frame, the change enumeration logic may incorrectly update the watermark to reflect all visible changes that are being processed and enumerated when the DML operation and the data synchronization occur concurrently. However, some concurrent data changes may be missed for enumeration and for propagation while the watermark is updated.
Note After you apply this hotfix, the enumeration logic correctly detects and marks only the changes that are visible, and then the changes are sent to the destination database to avoid non-convergence.
Cumulative updateThe hotfix for this issue was first released in Sync Framework 2.1 build 2.1.2503.00. For more information about how to obtain this hotfix package, click the following article number to view the article in the Microsoft Knowledge Base:
Raksta ID: 2530271. Pēdējo reizi pārskatīts: 2011. gada 18. apr.. Pārskatījums: 1