none
Confusion with SQL Server 2008 change tracking and SqlSyncProvider RRS feed

  • Question

  • Hello - I want to confirm that if I use the SqlSyncProvider to synchronize between two SQL Server 2008 databases, then I don't need to set change tracking in the database instances.  I've read in past posts that SqlSyncProvider doesn't support SQL 2008 change tracking - is this still true?  I've tried GaryE's SQL Server and SQL Express 2-Tier sample and noted that change tracking is not enabled on the DB instances and the sample uses the SqlSyncScopeProvisioning class.

    http://code.msdn.microsoft.com/Database-SyncSQL-Server-a9752fac


    Also, is there any advantage then to enabling change tracking if SqlSyncProvider doesn't use it?
    • Edited by anthonys123 Wednesday, November 9, 2011 6:33 PM
    Wednesday, November 9, 2011 6:31 PM

Answers

  • SqlSyncProvider doesn't support using SQL Server Change Tracking. There is no advantage of enabling it if you're not going to use it. You're just adding extra load on your database since changes has to be tracked twice, one using SQL Change Tracking and another one using the the SqlSyncProvider custom change tracking. you'll also be storing change metadata twice.
    • Marked as answer by anthonys123 Thursday, November 10, 2011 4:21 PM
    Wednesday, November 9, 2011 11:41 PM
    Moderator