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
Certifications
Expand Certifications
Cisco
Expand Cisco
Citrix
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
Networking
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.
Security
Expand Security
Seminars, Webinars, Workshops
Expand Seminars, Webinars, Workshops
Social Media
Expand Social Media
VMware
Expand VMware
 
Louis Minham     Kendle
"...are very effective for training our global IT organization..." 
 
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:
SQLADV
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.

Prerequisites

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:

Introduction

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 ASP.net 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

Audience

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
LocationDate
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