50007A: Upgrade to SQL Server 2005 Bootcamp
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
• Overview
• Executing Upgrade Advisor
• Fixing Upgrade Issues
• Performing Pre-Upgrade Tasks
• Performing the Version Upgrade
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
• Overview
Lab 2A: Upgrading a Relational Database by Using the Copy Database Wizard
• Backing Up the Source Database and Reviewing Instance-Level Objects
Lab 2B: Upgrading a Relational Database by Using the Copy Database Wizard
• Using the Copy Database Wizard
• Reviewing the Copy Database Wizard Package
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
• Overview
• Scenario
• Reviewing the Server Environment
• Upgrading a Clustered SQL Server 2000 Database by Using the Detach and Attach Method
• Performing Post-Installation Tasks
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
• 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
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
• Overview
• Performing an In-Place Upgrade of DTS
• Working with DTS Packages by Using SQL Server 2005
• Migrating DTS Packages to SSIS
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
• 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
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
• Executing Upgrade Advisor
• Fixing Upgrade Issues