Chapter 28. Transactional Replication
by Laura Jones
IN THIS CHAPTER
Applicable Uses for Transactional Replication
Replication Agents
Replication Topology
Immediate Updating Subscribers
Recommended Topology for Updating Subscribers
Creating a Transaction Based Publication
Subscriptions
Custom Stored Procedures
Transforming Published Data
Inline Data Validation and Reinitialization
Generating Publication Scripts
Replicating Stored Procedures
Replication Monitor
Transactional Replication FAQ
Transactional replication is one of three methods provided by SQL Server for distributing data from one database to each subscribing database. SQL Server monitors changes made in the publishing database and passes those changes (inserts, updates, and deletes) to the subscribers ...
Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition 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.