Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Mar 31, 2006

SQL Server 2005 Upgrade Advisor - Page 2

By Gregory A. Larsen

Viewing Upgrade Advisor Reports

The Upgrade Advisor creates a directory under the "My Documents" folder to store upgrade advisor reporting information. For each server analyzed there is a different folder created. Only a single set of report information is retained for a given server instance. Each time you run the Upgrade Advisor against the same server it overwrites the information saved from the prior execution of the upgrade advisor.

You can view the reports by clicking on the "Launch Upgrade Advisor Report Viewer" hyperlink from the main Upgrade Advisor window ("Welcome to SQL Server 2005 Upgrade Advisor"). When you do this, the following window will be displayed:

On this window you can select the reports you what to view. You can use the drop down menu at the top of this window to select the server for which to view reports, and what instances or components you want to view.

In addition to selecting which report you what to view you can use the "Filter By" drop down to filter your report the following ways: All issues, All upgrade issues, Pre-upgrade issue, All migration issue, and Resolved issues. The above report shows all the Data Transformation Services issues for a server named "SERVER1".

Note that the above report has a "When to fix" column. This column identifies at what time during your migration process you need to fix this issue. On this report there are "Before", "After" and "Advisor" when to fix issues.

This window only shows the issues descriptions. To show the detailed information about each issue you need to expand the issue by clicking on the "+" sign next to the issue. When I click to expand the "Replace functionality of Dynamic Properties task after package migration" item the following window is displayed:

Here you can see I have 10 objects that the upgrade advisor identified as having problems with this issue. To view a report that lists the 10 objects click on the hyperlink labeled "Show affected objects". Additional information about this issue and how to resolve it can also be viewed by clicking on the "Tell me more about this issue and how to resolve it" hyperlink.

There is no easy way to print all the issues identified by the SQL Server 2005 Upgrade Advisor. I have identified this issue to Microsoft, and they said it would be a great enhancement. Hopefully in future versions of the upgrade advisor they will include a print process to make it easier to get a hard copy version of the report. Microsoft did offer a work around to the missing print function. They suggested that you use the "Export Report" function.

Each issues window contains an "Export Report" link. If you click on this link, you can export the data used in all the issues into a comma delimited file (CSV). You can then use this CSV file as input into excel so you can format it for printing. Another option for printing is to open each issue, select all the text, and then paste the text into a word document. Then print the word document once you have cut and pasted all issues information.


The SQL Server 2005 Upgrade Advisor is a great tool for helping you migrate to SQL Server 2005. It should be one of first steps you use in the process of migrating your applications and databases to SQL Server 2005. The output from the advisor will help identify the issues you have to consider in upgrading your SQL Server 2000 and 7.0 components to the new release of SQL Server. Remember SQL Server 2005 Upgrade Advisor is a work in progress, so you should periodically check to see if there are new versions during your migration planning process.

» See All Articles by Columnist Gregory A. Larsen

MS SQL Archives

Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM