Replication Documentation Map

Replication is a set of technologies for copying and distributing data and database objects from one database to another and then synchronizing between databases to maintain consistency. Using replication, you can distribute data to different locations and to remote or mobile users over local and wide area networks, dial-up connections, wireless connections, and the Internet.

It is recommended that you first look through one or more of the scenarios provided in the first two sections of the following table to understand how replication can support your application and business requirements. You can then use the sections on configuring, maintaining, and programming replication for detailed conceptual, procedural, and reference information on all replication features.

Replication Documentation

For more information about replication, see these sections of SQL Server Books Online.

Section Description

Replicating Data in a Server to Server Environment

Provides a set of scenarios and tutorials for replicating data between servers. Scenarios include:

  • Improving scalability and availability
  • Data warehousing and reporting
  • Integrating data from multiple sites
  • Integrating heterogeneous data
  • Offloading batch processing

Replicating Data Between a Server and Clients

Provides a set of scenarios and tutorials for replicating data between servers and clients, including workstations, laptops, tablets, and devices. Scenarios include:

  • Exchanging data with mobile users
  • Retail point of sale (POS) applications
  • Integrating data from multiple sites

Configuring and Maintaining Replication

Describes the steps for configuring and maintaining replication using replication wizards, system stored procedures, Replication Management Objects (RMO) programming, and other replication tools.

Replication F1 Help

Provides detailed information on replication wizards and dialog boxes.

Replication Programming

Discusses programming replication using RMO and stored procedures.

Replication Programming Samples

Provides sample applications that illustrate replication functionality.

Troubleshooting Replication

Provides troubleshooting tips and information.

Cause and Resolution of Replication Errors

Lists errors and events by event ID.

See Also

Concepts

SQL Server Overview

Other Resources

SQL Server Replication

Help and Information

Getting SQL Server 2005 Assistance