Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Last successful sync date and time? RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    I am syncing between SQL Server and SQL CE.  Is there any way to find the date/time of the last successful sync?
    Monday, December 20, 2010 6:59 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    The "edit" doesn't seem to work properly. Here is a rephrase of last post.

    On the syncStatistics returned you can see the sync information including the sync datetime and whether it's all successful or there are failures.

    SyncOperationStatistics stats = orchestrator.Synchronize();

    You can record every sync's statistics to a file or database table. 

     

    Monday, December 20, 2010 7:47 PM
    Answerer

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    On the syncStatistics returned you can see the sync information including the sync datetime and whether it's all successful or there are failures.

    SyncOperationStatistics 

     

     

    You can also record every sync's statistics to a file or database table.

    stats = orchestrator.Synchronize();
    Monday, December 20, 2010 7:35 PM
    Answerer
  • Question
    Sign in to vote
    0
    Sign in to vote

    The "edit" doesn't seem to work properly. Here is a rephrase of last post.

    On the syncStatistics returned you can see the sync information including the sync datetime and whether it's all successful or there are failures.

    SyncOperationStatistics stats = orchestrator.Synchronize();

    You can record every sync's statistics to a file or database table. 

     

    Monday, December 20, 2010 7:47 PM
    Answerer
  • Question
    Sign in to vote
    0
    Sign in to vote

    I was kind of hoping to be able to check some kind of field, not necssarily at sync time.  If that is not possible, I can save off the stats.

    Tuesday, December 21, 2010 2:41 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Sync results are not recorded as sync metadata so you will need to record them yourself, either in file or table.
    Tuesday, December 21, 2010 6:04 PM
    Answerer