O'Reilly logo

Professional Microsoft SQL Server 2012 Administration by Ross LoForte, Steven Wort, Adam Jorgensen, Brian Knight

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required