You are in Training / Microsoft / SQL Server / Course MS7031 / Course Outline

MS7031 Upgrading to Microsoft SQL Server 2005

Module 1: Feature Comparison (Day 1-3 PowerPoint Deck)

In this module, students will learn about key feature differentiators between the SQL Server 2005 Express. Workgroup, Standard and Enterprise editions.

Lessons

	Introducing SQL Server 2005 Packaging & Pricing
	Scale
	HA/Engine
	HA/Engine (2)
	Management Tools
	Replication
	Analysis Services
	Data Mining
	Reporting Services
	Integration Services
	Notification Services

Module 2: Upgrade Technical Resource Guide (Day 1-4 PowerPoint Deck)

This module examines the various upgrade scenarios and answers questions on why to upgrade.

Lessons

	Why Upgrade to SQL Server 2005
	Upgrade Planning and Deployment
	Enterprise Systems Upgrade Issues
	Relational Database Upgrade Scenarios
	Business Intelligence Upgrade Scenarios

Lab

Module 3: Upgrading to SQL Server 2005 Express Edition (Day 1-5 PowerPoint Deck)

This module examine how to upgrade SQL Server 2005 Express Edition.

Lessons

	SQL Server 2005 Express Edition
	Product Release Plan
	Usage Scenarios
	Top 10 Reasons for Upgrading
	Licensing
	Features Comparison
	Upgrading from MSDE 2000
	Demo
	Deploying Express
	Common Issues
	Upgrading to other SQL Server 2005 Editions

Lab

Module 4: Upgrading SQL Server 7.0 to SQL Server 2005 (Day 1-7 PowerPoint Deck)

This module describes how to upgrade from SQL Server 7.0 to SQL Server 2005.

Lessons

	Server Requirements for Upgrading SQL Server 7.0
	Upgrade Paths from SQL Server 7.0 to 2005
	SQL 7.0 Upgrade known issues

Lab

Module 5: Planning Considerations for Upgrading to SQL Server 2005 (Day 2-2 PowerPoint Deck)

This module explains the various considerations to take into account when upgrading to SQL Server 2005.

Lessons

	Definitions
	What can be upgraded
	How to upgrade
	Upgrade Planning
	Pre-upgrade
	Upgrade Execution
	Post-upgrade
	In-place Upgrade vs. Migration
	Upgrading Log Shipping
	Upgrade Tips and Tricks

Lab

Module 6: Upgrading the Database Engine (Day 2-3 PowerPoint Deck)

This module shows students how to upgrade the database engine.

Lessons

	Upgrading the Database Engine
	Instances and Directory Structures
	Resource Database
	System Tables / Metadata
	Backwards Compatibility
	New Features in the Database Engine
	Transparent Benefits of Upgrading to SQL Server 2005

Lab

Module 7: Native Client Upgrade Overview (Day 2-4 PowerPoint Deck)

This module covers how to upgrade the database client applications.

Lessons

	Client connectivity options
	SQL Native Client or MDAC?
	Upgrade process
	Demo - MARS
	Upgrade issues
	Using ADO with SQL Native Client
	Backwards compatibility
	Design considerations

Lab

Module 8: System.Data and SQL Server 2005 Upgrade Overview (Day 2-5 PowerPoint Deck)

This module explains how to include System.Data as part of an upgrade plan.

Lessons

	What's new in System.Data
	Upgrade Matrix and Issues
	Client – 1.1 / Server – Upgraded to SQL Server 2005
	Client – Upgraded to 2.0 / Server – SQL 2000
	Client – Upgraded to 2.0 / Server – Upgraded to SQL Server 2005
	Overall Backwards Compatibility

Lab

Module 9: SQL Server 2005 Database Upgrade Test Toolkit (Day 2-6 PowerPoint Deck)

This module covers the database upgrade test toolkit and how it can be used to simulate the performance/workloads of older versions of SQL Server in the new SQL Server environment.

Lessons

	Playback Testing
	SQL Server 2005 Application Compatibility Labs
	SQL Server 2005 Database Upgrade Test Toolkit

Lab

Module 10: Analysis Services 2005 Overview (Day 3-2 PowerPoint Deck)

This module reviews SQL Server Analysis Services 2005.

Lessons

	Analysis Services Overview
	Data Mining Algorithms
	The UDM – Key Features
	Advanced Analytics:Data Mining – A complete and competitive offering
	Mission Critical BI

Lab

Module 11: Upgrading to SQL Server 2005 Analysis Services (Day 3-3 PowerPoint Deck)

This module explains how to upgrade Analysis Services.

Lessons

	Three options for moving to AS2005
	Upgrade (in place)
	Migration (side by side)
	Redesign
	For each option we will cover:
	Techniques
	Pros
	Cons
	Upgrade Advisor
	Upgrade Verification Tool
	Known Backward Compatibility Issues
	Upgrading Client Applications

Lab

Module 12: Getting the Most out of Project REAL (Day 3-4 PowerPoint Deck)

This module reviews Project REAL and how it can be used as resources.

Lessons

	Overview of Project REAL
	Contents of the Reference Implementation
	Installing the Reference Implementation
	A tour of the Reference Implementation
	Relational Data Warehouse
	ETL using Integration Services
	Analysis Services cubes
	Reports in Reporting Services

Lab

Module 13: SQL Server Integration Services (SSIS) Overview (Day 4-2 PowerPoint Deck)

This module provides an overview of SQL Server 2005 Integration Services.

Lessons

	Integration Services Overview
	How Integration Services Works
	Precedence constraints in control flow (work flow)
	Life Cycle tools
	Package Configurations
	Overview of Integration Services Security
	Deploying Integration Services Packages

Lab

Module 14: From SQL Server 2000 DTS to SQL Server 2005 SSIS: Upgrade and Migration (Day 4-3 PowerPoint Deck)

This module explains the migration story for SSIS 2005, describes tools and practices for migration and provide guidance for current engagements.

Lessons

	From DTS to SSIS
	Upgrade Experience
	Support for Migration
	Migrating Packages
	Guidance for DTS Users

Lab

Module 15: Introducing Microsoft SQL Server 2005 Reporting Services (Day 4-4 PowerPoint Deck)

This module provides and overview of SQL Server 2005 Reporting Services.

Lessons

What is SQL Server Reporting Services?

Lab

Module 16: SQL Server 2005 Reporting Services Upgrade (Day 4-5 PowerPoint Deck)

This module explains how to setup and deploy Reporting Services and determine the appropriate upgrade and migration paths for Reporting Services.

Lessons

	Overview of RS – short, to the point
	Review setup in RS 2000 vs. setup in RS 2005
	Review of deployment scenarios
	Goals of upgrade
	Process of upgrade – what happens, when
	Migrating Report Server

Lab


Register
	Register for the next course (MS7031) in: Calgary
	Schedule dedicated, customized or on-site training
	Contact a Training Expert