Free SQL Server 2005 Video Tutorial: Pt. 1 - An Introduction to the Concepts and Terms of SQL Server Replication

Pt. 1 - An Introduction to the Concepts and Terms of SQL Server Replication - download

As replication becomes easier to implement and the world becomes more "wired", replication becomes increasingly the de facto standard for synchronizing data between different databases. This video, part 1 in our "Introduction to SQL Server Replication" series, gives you the big picture of why we use replication as well as describing several key terms and definitions. This video is more of a lecture-style video instead of a demo video but do not miss it! It will help you grasp the full scope of how SQL Server can use replication to do everything from synchronizing small "slices" of data from a source to a destination (more accurately termed the publisher and subscriber) and how you can even do disaster recovery with SQL Server replication.

Highlights from this video:

• Answers the question, "What is Replication?"
• Definitions, terms, terminology, architecture and topology of replication
• Understanding Distributors, Publishers, and Subscribers
• Publications, Articles, Tables, Stored Procedures and Views
• Common Uses of/for replication

and much more

---

• Source: http://www.learnsqlserver2005.com
• Category: SQL Server Videobooks
• Skill Level: 200 (Beginner - Intermediate)
• Length: 10:54 (6.57MB)
• Source Videobook Entry (Subscriber-only version)

---

To download this video, visit the Free Videos page, click "download" and enter the correct security code.

Note: You must have the TSCC codec installed to view this video

---

Keywords Associated with this video: replication architecture, merge, transactional, snapshot, dr, beginning, beginner, intro, introduction