Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
SqlSyncProvider and SqlServer 2008 change tracking RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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.

    Thanks

    Monday, April 12, 2010 9:28 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    No, SqlSyncProvider does not work with Sql server 2008  change tracking. We have this feature on the consideration for future release.

     

    Maheshwar Jayaraman - http://blogs.msdn.com/mahjayar
    Tuesday, April 13, 2010 2:29 AM

All replies

  • Question
    Sign in to vote
    1
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    No, SqlSyncProvider does not work with Sql server 2008  change tracking. We have this feature on the consideration for future release.

     

    Maheshwar Jayaraman - http://blogs.msdn.com/mahjayar
    Tuesday, April 13, 2010 2:29 AM