March 17, 2003 at 3:03 am
I have to replicate a table from server1 to server2
In server1 users can insert records that has an unique identifier (ID); the table can be replicated to server2 where other users can insert records.
The problem is that if in server1 a new record is created (ID=1) and in the server2 a new record is created also (ID=1) what happens when I replicate the table from server1 to server2? I don't have a unique Id for that table?? I there a way to solve the problem?
Thanks
March 18, 2003 at 9:47 am
DID you create the identity field with the option NOT FOR REPLICATION or not?
March 18, 2003 at 9:50 am
Where can I find this option??
quote:
DID you create the identity field with the option NOT FOR REPLICATION or not?
March 18, 2003 at 12:03 pm
Here's a trick.
Server one, seed the identity field at 1000, increment 2. Server 2 seed the identity field 1001, increment by 2.
No more conflicts.
If you have more sites possible, increment by 10 or ???
KlK, MCSE
KlK
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply