Post reply

add new field to subscriber table

  • July 22, 2010 at 9:45 pm

    #235684

    In the publication table, there is a field 'create_timestamp' which is a bigint and has default value '(@@dbts+(1))', I use this field to sync with local SQL CE, but if add the field to publishing articles , the Microsoft sync framework can't run well. any one know the mechanism of Microsoft Synchronization ?

    for solve the above problem , I add a new field 'create_timestamp' in the subscription table instead of publishing the field 'create_timestamp' , it works fine. but when I run a snapshot to the subscriber , the added field 'create_timestamp' will be losted , is there any way to keep the 'create_timestamp' field and its value existed or can be restored after snapshot ?

    Thanks in advance.

  • July 26, 2010 at 8:44 am

    #1198235

    Is this snapshot replication ? Or transactional replication?

    -Roy

  • April 21, 2012 at 2:22 am

    #1477019

    transactional replication

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply