January 24, 2007 02:24 PM

SQL Server 2005 Replication

Rating: (0)
SQL Server Magazine
InstantDoc ID #94413
Distributing data between different locations in an organization is essential for scalability, availability, and distributed reporting. SQL Server 2005 uses a publishing model to describe its distribution process: The data being replicated is the article, the system that's the source of the data is the Publisher, and the systems that receive the replicated data are the Subscribers. The SQL Server system that transfers the data is the Distributor. One Publisher can have multiple Subscribers, and in many cases, the Publisher also acts as the Distributor. SQL Server 2005 supports several types of database replication to meet different needs.

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Add a Comment

Sample setup scripts would make this article much better

Daniel4/3/2007 12:40:53 PM


It would be very useful if more elaboration was possible with sample setup scripts.

Mahua2/13/2007 10:44:24 PM


It would be better if you can depict the same with a picture.

sekharsql 2/9/2007 1:37:31 AM


Nice summary about replication models

Maurice2/2/2007 1:09:17 PM


You must log on before posting a comment.

Are you a new visitor? Register Here
GOOGLE LINKS
SPONSORED LINKS
FEATURED LINKS