Course 50007A: Five days; Instructor-Led

On This Page

	Introduction
	Audience
	At Course Completion
	Prerequisites
	Course Outline
	Take This Training

Introduction

Elements of this syllabus are subject to change.

This five-day instructor-led course teaches database professionals working in enterprise environments how to upgrade to SQL Server 2005.

Top of page

Audience

This course is intended for IT professionals

Top of page

At Course Completion

After completing this course, students will be able to:

Top of page

Prerequisites

Before attending this course, students must have:

Top of page

Course Outline

Relational Engine Lab 1: Performing an In-Place Upgrade of a SQL Server 2000 Relational Database Environment

This module explains how to upgrade a SQL Server 2000 relational database by performing an in-place version upgrade of the relational database engine and all of its databases.

Lessons

Relational Engine Lab 2: Performing a Side-by-Side Upgrade of a SQL Server 2000 Relational Database Environment

This module explains how to upgrade a SQL Server 2000 database to SQL Server 2005 by using two different side-by-side upgrade methods.

Lessons

Lab 2A: Upgrading a Relational Database by Using the Copy Database Wizard

Lab 2B: Upgrading a Relational Database by Using the Copy Database Wizard

Relational Engine Lab 3: Upgrading a Clustered SQL Server 2000 Environment by Using the Detach and Attach Method

This module explains how to upgrade a clustered SQL Server 2000 database to a new SQL Server 2005 instance by using the detach and attach method.

Lessons

Business Intelligence Lab 1: Upgrading Reporting Services

This module explains how to perform upgrades of Reporting Services 2000 to Reporting Services 2005 by using two different upgrade methods.

Lessons

Business Intelligence Lab 2: Migrating DTS to Integration Services

This module explains how to perform migrations of SQL Server 2000 Data Transformation Services (DTS) packages and functionality to SQL Server 2005 Integration Services (SSIS).

Lessons

Business Intelligence Lab 3: Upgrading Analysis Services

This module explains how to perform upgrades of Analysis Services 2000 to Analysis Services 2005 using two different upgrade methods: an in-place upgrade and a side-by-side upgrade.

Lessons

Demo: Upgrading SQL Server 7.0 to SQL Server 2005

This module explains how to execute Microsoft SQL Server 2005 Upgrade Advisor against a SQL Server 7.0 server to obtain information about possible upgrade issues, review the generated report, and then fix upgrade issues.

Lessons

Top of page