locked
Change Tracking | Sync Fx Tracking Table RRS feed

  • Question

  • 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

  • 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