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.
|Edition description:||Softcover reprint of the original 1st ed.|
|Product dimensions:||7.01(w) x 9.25(h) x (d)|
About the Author
Table of ContentsA table of contents is not available for this title.
Most Helpful Customer Reviews
This book helps in developing a replication system for those who will implement it and needs a complete reference to be used as a guide. It has a lot of detailed information for beginners but certainly covers intermediate and senior levels questions. Excellent reference to check any step you may not miss, with screen pictures, explanations of why we¿d need to perform such action. Another valuable point found in the book is: the tips, the cautions and the notes that we easily understand that certainly it¿s a plus for the chapter and the subject. With so many replication system options that we have, the author included a chapter that covers heterogeneous environments. The information available in the book is very clear, organized, consistent and very well presented. Regarding the transactional replication, the author wasn¿t only worried in showing how to configure using GUI or T-SQL, he also released a whole chapter explaining the internals which is extremely good for those technicians who want to troubleshoot and also autonomy to manage and understand the transactional environment. I strong recommend the book for the tech crew from beginners in replication systems to seniors who want to review their knowledge and possibly apply new rep strategy. I also would like to see a chapter about troubleshooting.
Pro SQL Server 2005 Replication has extensive material that explains from start to end complete database replication.Author Sujoy has done a good job touching all the new concepts in SQL Server 2005. The book is a good learning and implemented material that has all the easy to implement topics to troubleshoot any replication errors. Chapter 1 has very good introduction about Distributed data. Replication basics and types of replication provides detailed information and it helps to educate the user. Chapter 4 and chapter 5 which explains aout snapshot replication using GUI and T-SQL covered sqlserver 2005 new GUI. Chapter 8 and 9 has covered transactional replication using the GUI and T-SQL.The internals of Transaction replication is well explained with author's experiece and it has good introductory about internals of transactional replication. The web synchornization with merge replication and configuring merge replication using t-sql is very hands on sql. Backup and Recovery of merge replication is a very good added resoruce for DBAs to developers.Optimization is one very importnat cocepts that has been handled well. on overall,I recommend this book to software professional from starters to sernior programmers who use SQL Server and other database products.