missing _tracking meta data RRS feed

  • Question

  • I have reviewed the delete/insert/update triggers for each sync database table. I understand these triggers add a corresponding row to the <table>_tracking table.

    Most importantly we are using the last_change_datetime field to filter records as  part of an import to an on_premise database from a Windows Azure database. Why would so many _tracking table rows have all NULLs for the following fields?

    update_scope_local_id scope_update_peer_key scope_update_peer_timestamp, create_scope_local_id, scope_create_peer_key, scope_create_peer_timestamp, last_change_datetime

    Friday, June 20, 2014 12:57 AM


  • depending on how the tracking tables are populated, not all of the fields get updated.

    e.g., insert/update was made local to the replica, insert/update was made based on sync from another replica, etc...

    • Marked as answer by James R Traub Wednesday, June 25, 2014 4:21 PM
    Wednesday, June 25, 2014 2:06 AM