Post reply

Identity column

  • June 23, 2004 at 7:07 pm

    #85770

    I am in the process of setting up a bidirectional merge between 2 servers.

    I need to implement the odd/even identity.

    Do i have to add a new column say 'ROWGUID' and set the identity 1, seed 2 on publisher and identity 0 , seed 2 on the other? Eg i have a table Centers with columns

    'centerid' primary key, identity

    'centername' varchar not null

    So do i hae to add 'Rowguid' manually to all table's to implement partioning?

  • June 23, 2004 at 7:32 pm

    #511690

    Merge Replication will automatically add a rowguid column for each table that will participate in a Publication. You will have to range the Identity columns.

    Kindest Regards,

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

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