can custom the way to get new anchor ? RRS feed

  • Question

  • I have two server to replication , then sync the subscriper with client 'SQL CE'.

     because the DBTS values are not same between two server. if I replicate the field 'create timestamp' on publication server  to subscriper simply, the sync will not work well . because the new anchor get from 'select @sync_new_received_anchor =@@DBTS + 1',  so , is there any way to :


    1.keep two server DBTS values same ?

    2.can custom the way to get new anchor ? for instance  'select @sync_new_received_anchor = procedure1()'  , then procedure1() get the DBTS value from publication server .

    Friday, July 23, 2010 8:27 AM

All replies

  • why not change from using the offline providers to the peer-to-peer providers (SqlClientSyncProvider)? The offline providers is not meant for peer-to-peer type of sync but more for hub and spoke type of scenario.

    Saturday, July 24, 2010 3:19 PM