Upgrade Advisor

As a DBA of SQL Server 2000, you will sooner or later find yourself face to face with having to upgrade to SQL Server 2005. This may be due to an end of support for legacy software, or you may want to use the enhanced performance and new features provided in SQL Server 2005. Microsoft provides the Microsoft SQL Server 2005 Upgrade Advisor and recommends that you run it to analyze how your upgrade project will go before you get started on any project upgrades.

Upgrade Advisor is used to analyze the configurations of installed SQL Server 7.0 or SQL Server 2000 components and generate a report about the issues that you must address to ensure a successful upgrade. The reports generated by this tool let you plan how to deal with issues ...

Get Hands-On Microsoft SQL Server™ 2005 Integration Services now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.