Replication Concepts

Replication¾provided as an integral element of Microsoft SQL Server 6.0¾allows you to automatically distribute copies of transactional data from a single source server to one or more destination servers at one or more remote locations.

This chapter provides an orientation to SQL Server 6.0 replication, describing its essential features, components, and capabilities. It also provides a replication glossary that defines many replication-related terms.

For information, choose one of the following topics.

Replication Overview

The Publishing/Subscribing Metaphor

Replication Components

Replication Is Log-Based

Server Roles in Replication

Data Distribution Options

Synchronization

Push and Pull Subscriptions

Graphical Administration

Replication Security

Replication and SQL Executive

Replication and ODBC

Replication Scenarios

Frequently Asked Questions

Replication Terminology