Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Change Tracking | Sync Fx Tracking Table RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    I have set the database (MS Sql Server 2008) table properties of "Change Tracking" to TRUE, for a tabel "Table1" is it required to maintain the following generated from Sync Fx2.1 :

    1. Insert, Update and Delete trigger for a Table1 (Table1 is added to the scope, for synchornization)
    2. Table1_tracking table

    Is there a way to work(pros and cons) without the above 2 points.

    Vishal Mohan

    Monday, September 27, 2010 5:53 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    only the offline providers support SQL Change Tracking. The SqlSyncProvider doesnt make use of this and is using it's own tracking mechanism via triggers and the _tracking table.

    if there's any effect, it's the performance, since you now have two tracking mechanism for every change to the table.

     

    Monday, September 27, 2010 3:07 PM