Books or Articles on Replication Strategy

[Rick Long]

If anyone has books or an Internet article that discusses replication
strategy, I would appreciate a reference.

We are starting our first replication project and would like to learn
best practices before we experience "what not to do".
Example: How to allow users in two locations to add new Orders where the
Order number needs to be unique?

[Unknown]

Rick Long wrote:

> We are starting our first replication project and would like to learn
> best practices before we experience "what not to do". Example: How
> to allow users in two locations to add new Orders where the Order
> number needs to be unique?

One way is to have a unique identifer stored in eache server that is
used in the primary key to make sure what comes out is unique....

If you only have a few machines, 'a' ,'b', 'c' works....

Another less secure way is to partition the "numers" amongst the
machines. Server 1 starts uses 0 to 100 for keys, server 2 uses 200 to
300 etc. Of course you can expand the ranges but there is a chance of
overlap if one server creates too many records and goes byond its range.

hth

--
Rob Schieck
TeamB