Pro SQL Server 2008 Replication

Pro SQL Server 2008 Replication

5.0 1
by Sujoy Paul
     
 

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

Overview

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 real–life scenarios
  • Covers replication with database mirroring and troubleshooting
  • Discusses replication administration using different tools


Table of Contents

  1. Introduction
  2. Replication Basics
  3. Types of Replication
  4. Configuring Snapshot Replication Using the GUI
  5. Configuring Snapshot Replication Using T-SQL
  6. Snapshot Generation
  7. Internals of Snapshot Replication
  8. Configuring Transactional Replication Using the GUI
  9. Configuring Transactional Replication Using T-SQL
  10. Internals of Transactional Replication
  11. Configuring Merge Replication Using the GUI
  12. Web Synchronization with Merge Replication
  13. Configuring Merge Replication Using T-SQL
  14. The Internals of Merge Replication
  15. Backup and Recovery of Snapshot and Transactional Replication
  16. Backup and Recovery of Merge Replication
  17. Optimizing Snapshot Replication
  18. Optimizing Transactional Replication
  19. Optimizing Merge Replication
  20. Heterogeneous Replication


Product Details

ISBN-13:
9781430218074
Publisher:
Apress
Publication date:
06/20/2009
Edition description:
2009
Pages:
936
Product dimensions:
7.00(w) x 9.20(h) x 1.90(d)

Related Subjects

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

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >

Pro SQL Server 2008 Replication 5 out of 5 based on 0 ratings. 1 reviews.
aleksandar30 More than 1 year ago
I would recommend this book not only to experienced developers/administrators, but also to developers new to the database replication. As this book covers wide range of topics (different replication types, replication administration, optimization and tuning, troubleshooting techniques), experienced developers can use it as a reference in their everyday work. For beginners this book will be very good study material. I will give this book a 5 star.