After completing SQL Server 7 Admin: Migration Planning the user should be able to:

	Plan an upgrade from a previous version of Microsoft SQL Server
	Plan the migration of data from other data sources
	Determine hardware and software requirements for migration
	Use the Upgrade Wizard
	Use the Import Wizard

Planning an Upgrade

	Planning a SQL Server Upgrade
	Hardware and software requirements for upgrading
	Planning related to the upgrade method
	Estimating disk space for upgrading
	Estimating disk space with the Wizard

Upgrade Method and Upgrade Wizard

	Steps required for upgrading
	Selecting a data transferal method
	What the Upgrade Wizard does
	Wizard options and settings

Migration Issues

	Version considerations
	Data and database configuration issues
	Verifying upgraded databases
	Upgrading servers in replication

Migrating Data from Other Sources

	Migrating from an RDBMS or mainframe
	Migrating data using the DTS utility
	Migrating data using the BCP utility

Using the Import Wizard

	Getting started using the Import Wizard
	Selecting basic Import Wizard options
	Selecting table and column options
	Selecting save and schedule options
	Summary of migrating from other sources

This course has the following features:

	Exercises that allow users to practice the skills needed to develop a migration 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)

Microsoft® is a registered trademark of Microsoft Corporation.