Chapter 36. Understated changes in SQL Server 2005 replication
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, ...