Pro SQL Server 2005 Replication
Description
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. Pro 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, plus performance and tuning. This book is an ideal read whether you're a novice or advanced replication user.
More details
Other editions
Additional editions
Person
Content
Introduction: Distributed Database.- Replication Basics.- Types of Replication.- Snapshot Replication.- Transactional Replication.- Merge Replication.- Replication of SQLServer with Heterogeneous Databases.- Replication of datatypes and database objects.- Backup and Recovery of Replicating Databases.- Performance and Tuning.- Troubleshooting replication.- Replication Features of SQL Server 2000.- Glossary.- Index.