SQL Server 2005 Replication(英文版)
合集下载
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
Module 9: SQL Server 2005
Replication
Overview
Overview of Replication Enhancements New Types of Replication Configuring Replication
Lesson: Overview of Replication Enhancements
Replication wizards 40% fewer pages Improved default values and auto-detection Less branching
New Subscription Wizard Replaces the Push Subscription Wizard and Pull Subscription Wizard Allows you to define multiple subscriptions with different properties at the same time
.NET UDTs Assemblies
Lesson: New Types of Replication
Heterogeneous Replication Peer-to-Peer Transactional Replication HTTP Replication
Heterogeneous Replication
metadata Reduced contention on reporting subscribers
Use snapshot isolation level Use snapshots
Replication Monitor
Independent from SQL Server Management Studio Passive monitorge replication concurrency enhancements — guaranteed delivery of logical records
Programming changes — release of RMO Replication of more types of objects
Differences between SQL Server and Oracle Use of Oracle tools
Peer-to-Peer Transactional Replication
London
Distribution Agent
Log Reader Agent
Sydney
Triggers and tracking tables added to Oracle database Log Reader Agent transfers changes to SQL Server Distributor
and Distribution Agent transfers changes to subscribers Potential issues because of:
Distribution Agent
Log Reader Agent
New York
Distribution Agent
Log Reader Agent
HTTP Replication
XML over HTTP/HTTPS
Binary over TCP/IP
Subscriber
Firewall
IIS
Use Oracle v8 and later databases as the publisher in a replication system
Snapshot replication — no impact on Oracle database Transactional replication
Define acceptable performance figures Minimize monitoring impact Merge replication
Article level statistics Upload and download statistics Transactional replication — real-time monitoring with tracer tokens
Performance and Scalability
Precomputed partitions Updates to unique keys Transactional parallelism — independent agent option
used by default Download only articles — to reduce change tracking
User Interface Enhancements Replication Management Performance and Scalability Replication Monitor Other Enhancements
User Interface Enhancements
Replication Management
Initializing a subscriber Backup and restore Copying a database Dynamic snapshots
Resuming snapshot transfers Replicating DDL statements Allowing anonymous subscriptions for all publications
Publisher
https://
Replication
Overview
Overview of Replication Enhancements New Types of Replication Configuring Replication
Lesson: Overview of Replication Enhancements
Replication wizards 40% fewer pages Improved default values and auto-detection Less branching
New Subscription Wizard Replaces the Push Subscription Wizard and Pull Subscription Wizard Allows you to define multiple subscriptions with different properties at the same time
.NET UDTs Assemblies
Lesson: New Types of Replication
Heterogeneous Replication Peer-to-Peer Transactional Replication HTTP Replication
Heterogeneous Replication
metadata Reduced contention on reporting subscribers
Use snapshot isolation level Use snapshots
Replication Monitor
Independent from SQL Server Management Studio Passive monitorge replication concurrency enhancements — guaranteed delivery of logical records
Programming changes — release of RMO Replication of more types of objects
Differences between SQL Server and Oracle Use of Oracle tools
Peer-to-Peer Transactional Replication
London
Distribution Agent
Log Reader Agent
Sydney
Triggers and tracking tables added to Oracle database Log Reader Agent transfers changes to SQL Server Distributor
and Distribution Agent transfers changes to subscribers Potential issues because of:
Distribution Agent
Log Reader Agent
New York
Distribution Agent
Log Reader Agent
HTTP Replication
XML over HTTP/HTTPS
Binary over TCP/IP
Subscriber
Firewall
IIS
Use Oracle v8 and later databases as the publisher in a replication system
Snapshot replication — no impact on Oracle database Transactional replication
Define acceptable performance figures Minimize monitoring impact Merge replication
Article level statistics Upload and download statistics Transactional replication — real-time monitoring with tracer tokens
Performance and Scalability
Precomputed partitions Updates to unique keys Transactional parallelism — independent agent option
used by default Download only articles — to reduce change tracking
User Interface Enhancements Replication Management Performance and Scalability Replication Monitor Other Enhancements
User Interface Enhancements
Replication Management
Initializing a subscriber Backup and restore Copying a database Dynamic snapshots
Resuming snapshot transfers Replicating DDL statements Allowing anonymous subscriptions for all publications
Publisher
https://