locked
SQL Server 2008 Change Tracking property RRS feed

  • Question

  • Can someone explain the relationship between Sync Framework and the 'Change Tracking' property I can set in SQL Server 2008 for each table.

    It seems as though this setting can be false/true and my Sync solution works fine.  Does setting this property effect Sync Framework 2.1, or is it ignored by teh Sync Framework 2.1?

    Thanks.

     

    Thursday, September 16, 2010 10:18 PM

Answers

  • afaik, that is ignored by Sync Fx if your using SqlSyncProvider. The offline providers (the one used by the Local Database Cache project item in VS) supports SQL Change Tracking though and disabling change tracking on a table will affect Sync Fx if it was configured to use SQL Change Tracking.

    • Marked as answer by sbhuller Friday, September 17, 2010 3:26 PM
    Friday, September 17, 2010 12:56 AM