Features of SQL Server 2008 Upgrade Advisor

In this post we will discuss the features of SQL Server 2008 Upgrade Advisor tool.
Microsoft SQL Server 2008 Upgrade Advisor helps database administrators analyze the existing instances of SQL Server 2000 and SQL Server 2005 databases. It identifies features and configuration changes that might affect your successful upgrade to SQL Server 2008. Once the entire analysis is done by the tool, it documents all the upgrade issues along with providing a link for issue resolution. The tool also identifies all potential upgrade blockers that might occur during or after the upgrade without actually performing the actual upgrade. Database Administrators should utilize this wonderful tool during the upgrade planning phase of the project to analyze SQL Server 2000 and SQL Server 2005 instances. This tool can analyze different components of SQL Server such as SQL Server, Analysis Services, Notification Services, Reporting Services, Data Transformation Services, Integration Services, Scripts and SQL Trace Files. I strongly recommend using this tool in advance to avoid any last minute surprises during the actual upgrade. Prerequisites for Installing and Running Upgrade Advisor:
The .Net Framework 2.0 or a later version
Windows Installer 4.5 or a later version
Windows Server 2003 SP 1 or a later version, Windows Server 2008, Windows XP SP2 or a later version, Windows Vista