Step by Step Configuration of SQL Server Database Replication

Опубликовано: 29 Сентябрь 2024
на канале: Efren Plaza

104

Step by Step Implementation of SQL Server Database Replication

Lesson : Implementing Replication
Replication is the mechanism for creating and maintaining multiple copies of the same data. It brings data closer to geographically distributed users, allows for autonomous sites that do not have to be continually connected, and allows you to maintain separate online transaction processing (OLP) and decision support system(DSS) copies of the data.

Server Role in Replication:
When you implement replication, a SQL Server Instance can be either a publisher, a distributor, a subscriber, or any of the three.

Role of the Publisher:
Publisher has the original copy of data(create and modify) and makes this available to subscribers. Publisher can also act as a distributor, known as a local distributor, but when there's a large amount of replication a separate distributor is often created(known as a remote distributor)

Role of the Distributor:
Distributor stores replication status information, publication metadata, and in some cases data, as it moves between the publisher and the subscribers.

Role of the Subscriber:
Subscriber holds a replica copy of the data. Subscriber can be prevented from making modifications, allowed to make modifications on the Publisher or allowed to make local modifications that are merged together later.