locked
Last successful sync date and time? RRS feed

  • Question

  • 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

  • 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

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