Sign in
Microsoft.com
 
Microsoft
 
 
 

none
missing _tracking meta data RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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
    |

Answers

  • Question
    Sign in to vote
    1
    Sign in to vote

    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
    |
    Moderator