Sync Framework Triggers RRS feed

  • Question

  • Why does the sync framework use triggers to update the _tracking tables?

    I know SQL 2008 provides CDC feature which could be used to detect changes and update the tracking tables without the use of triggers.

    I populate my tables using ETL jobs which do bulk batches, and trigger can adversely consume system resources.

    Wednesday, March 2, 2011 11:22 AM