Replication Overview
Microsoft® SQL Server™ 2000 replication is a set of solutions that allow you to copy, distribute, and potentially modify data across your enterprise. SQL Server 2000 includes several methods and options for replication design, implementation, monitoring, and administration to give you the functionality and flexibility needed for distributing data and maintaining data consistency.
| Topic | Description |
|---|---|
| Introducing Replication | Describes how replication can be used in various business environments. Explains the SQL Server 2000 replication model, the types of replication, and how replication works. |
| Planning for Replication | Provides the information needed to make critical decisions when creating a replication plan, including: business considerations, enterprise data needs, network considerations, and designing a replication topology. |
| Types of Replication | Details the types of replication (snapshot replication, transactional replication, and merge replication). Discusses the components of each type, how each type works, the architecture, and the benefits and strengths of each type. |
| Replication Tools | Describes the primary methods used to implement replication, including using the replication wizards, using system stored procedures, programming a replication application with Microsoft ActiveX® controls, and using tools such as Windows Synchronization Manager. |
| Implementing Replication | Describes the steps for implementing replication using the replication tools. Includes configuring Publishers and Distributors, creating publications, creating different types of subscriptions, replicating between instances of SQL Server 2000 and instances of SQL Server version 7.0 and earlier. |
| Replication Options | Explains the options available with each type of replication, including filtering published data, publishing database objects, immediate updating, queued updating, and transforming published data. |
| Replication Data Considerations | Includes handling identity columns, timestamp data, uniqueidentifiers and data types. |
| Administering and Monitoring Replication | Details the agents used during replication, replication alerts, validating data at the Subscriber, strategies for monitoring replication, and remote agent activation. |
| Replication and Heterogeneous Data Sources | Describes how you can replicate data between heterogeneous data sources (such as DB2, Oracle, Microsoft Access, or Microsoft Exchange), how to publish to heterogeneous Subscribers, and how to subscribe to heterogeneous Publishers. |
| Replication Security | Discusses security access layers and replication, Internet security issues, snapshot folder security, agent login security, role requirements, and security for updatable subscriptions. |
| Enhancing Replication Performance | Provides techniques for optimizing replication performance including enhancement techniques for each type of replication, effective data partitioning, and Distributor options. |
| Backing Up and Restoring Replication Databases | Describes strategies for backing up replication databases, how to restore each type of replication, and restoring backups of replicated databases. |
| Getting Started with Replication Programming | Discusses programming replication including using ActiveX controls, SQL-DMO, and the Replication Distributor Interface. |