sql server replication: Merge Replication -- sql server replication

Merge Replication

mcdojj
1/20/2005 6:15:03 AM

sql server replication: We are looking into options for bring up a second live business site using
SQL Server 2000 Std edition. The databases will updated at both locations
and need to remain in sync at both locations. Some the tables contain
Identity columns. We have noticed Primary Key issues when we insert into a
new record on different servers and the records are replicated to each other

Re: Merge Replication

Hilary Cotter
1/20/2005 9:39:33 AM

Well Microsoft sales will be very happy to sell you a copy of Enterprise
Edition, but it won't solve your problem. You will need to partition your
data so that your identity seeds are different (1 on the publisher and 2 on
the subscriber for example) with an increment of 2.

Either that or extend your PK to include a location specific id, which will
probably involved adding another column to your tables you are replicating.

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
[quoted text, click to view]
Edition?