locked
Issue with Synchronization RRS feed

  • Question

  • When i sync backs updates from my client DB to MS SQL Server 2008 db, some records are not updaing since there __SysChangeTxBsn value is NULL.

    Now i will explain my scenario.

    1. First i downloaded data from MS SQL Server 2008 db to my local CE db.
    2. I did updates for two records in the local CE database table than closed the application.
    3. Again i opened the application and updated two more records in the same table.
    4. Now i did the Synchronization, only last modified two records are updated.

    I checked the _SysChangeTxBsn column of the table, only last modified two rows are having some integer values. Old ones having NULL value.

    Is there any way to modify the previous rows _SysChangeTxBsn value.

    • Moved by Hengzhe Li Friday, April 22, 2011 2:01 AM (From:SyncFx - Microsoft Sync Framework Database Providers [ReadOnly])
    Monday, August 10, 2009 5:53 PM

All replies

  • Are you committing your transaction from step2? Are the updates being done via your app or via Visual Stuido/Sql Server Management studio?
    Maheshwar Jayaraman - WCF -- http://blogs.msdn.com/dotnetremoting
    Tuesday, August 11, 2009 7:08 PM
    Moderator