|
Pro SQL Server 2005 Replication
Replication is a way of copying and updating information in a database. This allows all users to see the same information and any changes made to it. Replication also duplicates the database across a number of computers so that, if one computer goes down, the information is not lost and can still be accessed. The Definitive Guide to SQL Server 2005
Replication, written by Sujoy Paul, a Microsoft Certified Professional for SQL Server, focuses on this most critical and complex of data management tasks.
This book 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. This book is an ideal read whether you're a novice or advanced replication user.
Introduction: Distributed data
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 replicationn using T-SQL
Internals of transactional replication
Configuring merge replication using the GUI
Web sychronization with merge replication
Backup & recovery of snapshot & transactional replication
Optimizing snaphot replication
Optimizing transactional replication
Optimizing merge replication
Heterogeneous replication
|
