Chapter 22. Data Replication

by Paul Bertucci


  • What Is Replication?

  • The Publisher, Distributor, and Subscriber Metaphor

  • Replication Scenarios

  • Replication Agents

  • Planning for SQL Server Data Replication

  • SQL Server Replication Types

  • User Requirements Drive the Replication Design

  • Setting Up Replication

  • Scripting Replication

  • Monitoring Replication

Nothing is typical anymore. Companies now have to support numerous hardware and software configurations in multitiered, distributed environments. These diverse configurations and applications (and users of the applications) come in all sizes and shapes. And, of course, you need a way to deal with varied data access requirements for these different physical locations, these remote or mobile users over a local area network, any dial-up connection users, and any needs over the Internet. Microsoft's Data Replication facility allows for a great breadth of capability to deal with many of these demands. However, to build a proper data replication implementation that meets many of these user requirements, you must have a thorough understanding of the business requirements and of the technical capabilities of data replication. This chapter does the following:

  • Aides you in understanding what data replication is

  • Shows you how to look at the users' requirements of data

  • Allows you to choose which replication configuration best meets these requirements (if any)

  • Demonstrates how to implement this configuration

  • Describes how to administer and monitor a data replication implementation

    Part III: SQL Server Administration
    Part IV: Transact-SQL
    Part V: SQL Server Internals and Performance Tuning
    Part VI: Additional SQL Server Features