Replication Overview
Introducing Replication
Replication Model
Introducing the Types of Replication
Introducing Replication Options
Typical Uses of Replication
Reporting, Decision Support, and Data Warehousing Applications
Online/Offline Applications
Web-Based Applications
Keeping Data Close to Users
How Replication Works
Methods of Implementation
Agents and Monitors
Planning for Replication
Distributed Update Factors
Evaluating the Replication Environment
Business Objectives and Requirements
Network Considerations
Security Considerations
Data Needs and Characteristics
Planning for Application Development
Planning for Each Type of Replication
Planning for Snapshot Replication
Planning for Transactional Replication
Planning for Merge Replication
Planning for Replication Options
Merge Replication or Updatable Subscriptions
Designing a Replication Topology
Physical Replication Models
Central Publisher
Central Publisher with Remote Distributor
Republisher
Central Subscriber
Types of Replication
Snapshot Replication
How Snapshot Replication Works
Transactional Replication
How Transactional Replication Works
Merge Replication
How Merge Replication Works
Merge Replication Conflict Detection and Resolution
Row-Level Tracking and Column-Level Tracking
Subscriber Types and Conflicts
Default Resolver and Custom Resolvers
COM Custom Resolvers
Specifying a Custom Resolver
Interactive Resolver
Custom Stored Procedure Conflict Resolver
Other Microsoft Resolvers
Microsoft Resolver Descriptions
Choosing a Resolver
Replication Tools
Replication and SQL Server Enterprise Manager
Replication Wizards
Replication Properties
Replication Icons
Replication Programming Interfaces
Programming Replication with ActiveX Controls
Programming Replication with SQL-DMO
Programming Replication with the Replication Distributor Interface
Transact-SQL System Stored Procedures
Windows Synchronization Manager
Active Directory Services
Implementing Replication
Configuring Replication
Publishers, Distributors, and Subscribers
Disabling Publishing and Distribution
Publishing Data and Database Objects
Publishing Stored Procedure Execution
Using Custom Stored Procedures in Articles
Subscribing to Publications
Push Subscriptions
Pull Subscriptions
Anonymous Subscriptions
Applying the Initial Snapshot
Generating the Initial Snapshot
Alternate Snapshot Locations
Compressed Snapshot Files
Exploring Snapshots
Transferring Snapshots
Attachable Subscription Databases
Configuring a Publication to Allow Copying
Copying a Subscription Database
Attaching a Subscription Database
Attaching Databases with Named Subscriptions
Attaching Databases with Anonymous Subscriptions
Improving Performance While Generating and Applying Snapshots
Executing Scripts Before and After the Snapshot is Applied
Reinitializing Subscriptions
Synchronizing Data
Scripting Replication
Schema Changes on Publication Databases
Implementing Replication Over the Internet
Publishing Data Over the Internet Using VPN
Publishing Data Over the Internet Using Microsoft Proxy Server
Publishing Data Over the Internet Using TCP/IP and FTP
Configuring a Publisher or Distributor to Listen on TCP/IP
Configuring a Publication to Allow Subscribers to Retrieve Snapshots Using FTP
Configuring a Subscription to Use FTP to Retrieve a Snapshot
Replication Between Different Versions of SQL Server
SQL Server 7.0 Publisher/Distributor to SQL Server 6.5 Subscriber
SQL Server 7.0 Publisher/Distributor to SQL Server 6.0 Subscriber
SQL 6.5 Publisher/Distributor to SQL Server 7.0 Subscriber
SQL Server 6.5 Publisher to SQL Server 7.0 Distributor
Replication with SQL Server 2000 Windows CE Edition
Replication Options
Filtering Published Data
Row Filters
Column Filters
Dynamic Filters
Dynamic Snapshots
Validate Subscriber Information
Join Filters
User-Defined Functions and Static Filters
User-Defined Functions and Dynamic Filters
Updatable Subscriptions
Immediate Updating
How Immediate Updating Works
Immediate Updating Components
Immediate Updating Considerations
Queued Updating
How Queued Updating Works
Queued Updating Components
Queued Updating Considerations
Queued Updating Conflict Detection and Resolution
Queued Updating and Identity Ranges
Immediate Updating with Queued Updating as a Failover
Transforming Published Data
How Transforming Published Data Works
Creating a Transformable Subscription Using Replication Wizards
Using Transformable Subscriptions to Create Custom Data Partitions
Defining a Vertical Partition
Defining a Horizontal Partition
Using Distributed Agents to Create Efficient Custom Partitions
Using Transformable Subscriptions with Data Transformations
DTS Package Details
Limitations and Considerations
Alternate Synchronization Partners
How Alternate Synchronization Partners Works
Optimizing Synchronization
Replication Data Considerations
Using IDENTITY Values with Replication
Managing Identity Values
Identity Ranges with Immediate Updating and Queued Updating
Managing Replicated timestamp Data
Using NOT FOR REPLICATION
Administering and Monitoring Replication
Tools for Administering and Monitoring Replication
Replication Monitor
Replication Agent Utilities
ActiveX Controls for Replication
Windows NT Performance Monitor and Windows 2000 System Monitor
Setting Agent Parameters
Agent Profiles
Replication Agents
SQL Server Agent
Snapshot Agents
Snapshot Agent Profile
Distribution Agents
Distribution Agent Profile
Log Reader Agents
Log Reader Agent Profile
Queue Reader Agents
Merge Agents
Merge Agent Profile
Miscellaneous Agents
Viewing Agent History
Handling Agent Errors
Remote Agent Activation
Replication Alerts
Automating a Response to an Alert
Predefined Response Jobs
Subscription Deactivation and Expiration
Validating Replicated Data
Replication and Heterogeneous Data Sources
Heterogeneous Subscribers
Access Subscribers
Oracle Subscribers
IBM DB2/AS400 Subscribers
IBM DB2/AS400 Data Type Definitions
IBM DB2/MVS Subscribers
Other Heterogeneous Subscribers
Implementing Merge Replication to Access Subscribers
Data Type Mapping to Jet-SQL 4.0 for Merge Replication
Heterogeneous Publishers
Replication Security
Role Requirements
Connecting to the Distributor
Snapshot Folder Security
Publication Access Lists
Agent Login Security
Security and Replication Options
Security and Replication Over the Internet
Enhancing Replication Performance
Enhancing Snapshot Replication Performance
Enhancing Snapshot and Transactional Replication Performance
Enhancing Transactional Replication Performance
Enhancing Merge Replication Performance
Backing Up and Restoring Replication Databases
Strategies for Backing Up and Restoring Snapshot Replication
Strategies for Backing Up and Restoring Transactional Replication
Transactional Replication and Log Shipping
Strategies for Backing Up and Restoring Merge Replication
Restoring Backups of Replicated Databases to the Same Server and Database
Restoring Backups of Replicated Databases to a Different Server or Database