Replication Explained for my Grandmother.

Here is a brief explanation of some of the basic terminology of SQL Server Replication . If your grandmother can post a letter , she can probably replicate a database.


1) Publisher
2) Subscriber
3) Distributor


Publisher -
 it's the Source Database. The point of initiation of replication. (Post a letter analogy) - The house where the letter initiates.


Subscriber

 it's the Destination Database. The end point of replication. (Post a letter analogy) - The house where the letter ends.


 Distributor
it's the intermediary database. (Post a letter analogy) - The postman.




I will hopefully right a more complete post, on how to set up the Replication.