Answered by:
Last successful sync date and time?

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.
- Proposed as answer by jigu2014Microsoft employee, Editor Monday, December 20, 2010 7:47 PM
- Marked as answer by chuck the greek Tuesday, December 21, 2010 6:37 PM
Monday, December 20, 2010 7:47 PMAnswerer
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 PMAnswerer -
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.
- Proposed as answer by jigu2014Microsoft employee, Editor Monday, December 20, 2010 7:47 PM
- Marked as answer by chuck the greek Tuesday, December 21, 2010 6:37 PM
Monday, December 20, 2010 7:47 PMAnswerer -
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 PMAnswerer