Post reply

Two way replication

  • July 10, 2003 at 6:26 am

    #81946

    Hello Guys,

    Can anyone say whether two way replication is possible for tables having IDENTITY SET ON

    e.g.

    TableA

    ID INT NOT NULL IDENTITY(1,1) NOT FOR REPLICATION PRIMARY KEY, NAME VARCHAR(100)

    Can I setup a Two way replication for such tables i.e. If I make a change(Insert/Update/Delete) on Server1, the same change is reflected in Server2 and vice-versa.

    If this is possible, please suggest how to do.

  • July 14, 2003 at 8:00 am

    This was removed by the editor as SPAM

  • July 14, 2003 at 8:22 pm

    #465478

    yes, it is possible to set up two way replication. But an extra work need to be done for those primary key identity field. You have to set different seed and the increment for the tables using identity as primary key in the different server, so that the primary key conflict can be avoided. For example : set the seed to 1 on table1 server 1, and set the seed to 1000000 on table1 server2. if you want to set up the replication, give a check on Show Advanced Options on Create Publication Wizard form.

  • July 15, 2003 at 12:05 pm

    #465578

    Thanks for the reply. That was a nice suggestion to try. I thought it was not at all possible.

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

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