Replication suggestion | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Replication suggestion

Hi , We are designing 2 data centers for distributing applications between East and West coast users. I would like to Load balance one of our application between the 2 data centers. Both the data centers should be able to view/modify changes for this application. In other words if Data center 1 makes the change(s), they should be available to Data Center 2 and vice versa ONLINE. Could I get some help in understanding if Replication can provide solution to this ?? Appreciate your help and thanks in advance.
YEs, check out Peer-Peer Replication. Books On Line has very good documentation on it. ***********************
Dinakar Nethi
SQL Server MVP
Peer to peer replication is available only sql server 2005 EE and make you have dedicated line between two centers to reduce the latency…. Check the following articles…
Moderator All postings are provided “AS IS” with no warranties for accuracy.

Appreciate your response!! Thanks.