Find Classes
Choose A Category
Skip Navigation Links
Adobe / Graphic Design
Expand Adobe / Graphic Design
Big Data
Expand Big Data
Bootcamps @ MAX
Expand Bootcamps @ MAX
Expand Certifications
Expand Cisco
Expand Citrix
CompTIA Courses
Expand CompTIA Courses
Database - Business Intelligence
Expand Database - Business Intelligence
Development Java
Expand Development Java
Development Mobile
Expand Development Mobile
Development Web
Expand Development Web
Development Windows & .NET
Expand Development Windows & .NET
Directory Services
Expand Directory Services
E-Learning Online Anytime
Expand E-Learning Online Anytime
Enterprise Applications
Expand Enterprise Applications
Enterprise Architecture
Expand Enterprise Architecture
Microsoft Office
Expand Microsoft Office
Microsoft SharePoint
Expand Microsoft SharePoint
Microsoft Technology
Expand Microsoft Technology
Expand Networking
Operating Systems
Expand Operating Systems
Products:Exams, Vouchers, Certificates
Expand Products:Exams, Vouchers, Certificates
Professional Skills: Agile, BA, etc.
Expand Professional Skills: Agile, BA, etc.
Expand Security
Seminars, Webinars, Workshops
Expand Seminars, Webinars, Workshops
Social Media
Expand Social Media
Expand VMware
Greg Witzgall     GAIC
"...MAX is also very willing to help us grow on a bigger level and not just fill individaul class needs. ..." 
Ways to Maximize IT Training

Yep we'll design streamlined instruction just for your team.

More ways to learn than you can shake a mouse at.

Ask for Help

If it can be taught, MAX can teach it. Special requests are welcome.

MAX Technical Training is licencsed with the Ohio State Board of Career Colleges and Schools (#00-01-1529T).  For those accessing MAX in this capacity you may view and download our School Catalog for 2014.

Course Description
This information has been printed from:
Upgrading Your Databases to SQL 2005

This 2 day hands on class will provide key information necessary to perform successful database upgrades from MS SQL Server 2000 to MS SQL Server 2005 including: how to resolve issues related to database engine changes, analysis services changes, DTS changes, SQL agent changes and redesign of SQL Server 2005 security. This course will also cover using the MS SQL Server 2005 Upgrade Advisor in detail.


Before attending this course, students should have:

  • Administration experience with Microsoft SQL Server 2000 or Microsoft SQL Server 7.0
  • Knowledge of SQL Server 2000 / 7.0
  • Experience Creating a Database on SQL Server 2000 / 7.0
  • Database and server architecture
  • Database security


Course Outline
New Page 1

Module 1:


Brief Overview of New Features in SQL 2005 (Reasons to Upgrade)


Need for Upgrade Advisor


Upgrade Advisor - Finding your way around.


Performing an analysis

            Choosing which type of Analysis to perform

            Steps to performing an analysis

            Using UpgradeAdvisorWizardCmd Utility


Practice: Performing an analysis


Viewing Results

            Launching the Report viewer

                  Understanding results & finding resolutions

            to issues

            Common issues and their resolutions


Practice: Viewing Upgrade Advisor Reports



Module 2:

Upgrading Database Engine Issues

            Full-text Indexing Issues and how to fix them

            Log Shipping Resolution

            Working with Binary Large Objects

            Restriction on username 'sys'

            Read-only file groups

            Auto-grow setting before upgrade


Lab 2: Fixing common DB Engine issues



 Module 3:        

Upgrading Analysis Services

Choosing one of the upgrade techniques

1) Setup.exe for in-place upgrade

2) Migration

3) Migration ++

   - Install a new instance

   - Import as project

   - Add new SQL Server 2005 features

4) Redesign from scratch

Changes with Virtual Cubes

New Attribute Architecture

Changes to Dimensions

Items not Migrated



Module 4:

Reporting Services Upgrade Issues

Decrypting service account before upgrading

            Virtual directory setting issues

            Issues not detected by Upgrade Advisor


Lab 4: Preparing Reporting Services for Upgrade



Module 5:

SQL Server Agent Upgrade Issues

            Migrating Database Maintenance Plans

            Changes in who can write log files

            Changes to security

How upgrading handles existing job owners         


Lab 5: Migrating DB Maintenance Plans



Module 6:

Upgrading Security

            Understanding the new security model

            Design considerations for SQL 2005 security

            Steps to upgrade security from 2000 to 2005


Lab 6: Upgrading security



Module 7:

Fixing Issues with DTS Packages

            Changes to DTS (SSIS)

            Installation options for backward compatibility

            Package Scanning Issues

Fixing Tasks & Connections after upgrading a DTS package

            Fixing Transaction settings in packages


Lab 3: Fixing common DTS Issues


Before attending this course, students should have:

  • Administration experience with Microsoft SQL Server 2000 or Microsoft SQL Server 7.0
  • Knowledge of SQL Server 2000 / 7.0
  • Experience Creating a Database on SQL Server 2000 / 7.0
  • Database and server architecture
  • Database security


Choose a Class Below
Number of Students    

You can also take this class privately or
contact us to fit your needs.

MAX Live provides state of the art technology to students that want to attend a MAX or MAX Select Partner Class from anywhere in the world. Our state of the art technology allows students to participate in the FULL classroom experience.

  • See the Instructor, their slide presentation, demonstration and whiteboard
  • Hear the Instructor’s lecture
  • Perform hands-on labs
  • Receive expert assistance from the Instructor
  • Communicate with the Instructor and other students via web cams, microphones and online chat
  • Learn from the real-world experiences of your Instructor and fellow students