Implementing Replication Using Microsoft SQL Server 2000

Target Audience
This course is intended for experienced database administrators and system architects who want to improve their skills and the replication capabilities of their systems. Students should be proficient in the design and administration of SQL Server 2000 systems

Pre-Requisites
Before attending this course, students must have the following pre-requisites:Course 2071, Querying Microsoft SQL Server 2000 with Transact-SQL, or equivalent knowledge.Course 2072, Administering a Microsoft SQL Server 2000 Database,or equivalent knowledge.Knowledge of Microsoft Windows 2000 basics.Knowledge of Windows networking fundamentalsIn addition, it is recommended, but not required, that students have completed, or have equivalent knowledge of:Course 2073, Programming a Microsoft SQL Server 2000 Database.

Purpose
After completing this course, students will be able to describe replication, implement replication, implement snapshot replication, implement transactional replication, implement merge replication, implement replication in an Enterprise environment

Course outline

1. Exploring Replication
2. Implementing Replication
3. Implementing Snapshot Replication
4. Implementing Transactional Replication
5. Implementing Merge Replication Systems
6. Implementing SQL Server Replication in an Enterprise Environment

Module 1:Exploring Replication

• Understanding SQL Server Replication
• Setting up Replication
• Understanding Agents in Replication
• Securing Replication

• Define replication.
  
• Set up replication.
  
• Describe the functions of replication agents.
  
• Secure replication.
  

Module 2:Implementing Replication

• Understanding the SQL Server Platform for Replication
• Replicating Data and Objects
• Replicating and Executing Objects
• Designing a Replication Topology
• Troubleshooting a Replication Implementation
• Lab:
• Implementing Replication

• Describe the SQL Server platform for replication.
  
• Replicate data and objects.
  
• Replicate and execute objects.
  
• Design the best replication type for a given business problem.
  
• Monitor, troubleshoot, and tune replication.
  

Module 3:Implementing Snapshot Replication

• Understanding Snapshot Replication Architecture
• Replicating Snapshot Publications Efficiently
• Troubleshooting Snapshot Replication
• Lab:
• Using Snapshot Replication with Custom Properties

• Describe the architecture of snapshot replication.
  
• Replicate snapshot publications efficiently.
  
• Troubleshoot snapshot replication.
  

Module 4:Implementing Transactional Replication

• Understanding Transactional Replication Architecture
• Replicating with Transactional Replication
• Implementing Updatable Transactional Replication
• Facilitating Transactional Replication by Using Stored Procedures
• Troubleshooting Transactional Replication
• Tuning Transactional Replication
• Lab:
• Implementing Transactional Replication

• Describe transactional replication.
  
• Replicate with transactional replication.
  
• Implement updatable transactional replication.
  
• Facilitate transactional replication using stored procedures.
  
• Troubleshoot transactional replication.
  
• Tune transactional replication.
  

Module 5:Implementing Merge Replication Systems

• Understanding Merge Replication Architecture
• Implementing Conflict Resolution
• Planning and Deploying Merge Replication
• Troubleshooting Merge Replication
• Tuning Merge Replication
• Lab:
• Implementing Merge Replication

• Describe the architecture of merge replication.
  
• Implement conflict resolution.
  
• Plan and deploy merge replication.
  
• Troubleshoot merge replication.
  
• Tune merge replication.
  

Module 6:Implementing SQL Server Replication in an Enterprise Environment

• Planning for Disaster Recovery in a Replicated Environment
• Upgrading and Applying Service Packs in a Replicated Environment
• Understanding Enterprise Options in a Replicated Environment
• Understanding Replication with Heterogeneous Database Systems.

• Plan disaster recovery for replication.
  
• Upgrade and apply service packs in a replicated environment.
  
• Understand key options concerning replication in some enterprise environments.
  
• Understand replication with heterogeneous database systems