locked
Tracking table in Microsoft Sync Framework RRS feed

  • Question

  • Hi,

    My Sync Framework creates Sync.TableName_tracking table on Sql Server 2008.Can I get any significance of this table?

    A particular set of columns are created like  update_scope_local_id,create_scope_local_id and sync_row_is_tombstone.

    May I know the significance of these columns.

    Regards,

    Sachin K


    Wednesday, June 20, 2012 10:55 AM

All replies

  • sync framework uses that to record changes. without it, sync framework wont be able to determine what has changed since the last sync.
    Wednesday, June 20, 2012 11:01 AM
  • Hi June,

    Can we know the role of each Column?

    • Proposed as answer by Motahare Monday, September 21, 2020 9:57 AM
    • Unproposed as answer by Motahare Monday, September 21, 2020 9:58 AM
    Wednesday, June 20, 2012 11:06 AM
  • i wont advise meddling with these columns, but you can find them in the docs...

    the tombstone is flag to indicate its a deleted row, the other two i think flags the peer where the row was created and updated...

    Wednesday, June 20, 2012 11:39 AM