locked
SqlSyncProvider - How to use datetime as tracking scheme as oppose to logical clock Timestamp

    Întrebare

  • I notice that using Timestamp as a tracking schema would have some issues on database backup and restore that need to deal with.

    How do i use datetime as tracking scheme in the SqlSyncProvider ?
    If SqlSyncProvider  does not support datetime as tracking schema, any codes sample utilizing sync framework 2.0 which I can be referred on ?

    thanks


    • Mutat de Hengzhe Li 21 aprilie 2011 07:40 (From:SyncFx - Microsoft Sync Framework Database Providers [ReadOnly])
    9 decembrie 2009 02:57

Toate mesajele

  • The benefit of SqlSyncProvider is that it dramatically reduces the efforts put in by the Sync solution writer.
    With that, the provisioning by SqlSyncProvider uses a pre-cooked tracking schema.

    If the tracking column type needs to be changed, that will require changing all the related tracking table, triggers, stored procedures etc.
    It's not entirely impossible with SqlSyncProvider. However, in that base, using DbSyncProvider would be a more natural option.

    We will look into the backup/restore problem and see what's root cause of the problem and how to address it.

    Thanks.
    9 decembrie 2009 20:05
  • I discussed this with colleagues.
    We are not recommending doing this even for DbSyncProvider.
    This scenario is also never tested by us.
    12 decembrie 2009 01:06