Audience

IT professionals including database administrators, application developers, independent software vendors, IS managers, system integrators, and Internet consultants who want to plan, deploy, configure, administer, and troubleshoot SQL Server 7.0

Prerequisites

Experience of configuration and administration of Windows NT, familiarity with the Windows 95 or Windows NT user interface, familiarity with managing end-user accounts in an NT environment, knowledge of SQL or Transact-SQL, and an understanding of the role of a database administrator

Course Aim

To enable students to successfully configure, implement, and troubleshoot replication with SQL Server 7.0

Learning Objectives

Explain what replication is and identify the types available with SQL Server 7.0. Identify SQL Server 7.0?s replication tools and components. Detail how merge, snapshot, and transactional replication work. Describe the replication strategies that can be catered for using SQL Server 7.0. Point out some of the planning issues concerning SQL Server 7.0 replication. Demonstrate how to configure a publisher. Show how to configure, implement, and verify merge, snapshot, and transactional replication. Outline how to manage, monitor, and troubleshoot replication.

Topics Covered

Replication overview - Data replication - Components - Tools Replication types - Merge replication - Snapshot replication - Transactional replication - Advanced replication - Replication strategies - Hands-on: Choosing a strategy The replication process - Planning replication - Enabling a distributor - Hands-on: Configuring a distributor - Implementing merge replication - Configuring a subscriber Configuring replication - Comparing replication types - Pulling a subscription - Hands-on: Configuring snapshot replication Monitoring and troubleshooting - Operating and tracking replication - Hands-on: Managing and monitoring replication - Troubleshooting replication

| About Eno.com | Security&Privacy | Contact Us |
Copyright © 1998-2001 E&A Inc.. All rights reserved.