After completing SQL Server 7 Admin: Replication Plans the user should be able to:

	Design an appropriate replication model
	Choose a replication type
	Select an appropriate subscription model and type
	Evaluate data type requirements

Choosing a Replication Model

	Central publisher/distributor model
	Central subscriber/multiple publisher model
	Multiple publisher/multiple subscriber model

Additional Options

	Using a remote distribution server
	Push and pull subscriptions

Choosing a Replication Type

	Snapshot replication
	Transactional replication
	Merge replication

Designing and Planning Replication

	Deciding what data to publish
	Deciding who receives the data and how often
	Considering physical network characteristics

Data Definition Considerations

	Use of data types
	Using an IDENTITY property
	Using the NOT FOR REPLICATION option

This course has the following features:

	Exercises that allow users to practice the skills needed to develop a replication plan for SQL Server 7.0
	A file containing the text of the exercises
	Activities that allow users to apply concepts in an interactive questioning environment
	A glossary
	A Skill Assessment

	Courses on Relational Database Management Systems or equivalent experience
	Courses on Windows NT administration or equivalent experience
	Courses on Database Concepts or equivalent experience
	Courses on SQL or equivalent experience
	SQL Server 7 Admin: Security Strategy (LA7C01)
	SQL Server 7 Admin: System Requirements (LA7C02)
	SQL Server 7 Admin: Migration Planning (LA7C03)

Microsoft® is a registered trademark of Microsoft Corporation.