sql server replication: I have 4 SQL servers in diff regions. I want to replicate between all must have same data at a time. which replication helps me and better in performance?

Thanks,

It depends on where the data is changing. Is one of the servers receiving
all the changes and propagating to other 3? If so, you will want to go for
transactional replication.

If all 4 servers want to make changes and propagate them to the rest of the
servers, merge is the way to go.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
What hardware is your SQL Server running on?
http://vyaskn.tripod.com/poll.htm


[quoted text, click to view]
I have 4 SQL servers in diff regions. I want to replicate between all must
have same data at a time. which replication helps me and better in
performance?

Thanks,

Jay.