sql2005培训资料09.ppt

Module 9: SQL Server 2005 Replication Overview Overview of Replication Enhancements New Types of Replication Configuring Replication Lesson: Overview of Replication Enhancements User Interface Enhancements Replication Management Performance and Scalability Replication Monitor Other Enhancements User Interface 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 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 Performance and Scalability Precomputed partitions Updates to unique keys Transactional parallelism — independent agent option used by default Download only articles — to reduce change tracking metadata Reduced contention on reporting subscribers Use snapshot isolation level Use snapshots Replication Monitor Independent from SQL Server Management Studio Passive monitoring Define acceptable performance figures Minimize monitoring impact Merge replication Article level statistics Upload and download statistics Transactional replication — real-time monitoring with tracer tokens Other Enhancements Merge replication concurrency enhancements — guaranteed delivery of logical records Programming changes — release of RMO Replication of more types of objects .NET UDTs Assemblies Lesson: New Types of Replication Heterogeneous Replication Peer-to-Peer Transactional Replication HTTP Replication Heterogeneous Replication Use Oracle v8 and later databases as the publisher in a replication system Snapshot replication — no impact on Oracle database Transactional replication Triggers and tracking tables added to Oracle database Log Reader Agent transfers changes to SQL Server Distributor