50007A: Upgrade to SQL Server 2005 Bootcamp
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.
Audience
This course is intended for IT professionals
At Course Completion
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.