SqlSyncProvider and SqlServer 2008 change tracking RRS feed

  • Question

  • Can we use SQL Server 2008 change tracking functionality with SqlSyncProvider in order to sync between two SQL Server 2008 database. Can someone please provide the example or some document for the same.


    Monday, April 12, 2010 9:28 AM


All replies

  • afaik, you cant.

    the SyncScopeProvisioning will create a separate _tracking table to save the metadata for keeping track of the changes. The _tracking table not only keeps track of create/update timestamp but keeps track as well of the peer that created/update the row.

    So while in theory you can probably rewrite the SelectChanges sp to retrieve the added/changed rows using SQL Change Tracking, SQL Change Tracking cannot provide the peer who created/updated the row.

    • Proposed as answer by Enumclaw Tuesday, April 20, 2010 1:26 AM
    Monday, April 12, 2010 10:45 AM
  • No, SqlSyncProvider does not work with Sql server 2008  change tracking. We have this feature on the consideration for future release.


    Maheshwar Jayaraman -
    Tuesday, April 13, 2010 2:29 AM