Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Whether a record is synched or not RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    Can we have a mechanism where we come to know whether a record  is synched or not?I am uploading a data in Sync data.Say for eg table1 has 5 records, out of which 3 records are already uploaded to server.Now after insertion of 2 records ,how can I come to know whether other two records are synched .

    Regards,

    Sachin K

    Tuesday, March 13, 2012 12:10 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    if you're storing the datetime everytime you sync, then all rows in the _tracking table whose last_change_datetime is greater than the last sync time are changes that hasnt been synched.

    if you're not storing the sync datetime, timestamps in the tracking table that are greater than the timestamp in the scope_info table are changes that has not been synched.

    • Marked as answer by sakulkarni83 Tuesday, March 13, 2012 1:23 PM
    Tuesday, March 13, 2012 1:08 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    correct me if am wrong, you want to know which records has not been synched yet or what changes are pending for sync?

    Tuesday, March 13, 2012 12:18 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Yes.
    Tuesday, March 13, 2012 12:28 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    if you're storing the datetime everytime you sync, then all rows in the _tracking table whose last_change_datetime is greater than the last sync time are changes that hasnt been synched.

    if you're not storing the sync datetime, timestamps in the tracking table that are greater than the timestamp in the scope_info table are changes that has not been synched.

    • Marked as answer by sakulkarni83 Tuesday, March 13, 2012 1:23 PM
    Tuesday, March 13, 2012 1:08 PM