Chapter 36. Understated changes in SQL Server 2005 replication

Paul Ibison

This chapter aims to cover the following areas:

  • Useful undocumented or partially documented replication behavior
  • Using the more efficient methodologies available in SQL Server 2005 to replace older replication techniques

That means we’ll be covering some of the less obvious changes made to the replication engine between SQL Server 2000 and SQL Server 2005.

Our main source of replication information—Books Online (BOL)—has a dedicated section describing the new replication enhancements found in SQL Server 2005. This section mostly concentrates on the main areas of functionality, such as setting up merge-over-HTTPS, Oracle publishers, peer-to-peer transactional publishing, ...

Get SQL Server MVP Deep Dives 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.