Course Outline
Module 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
-
Overview
-
Executing Upgrade Advisor
-
Fixing Upgrade Issues
-
Performing Pre-Upgrade Tasks
-
Performing the Version Upgrade
Module 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 : Upgrading a Relational Database by Using the Copy Database Wizard
-
Backing Up the Source Database and Reviewing Instance-Level Objects
Lab : Upgrading a Relational Database by Using the Copy Database Wizard
-
Using the Copy Database Wizard
-
Reviewing the Copy Database Wizard Package
Module 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
-
Overview
-
Scenario
-
Reviewing the Server Environment
-
Upgrading a Clustered SQL Server 2000 Database by Using the Detach and Attach Method
-
Performing Post-Installation Tasks
Module 4: 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
-
Overview
-
Performing an In-Place Upgrade to Reporting Services 2005
-
Performing a Side-by-Side Upgrade to Reporting Services 2005
-
Upgrading Reports to Reporting Services 2005
-
Preparing for Report Builder Use
Module 5: 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
-
Overview
-
Performing an In-Place Upgrade of DTS
-
Working with DTS Packages by Using SQL Server 2005
-
Migrating DTS Packages to SSIS
Module 6: 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
-
Overview
-
Performing an In-Place Upgrade to Analysis Services 2005
-
Performing a Side-by-Side Upgrade to Analysis Services 2005
-
Modifying a Migrated Analysis Services Database
Module 7: 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
-
Executing Upgrade Advisor
-
Fixing Upgrade Issues
|