74 4
Part V: Enterprise Data Management
Summary
Replication is a complex and powerful feature of SQL Server, and fully describing it could
easily take a book by itself. Using the wizards and dialogs that Microsoft has written into
Management Studio greatly simplifi es the process to confi gure and deploy replication.Key points from this chapter include the following:■ (^) Replication can be a good fi t for your data distribution needs.
■ (^) Replication uses a publisher-distributor-subscriber metaphor.
■ (^) Transactional replication is one-way replication by default and the fastest and most
popular replication method.
■ (^) Peer-to-peer replication is bidirectional transactional replication and an Enterprise
Edition–only feature.
■ (^) Merge replication is a best fi t for bidirectional replication, especially when the pub-
lisher and subscribers are occasionally or frequently offl ine.
c28.indd 744c28.indd 744 7/31/2012 9:51:13 AM7/31/2012 9:51:13 AM
http://www.it-ebooks.info