Microsoft® SQL Server® 2008 Administrator's Pocket Consultant, 2nd Edition

Chapter 13. Implementing Snapshot, Merge, and Transactional Replication

• An Overview of Replication

• Planning for Replication

• Distributor Administration

• Creating and Managing Publications

• Subscribing to a Publication

Data replication lets you distribute data from a source database to one or more destination databases. The source and destination databases can be on computers running different instances of Microsoft SQL Server or on other database systems, as long as an OLE DB provider is available for each destination database. You have precise control over when replication occurs, what data is replicated, and how other aspects of replication are handled. For example, you can configure replication to occur continuously or periodically. Before I examine ...