Pro SQL Server 2005 Replication

by Sujoy Paul

Overview

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.

Product Details

ISBN-13:	9781484220283
Publisher:	Apress
Publication date:	04/30/2017
Edition description:	First Edition
Pages:	996
Product dimensions:	7.01(w) x 9.25(h) x (d)

About the Author

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).

Table of Contents

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.