Pro SQL Server 2005 Replication

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 explore advanced topics like replication of SQL Server with heterogeneous databases.

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.

Focuses on one of the most critical and complex tasks of database management Covers different methods of replication, as well as troubleshooting and fine tuning SQL tools Written by a Microsoft Certified Professional for SQL Server

Autorentext

Sujoy Paul is a results-oriented database and software professional with extensive experience in different relational database management systems like MS SQL Server 2000, Sybase ASA, and Sybase ASE, data modeling, case-based tools like PowerDesigner, and coding and testing in demanding hi-tech environments. Sujoy's background includes expertise in database replication, with special interest in two-way replication, backup and recovery, performance and tuning, and troubleshooting. Sujoy has a demonstrated ability to provide training for replication and Microsoft certifications on design and administration of SQL Server 2000. Sujoy is a Microsoft Certified Professional (installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition). He is the author or coauthor of dozens of technical papers, including ""Replicating SQL Server 2000 across Heterogeneous Databases"" (SQLTeam.com, August 2003).

Klappentext

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.

Inhalt

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.