Chapter 13. Implementing Snapshot, Merge, and Transactional Replication

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 ...

Get Microsoft® SQL Server® 2008 Administrator's Pocket Consultant, 2nd 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.