Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Get Last synched time RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    Hello,

    I am using N-Tier architecture for Synchronization Services for ADO.NET in my windows mobile application for SQL CE 3.5 SP1. I would like to know if there is a way to check the last time user synchronized. I used to query a system table when I was using Merge Replication earlier. However now I am using timestamp data type for update and create tracking columns.

    Any help on this one is appreciated

    Thanks

    Apurv
    • Moved by Hengzhe Li Friday, April 22, 2011 8:02 AM (From:SyncFx - Microsoft Sync Framework Database Providers [ReadOnly])
    Wednesday, October 15, 2008 2:50 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote
    Any ideas on this one please!
    Thursday, October 16, 2008 1:22 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    CE stores the sent/received anchors for each synchronizing table in ‘__sysSyncArticles’ table. You can query that to see the last synchronized anchors.

     

    Friday, October 17, 2008 4:17 AM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote
    Thank you so much! Is it possible to cast the anchor value to date time?

    Thanks
    Friday, October 17, 2008 5:12 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Its a ulong so if the original anchor returned from server was DateTime.Ticks then you should be able to create a DateTime out of it

     

    Friday, October 17, 2008 6:05 PM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote
    Thanks. How do I know if the original anchor is DateTime.ticks? I am using following statement to set the anchor:

    anchorCmd.CommandText = "Select @" + SyncSession.SyncNewReceivedAnchor + " = min_active_rowversion() - 1";

    Thanks

    Apurv

    Friday, October 17, 2008 6:14 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    its a timestamp column and you cannot convert it to datetime. You can convert it to ulong though and that will give you the tickcount on the server.

     

    Friday, October 17, 2008 9:39 PM
    Moderator