Author(s) : Sujoy P. Paul
Publisher : Apress
Year : Dec 2006
ISBN-10 : 1590596501
ISBN-13 : 9781590596500
Language : English
Pages : 1016
File type : PDF
Size : 53.7 MB (book + source code)
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 youre a novice or advanced replication user.
TABLE OF CONTENT:
CHAPTER 01 - Introduction
CHAPTER 02 - Replication Basics
CHAPTER 03 - Types of Replication
CHAPTER 04 - Configuring Snapshot Replication Using the GUI
CHAPTER 05 - Configuring Snapshot Replication Using T-SQL
CHAPTER 06 - Snapshot Generation
CHAPTER 07 - Internals of Snapshot Replication
CHAPTER 08 - Configuring Transactional Replication Using the GUI
CHAPTER 09 - Configuring Transactional Replication Using T-SQL
CHAPTER 10 - Internals of Transactional Replication
CHAPTER 11 - Configuring Merge Replication Using the GUI
CHAPTER 12 - Web Synchronization with Merge Replication
CHAPTER 13 - Configuring Merge Replication Using T-SQL
CHAPTER 14 - The Internals of Merge Replication
CHAPTER 15 - Backup and Recovery of Snapshot and Transactional Replication
CHAPTER 16 - Backup and Recovery of Merge Replication
CHAPTER 17 - Optimizing Snapshot Replication
CHAPTER 18 - Optimizing Transactional Replication
CHAPTER 19 - Optimizing Merge Replication
CHAPTER 20 - Heterogeneous Replication
APPENDIX A - E-R Diagram of the mysales Database
APPENDIX B - SQL Code for the Database
Download from Rapidshare
or
Download from Mihd
password:ganelon