Upgrade to SQL 2005 Bootcamp

Code: 50007
Course duration: 5 days
Price:

50007:Upgrade to SQL Server 2005 Bootcamp

About this Course:

This five-day instructor-led course teaches database professionals working in enterprise environments how to upgrade to SQL Server 2005.

Audience Profile

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.

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
  • 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
Before attending this course, students must have:
  • Basic knowledge of SQL Server 2005
 

Course Reviews

No reviews found for this course.

Be the first to write a review