What is the purpose of Replication

Q

What is the purpose of Replication ?

✍: Guest

A

Replication is way of keeping data synchronized in multiple databases. SQL server replication has two important aspects publisher and subscriber.
Publisher
Database server that makes data available for replication is called as Publisher.
Subscriber
Database Servers that get data from the publishers is called as Subscribers.

2007-10-25, 6580👍, 0💬