Hi,
We have 4 different international sites that will need to replicate changes
between 4 tables. Each site will need to make changes to the tables locally
and have those changes propogated out to the other 3 sites. Data volume
will be about 25 changes per site per minute. Latency should be under 10
minitues. The connections between the sites is pretty reliable and fast
(max not available - twice a month - fix in 1 hour).
Which replication type would work best here? i.e, Merge, Transactional with
Immediate Updating Subscribers. Which would be the easiest to recovery from
a failure using a backup if a disaster occurs?
Thanks.
Jerry
Also,
Each server is in a seperate domain. I'm not sure of the setup but I can
create a linked server to each. Should I be using linked servers in this
replication setup as well?
Thanks again
Jerry
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:OMjgWXCeFHA.2688@.TK2MSFTNGP14.phx.gbl...
> Hi,
> We have 4 different international sites that will need to replicate
> changes between 4 tables. Each site will need to make changes to the
> tables locally and have those changes propogated out to the other 3 sites.
> Data volume will be about 25 changes per site per minute. Latency should
> be under 10 minitues. The connections between the sites is pretty
> reliable and fast (max not available - twice a month - fix in 1 hour).
> Which replication type would work best here? i.e, Merge, Transactional
> with Immediate Updating Subscribers. Which would be the easiest to
> recovery from a failure using a backup if a disaster occurs?
> Thanks.
> Jerry
>
sql
Monday, March 26, 2012
Replication Recommendation
Labels:
changesbetween,
database,
international,
microsoft,
mysql,
oracle,
recommendation,
replicate,
replication,
server,
sql,
tables
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment