Pro SQL Server 2005 Replication

By Sujoy Paul

Book 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, and 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. 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.

• Format: Hardcover
• Language: English
• ISBN: 1590596501
• ISBN13: 9781590596500
• Release Date: December 2006
• Publisher: Apress
• Length: 996 Pages
• Weight: 3.95 lbs.
• Dimensions: 2.2" x 7.3" x 9.5"

Customer Reviews

a great help

I have never used any other SQL SERVER Replication books, so I can't compare it to anything else. I needed a book for reference as I set up a large scale SQL replication enviornment. I have done it in Oracle, and was experience with SQL 2005, but never SQL replication. This book gave me enough knowledge that I was able to accomplish some advanced replication. I highly recommend it for those, like me, that are new to SQL replication.

Great for a Novice

I have been involved in administering a database working on several geographically-separated servers. Initially, we've been using IPSec protocol for connections between the servers. To connect the clients, we've been using stunnel, which is easier to manage and to route. We were planning to stop using IPSec and moving to stunnel entirely. But I had no idea how to make Microsoft SQL Server 2005 to synchronize using stunnel. Microsoft had no ready-to-use solution for this. Thanks to this book, I have found the answer. Although this book does not explicitly state how to use stunnel, but it had enough clues to make me able to figure out the answer. For our company, this book was worth its price. Anyway, this book is for an entry-level administrator of the SQL Server 2005. It contains the most basic information, with lots of screenshots and explanations. This overall information is quite easy to understand. If you want something specific, for example a solution for a rare or a complicated problem, this book is not for you, you would better to go to a specified forum. But if you are a novice in replication, I highly recommend this book.

Novice to SQL Server and SQL Server replication in particular

Coming from mostly an Oracle background, I needed to come upto speed quickly to work on some replication projects. Paul's book was just what the doctor ordered. It provided clear and concise coverage of all the key topics especially peer-to peer replication and Merge replication which were essential reads in my case. I would recommend this book to SQL Server and other DB products users as well, who are looking to work on SQL Server replication projects.

A Very Good book on the subject

I found this book to be very usefull as it enables one to very quickly understand the concepts of replication and implement a solution quickly. This a comprehensive single source of information and there is no need to go through multiple manuals/books to design, implement and maintain replication solutions. The first three chapters cover the basics very well and comprehensively. I also found the presntation of each replication method in configuring and internals chapters to be extremely useful. This way I can easily set up and get my replication going by refering to the configuring chapter and if required I can refer to the internals chapter for advanced understanding. The screen shots are a bit difficult to read. I understand that increasing the size of the of the screen shots will increase the number of pages, however the book then could have been published in two volumes.

Very good but lacking in some areas.

I, like Mr. Griffith from Portland, had a need. The problem is that until June, this is the only book out there on replication for SQL Server 2005. I read the other reviews, and fiured that a book of nearly 1000 pages will include everything I need for replication. Not quite. But at the same time, Replication is a HUGE topic, and I am quickly finding out that even 1000 pages is not enough to cover everything you need to know about replication. That said, this book is very thorough on replication basics, meaning, the foundation of Replication and the information you need to know to get you up and running for the core components of Replication. Where this book lacks is the information needed to take readers beyond the basic/intermediate information. For example, how do you set up merge replication if the subscriber is outside of the firewall and not a member of the publisher domain? I haven't found that information in the book, but if it is in there, I'd really like to know. Yes, it is a lot of BOL screenshots and information, but the author does a great job organizing it. BOL can be very confusing sometimes and information can be hard to find, and this book does a great job organizing the information into easy-to-read (and find) topics. Overall, if you are new to replication, this is your book. Absolutely no doubt about that. But if you need beyond that, you might want to wait for the book coming out in June.