목차
Lesson 1: Overview of Replication
What Is Replication?
Server Roles in Replication
Types of Replication
What Are Articles, Publications, and Subscriptions?
What Are Replication Agents?
Lesson 2: Implementing Replication
How to Create a Publication
How to Create a Subscription
Managing and Monitoring Replication
Lesson 3: Configuring Replication in Some Common Scenarios
Server-to-Server Replication Scenarios
Server-to-Client Replication Scenarios
HTTP Merge Replication
Peer-to-Peer Replication
Oracle Publishing
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