adminschool.net wiki

사용자 도구

사이트 도구

추적: • module8
dbms:mssql:edu:maintain_sql2005:module8

목차

Lesson 1: Overview of Replication

What Is Replication?

  • Bring data closer to users
  • Site autonomy
  • Reduce locking confickts

Server Roles in Replication

  • Publisher
  • Distributor
  • Subscriber

Types of Replication

  • Snapshot replication
    • Sends all of the data
  • Transactional replication
    • Sends modifications of the data
  • Merge replication
    • Modifications at both the publisher and subscribers
  • Heterogeneous replication
    • Replicate data between SQL Server and other database products

What Are Articles, Publications, and Subscriptions?

  • Articles
  • Publications
  • Subscriptions

What Are Replication Agents?

  • Types of replication agents
    • Snapshot Agent
    • Log Reader Agent
    • Queue Reader Agent
    • Distribution Agent
    • Merge Agent

Lesson 2: Implementing Replication

How to Create a Publication

  • Using the New Publication wizard
    Required infomations:
    1. Distributor
    2. Snapshot folder
    3. Publication database
    4. Publication type
    5. Subscriber types
    6. Articles
    7. Filters
    8. Snapshot Agent
    9. Security settings
    10. Publication name
  • Using the replication stored procedures

How to Create a Subscription

  • Push and pull subscriptions
  • Using the New Subscription wizard
    Requied information:
    1. Publication
    2. Agent location
    3. Subscribers, databases
    4. Security settings
    5. Synchronization
    6. Replicaing changes
    7. Initialization
    8. Subscription type
  • Using the replication stored procedures

Managing and Monitoring Replication

  • Monitoring replication by using Replication Monitor
  • Validaing and reinitializing subscriptions
  • Managing replication agents
  • Resolving replication conflicts

Lesson 3: Configuring Replication in Some Common Scenarios

Server-to-Server Replication Scenarios

  • Integrating data from multiple sites
  • Integrating heterogeneous data
  • Offloading batch processing
  • Data warehousing and reporting
  • Improving scalability and availability

Server-to-Client Replication Scenarios

  • Exchanging data with mobile users
  • Consumer point of sale(POS) applications
  • Integraing data from multiple sites

HTTP Merge Replication

  • Configuring HTTP Merge Replication
    • Cteate a Merge publication
    • Install and configure IIS
    • Configure Web synchronization
    • Test the WebSync ISAPI extension
    • Enable Web synchronization
  • Subscribing to an HTTP Merge Publication
  • Import client certificate for Merge Agent
  • Use Web synchronization
  • Connect to the Web synchronization URL

Peer-to-Peer Replication

  • How peer-to-peer replication works
  • Configuring peer-to-peer replication

Oracle Publishing

  • How Oracle Publishing works
  • Considerations for using Oracle Publishing
  • Configuring Oracle Publishing
  • Subscribing to an Oracle publication
dbms/mssql/edu/maintain_sql2005/module8.txt · 마지막으로 수정됨: 2008/05/22 15:09 저자 gauryan

문서 도구

별도로 명시하지 않을 경우, 이 위키의 내용은 다음 라이선스에 따라 사용할 수 있습니다: CC Attribution-Share Alike 4.0 International
CC Attribution-Share Alike 4.0 International Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki