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 youare a novice or advanced replication user.... formulations of transactions, see aThe Dangers of Replication and a Solution, a by J. Gray, P. Helland, P. Oa#39;Neil, D.Sasha. ... For example, auto repair shops need to have real-time data about inventory in their ... Sales people working in the field can enter their orders or changes once the transactions are complete.
|Title||:||Pro SQL Server 2005 Replication|
|Publisher||:||Apress - 2006-12-17|