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:- 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
dbms/mssql/edu/maintain_sql2005/module8.txt · 마지막으로 수정됨: 저자 gauryan