Description: Microsoft provides a tool for upgrade preparation called the Upgrade Advisor. The Upgrade Advisor uses the compiled knowledge from the product team, internal lab testing, and extensive SQL Server 2005 early adopter experience, which analyzes the configuration of the existing database servers, services, and applications. The tool produces reports that identify changes within the SQL Server 2005 product that will impact the upgrade. These changes include security enhancements, closer adherence to the SQL standard, and architectural changes.
You can download this directly from Microsoft website: http://go.microsoft.com/fwlink/?LinkId=45788