[
From blogs.msdn.com/]
Here at the NY Microsoft Technology Center (NY MTC), we recently ran a series of SQL Server Upgrade/Application Compatibility Labs with various customers and ISVs.
The two tools used in these labs were SQL Server Upgrade Advisor and SQL Server Upgrade Assistant.
The article continues at http://blogs.msdn.com/jbasilico/archive/2008/05/30/upgrading-sql-server-2000-2005-databases-to-sql-server-2008.aspx