50007 - Upgrade to SQL Server 2005 Bootcamp |
|
|---|---|
| Course Code: | 50007 |
| Course Duration: | 5 days |
| Course Price: | 3400.00 |
| Availability: | |
After completing this course, students will be able to:
• Provide an in-place upgrade of a SQL Server 200 relational database
• Prove a side-by-side upgrade of a SQL Server relational database environment
• Use the detach and attach method to upgrade a clustered SQL Server 2000 environment
• Upgrade Reporting Services 2000 to Reporting Services 2005
• Perform migrations of SQL Server 2000 Data Transformation Services (DTS) packages and functionality to SQL Server
• 2005 Integration Services (SSIS)
• Perform upgrades of Analysis Services 2000 to Analysis Services 2005 using two different upgrade methods
• Execute Microsoft SQL Server 2005 Upgrade Advisor against a SQL Server 7.0 server
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
• Overview
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
This course is intended for IT professionals who want to learn how to upgrade to SQL Server 2005.
Before attending this course, students must have:
• Basic knowledge of SQL Server 2005