Chapter 12. Implementing Snapshot, Merge, and Transactional Replication

Data replication allows you to distribute data from a source database to one or more destination databases. The source and destination databases can be on different Microsoft SQL Servers 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 happen continuously or periodically. Before we examine how to ...

Get Microsoft® SQL Server™ 2005 Administrator's Pocket Consultant 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.