Upgrading to Microsoft SQL Server 2005
Course 7031: Five days; Instructor-led
Introduction
Elements of this syllabus are subject to change.
The purpose of this non-MOC 5-day instructor-led course is to teach database professionals working in enterprise environments how to upgrade to SQL Server 2005. Please note that because this is not official Microsoft Courseware, the following course outline follows the powerpoint slide decks only and will not follow the traditional format.
Audience
This non-MOC course is intended for 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.
Prerequisites
Before attending
this non-MOC course, students must:
• Have
thorough experience with SQL Server 2000
• Have
experience with 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
• Be
familiar with SQL Server 2005 features, tools, and technologies.
Non-MOC Course Outline
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