1 / 18

Module 9: SQL Server 2005 Replication

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

elmer
Download Presentation

Module 9: SQL Server 2005 Replication

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Module 9: SQL Server 2005 Replication

  2. Overview • Overview of Replication Enhancements • New Types of Replication • Configuring Replication

  3. Lesson: Overview of Replication Enhancements • User Interface Enhancements • Replication Management • Performance and Scalability • Replication Monitor • Other Enhancements

  4. 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

  5. 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

  6. 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

  7. 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

  8. 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

  9. Lesson: New Types of Replication • Heterogeneous Replication • Peer-to-Peer Transactional Replication • HTTP Replication

  10. 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 and Distribution Agent transfers changes to subscribers • Potential issues because of: • Differences between SQL Server and Oracle • Use of Oracle tools

  11. New York New York Distribution Agent Distribution Agent Log Reader Agent Log Reader Agent Peer-to-Peer Transactional Replication London Sydney Distribution Agent Log Reader Agent Distribution Agent Log Reader Agent

  12. HTTP Replication Binary over TCP/IP XML over HTTP/HTTPS Subscriber Firewall IIS Publisher https://Repl.AdventureWorks.com

  13. Lesson: Configuring Replication • How to Configure Replication Using SQL Server Management Studio • How to Configure Replication Using RMO

  14. How to Configure Replication Using SQL Server Management Studio • Creating a publication — New Publication Wizard • Creating a subscription — New Subscription Wizard • Synchronizing a subscription

  15. Practice: Creating a Publication Using SQL Server Management Studio In this practice, you will see how to: • Start the New Publication Wizard • Configure a publication

  16. How to Configure Replication Using RMO 1 Reference the SMO and RMO libraries • Microsoft.SqlServer.ConnectionInfo • Microsoft.SqlServer.Replication Import the SMO and RMO namespaces Connect to the replications server(s) Perform replication tasks • Create publications • Create subscriptions 2 3 4 Imports Microsoft.SqlServer.Management.Common Imports Microsoft.SqlServer.Replication Dim subCon As ServerConnection subCon = New ServerConnection("MySubscriber") subCon.Connect()

  17. Practice: Creating a Subscription Using RMO In this practice, you will see how to create a subscription using RMO

  18. Course Evaluation

More Related