Pro SQL Server 2005 Replication

MS SQL Server 2005 distributes data to remote or mobile users by replication either over the Internet or over the local area network (LAN). Throughout this book I will focus on how the different types of replication can be used in distributing data and database objects. I will discuss the fundame...

Mô tả đầy đủ

Đã lưu trong:
Chi tiết về thư mục
Tác giả chính: P. Paul, Sujoy
Định dạng: Sách
Ngôn ngữ:English
Được phát hành: Apress 2012
Những chủ đề:
Truy cập trực tuyến:http://scholar.dlu.edu.vn/thuvienso/handle/DLU123456789/31643
Các nhãn: Thêm thẻ
Không có thẻ, Là người đầu tiên thẻ bản ghi này!
Thư viện lưu trữ: Thư viện Trường Đại học Đà Lạt
id oai:scholar.dlu.edu.vn:DLU123456789-31643
record_format dspace
spelling oai:scholar.dlu.edu.vn:DLU123456789-316432014-01-20T05:59:17Z Pro SQL Server 2005 Replication P. Paul, Sujoy Technologies MS SQL Server 2005 distributes data to remote or mobile users by replication either over the Internet or over the local area network (LAN). Throughout this book I will focus on how the different types of replication can be used in distributing data and database objects. I will discuss the fundamentals, the implementations, the architectures, and the topologies of repli- cation and demonstrate them with real-world examples. n CHAPTER 1 Introduction: Distributed Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 n CHAPTER 2 Replication Basics . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 n CHAPTER 3 Types of Replication . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 63 n CHAPTER 4 Configuring Snapshot Replication Using the GUI . . . . . . . . . . . . . . . . 89 n CHAPTER 5 Configuring Snapshot Replication Using T-SQL . . . . . . . . . . . . . . . . 133 n CHAPTER 6 Snapshot Generation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 161 n CHAPTER 7 Internals of Snapshot Replication . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 185 n CHAPTER 8 Configuring Transactional Replication Using the GUI . . . . . . . . . . . 251 n CHAPTER 9 Configuring Transactional Replication Using T-SQL . . . . . . . . . . . . 301 n CHAPTER 10 Internals of Transactional Replication . . . . . . . . . . . . . . . . . . . . . . . . . 357 n CHAPTER 11 Configuring Merge Replication Using the GUI . . . . . . . . . . . . . . . . . . 445 n CHAPTER 12 Web Synchronization with Merge Replication. . . . . . . . . . . . . . . . . . 491 n CHAPTER 13 Configuring Merge Replication Using T-SQL . . . . . . . . . . . . . . . . . . . 525 n CHAPTER 14 The Internals of Merge Replication . . . . . . . . . . . . . . . . . . . . . . . . . . . . 583 n CHAPTER 15 Backup and Recovery of Snapshot and Transactional Replication . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 651 n CHAPTER 16 Backup and Recovery of Merge Replication. . . . . . . . . . . . . . . . . . . . 715 n CHAPTER 17 Optimizing Snapshot Replication . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 759 n CHAPTER 18 Optimizing Transactional Replication . . . . . . . . . . . . . . . . . . . . . . . . . . 803 n CHAPTER 19 Optimizing Merge Replication . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 867 n CHAPTER 20 Heterogeneous Replication . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 903 n APPENDIX A E-R Diagram of the mysales Database. . . . . . . . . . . . . . . . . . . . . . . . . 943 n APPENDIX B SQL Code for the Database. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 947 n REFERENCES . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 959 n INDEX . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 961 2012-08-30T07:09:48Z 2012-08-30T07:09:48Z 2006 Book 13: 978-1-59059-650-0 http://scholar.dlu.edu.vn/thuvienso/handle/DLU123456789/31643 en application/pdf Apress
institution Thư viện Trường Đại học Đà Lạt
collection Thư viện số
language English
topic Technologies
spellingShingle Technologies
P. Paul, Sujoy
Pro SQL Server 2005 Replication
description MS SQL Server 2005 distributes data to remote or mobile users by replication either over the Internet or over the local area network (LAN). Throughout this book I will focus on how the different types of replication can be used in distributing data and database objects. I will discuss the fundamentals, the implementations, the architectures, and the topologies of repli- cation and demonstrate them with real-world examples.
format Book
author P. Paul, Sujoy
author_facet P. Paul, Sujoy
author_sort P. Paul, Sujoy
title Pro SQL Server 2005 Replication
title_short Pro SQL Server 2005 Replication
title_full Pro SQL Server 2005 Replication
title_fullStr Pro SQL Server 2005 Replication
title_full_unstemmed Pro SQL Server 2005 Replication
title_sort pro sql server 2005 replication
publisher Apress
publishDate 2012
url http://scholar.dlu.edu.vn/thuvienso/handle/DLU123456789/31643
_version_ 1757661704958771200