Replication is a way of copying and updating information in a database. The Definitive Guide to SQL Server 2005 Replication is for Microsoft database developers and administrators who want to learn about the different types of replication and those best suited to SQL Server 2005. The book will also delve into advanced topics like replication of SQL Server with heterogeneous databases; replication of different database objects like stored procedures; backup and recovery of replicated databases; performance and tuning; and finally troubleshooting replication. As such, this book will address the concerns of both novice and advanced users of replication.

Pro SQL Server 2008 Replication is for Microsoft database developers and administrators who want to learn about the different types of replication and those best suited to SQL Server 2008. This book will also cover advanced topics like replication with heterogeneous databases, backup and recovery of replicated databases, database mirroring with replication, log shipping with replication, troubleshooting, plus optimization and tuning. Tools like tablediff, SQLCMD, DTA, SQL Profiler, and Replication Monitor will be discussed to demonstrate the different techniques used in monitoring, administering, and troubleshooting replication. Examines the detailed configuration and the internal workings of the different replication types using reallife scenarios Covers replication with database mirroring and troubleshooting Discusses replication administration using different tools Table of Contents Introduction Replication Basics Types of Replication Configuring Snapshot Replication Using the GUI Configuring Snapshot Replication Using T-SQL Snapshot Generation Internals of Snapshot Replication Configuring Transactional Replication Using the GUI Configuring Transactional Replication Using T-SQL Internals of Transactional Replication Configuring Merge Replication Using the GUI Web Synchronization with Merge Replication Configuring Merge Replication Using T-SQL The Internals of Merge Replication Backup and Recovery of Snapshot and Transactional Replication Backup and Recovery of Merge Replication Optimizing Snapshot Replication Optimizing Transactional Replication Optimizing Merge Replication Heterogeneous Replication