Snapshot replication for beginners

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:

  1. Create a publication (Meaning: Customertable from CRM database is now an article in the publication).
  2. You send it to a distributor that will deliver it to
  3. A subscriber on the other server.

In the video you will see how a snapshot replication is created.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s