MS7031 Upgrading to Microsoft SQL Server 2005

Experienced database professionals who will be responsible for upgrading to SQL Server 2005. The target students for this non-MOC course already have an understanding of how to use the SQL Server 2000 and SQL Server 2005 and understand the new features and capabilities of SQL Server 2005.

This course does not form part of the Microsoft Office Curriculum (MOC).

To teach database professionals working in enterprise environments how to upgrade to SQL Server 2005.

Before attending this non-MOC course, students must have experience of:

• SQL Server 2000
 
• SQL Server 2005 and a comprehensive understanding of all the new features and technologies
 
• The relational engine
 
• Storage engine
 
• Integration Services
 
• Analysis Services
 
• Reporting Services
 
• SQL Server 2005 features, tools, and technologies.

Module 1: Feature Comparison  

Module 2: Upgrade Technical Resource Guide

Module 3: Upgrading to SQL Server 2005 Express Edition

Module 4: Upgrading SQL Server 7.0 to SQL Server 2005

Module 5: Planning Considerations for Upgrading to SQL Server 2005

Module 6: Upgrading the Database Engine

Module 7: Native Client Upgrade Overview

Module 8: System.Data and SQL Server 2005 Upgrade Overview

Module 9: SQL Server 2005 Database Upgrade Test Toolkit

Module 10: Analysis Services 2005 Overview

Module 11: Upgrading to SQL Server 2005 Analysis Services

Module 12: Getting the Most out of Project REAL

Module 13: SQL Server Integration Services (SSIS) Overview

Module 14: From SQL Server 2000 DTS to SQL Server 2005 SSIS: Upgrade and Migration

Module 15: Introducing Microsoft SQL Server 2005 Reporting Services

Module 16: SQL Server 2005 Reporting Services Upgrade