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...
Đã lưu trong:
Tác giả chính: | |
---|---|
Đị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 |