Chapter 15

Replication

WHAT’S IN THIS CHAPTER

  • The Different Types of Replication
  • Replication Models
  • Setting up Snapshot Replication
  • Setting up the Distributor
  • How Snapshot Differs from Transactional, and Merge Replication
  • Peer to Peer Replication
  • How to Monitor Replication

Today’s enterprise needs to distribute its data across many departments and geographically dispersed offices. SQL Server replication provides ways to distribute data and database objects among its SQL Server databases, databases from other vendors such as Oracle, mobile devices such as Windows Phone 7, and point-of-sale terminals. Along with log shipping, database mirroring, and clustering, replication provides functionalities that satisfy customers’ needs for load balancing, high availability, and scaling.

This chapter introduces you to the concept of replication, explaining how to implement basic snapshot replication, and noting things to pay attention to when setting up transactional and merge replication.

REPLICATION OVERVIEW

SQL Server replication closely resembles the magazine publishing process, so we use that analogy to explain its overall architecture. Consider a popular magazine. The starting point is the large pool of journalists writing articles. From all the available articles, the editor picks which ones to include in the current month’s magazine. The selected set of articles is then published in a publication. After a monthly publication is printed, it is shipped out via various distribution ...

Get Professional Microsoft SQL Server 2012 Administration now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.