adminschool.net wiki

이 문서는 읽기 전용입니다. 원본을 볼 수는 있지만 바꿀 수는 없습니다. 문제가 있다고 생각하면 관리자에게 문의하세요.
====== 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:
    - Distributor
    - Snapshot folder
    - Publication database
    - Publication type
    - Subscriber types
    - Articles
    - Filters
    - Snapshot Agent
    - Security settings
    - Publication name
  * Using the replication stored procedures
    
===== How to Create a Subscription =====
  * Push and pull subscriptions
  * Using the New Subscription wizard \\ Requied information:
    - Publication
    - Agent location
    - Subscribers, databases
    - Security settings
    - Synchronization
    - Replicaing changes
    - Initialization
    - 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
adminschool.net wiki

사용자 도구

사이트 도구

문서 도구
