Chapter 29. Snapshot and Merge Replication

by Laura Jones

IN THIS CHAPTER

  • What Is Snapshot Replication?

  • Setting Up a Snapshot Publication

  • What Is Merge Replication?

  • Setting Up a Merge Publication

  • Merge Replication and Resolving Conflicts—Hands-on Example

  • Troubleshooting Merge and Snapshot Replication

  • Additional Publication Options

  • Alternative Synchronization Partners

  • Replicating via the Web (Internet)

  • Replication FAQs

This chapter examines the simplest form of replication, Snapshot replication and one of the more exciting SQL Server replication modes, merge replication. Snapshot replication was available in SQL Server 6.x; however, SQL Server 7.0 added the capabilities to use updating subscribers and anonymous subscribers with snapshot replication. Merge ...

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.