Chapter 20. Replication

Replication Fundamentals

Uses of Replication

Replication Concepts

Types of Replication

Components of Replication

Configuring Replication

Creating a Publication with SQL Statements

Creating a Subscription with SQL Statements

Configuring an Oracle Publication

Managing Replication

Monitoring and Tuning Replication

Summary

Replication is one of the best features of Microsoft SQL Server 2005. SQL Server replication is a very mature product and is very stable and high-performing. SQL Server replication is used primarily to distribute data between multiple locations within your business. Replication can also be used for many other purposes, including:

  • Creating read-only reporting servers, thus relieving some of the load from the OLTP server ...

Get Microsoft® SQL Server™ 2005 Administrator's Companion now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial