If you want to learn a little bit about one of the types of replications, that can be used to distribute data to another database/instance/server, then you should see this video about Snapshot replication.
Imagine that you have a server in one location and a server in another location. They have both a SQL Server installed, and on the first server you have a database called CRM. From that database you want to copy one of the tables, called Customers to a database called CUSTOMERS on the other server.
You want it to be done once a week and there are only 1.000 customers.
In that situation a Snapshot replication could be a good choice. In snapshot replication you:
- Create a publication (Meaning: Customertable from CRM database is now an article in the publication).
- You send it to a distributor that will deliver it to
- A subscriber on the other server.
In the video you will see how a snapshot replication is created.