Posted by Erland Sommarskog on 10/01/27 11:21

Neil (nospam@nospam.net) writes:
> I'm running a SQL 7 db on a LAN in city A with other users accessing it
> from another city (city B) over a WAN. Obviously the WAN users are
> getting much slower access to the data. One thing I was wondering was if
> it was possible to have two versions of the database, one on each
> server, and have them automatically synchronize as users at each
> location make changes. Or, if that's not possible, then at least have
> the city B users get any changes that the city A users get as they are
> made.

Since you included .replications, I leave it to the real experts for the
deep answer; I just give you the quick one.

Both options are possible, but double synchronize would require merge
replication, which I believe is more comples to set up, and may require
that you add guids to all table you need to replicate.

One-way replication by transactional replication is a simpler affair, but
still requires some consideration.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[Back to original message]