I will keep on adding the resources which I would find useful to help customer upgrading from SQL Server 2000/SQL Server 2005 to SQL Server 2008
White paper written by experts SQL Server 2008 Upgrade Technical Reference Guide
SQLCAT Team Blog http://blogs.msdn.com/sqlcat/archive/2008/12/08/ultimate-guide-to-upgrading-to-sql-server-2008.aspx
MSDN Link Resources for Upgrading to SQL Server 2008
SQL Server UE team blog http://blogs.msdn.com/sqlserverue/
Upgrade Advisor http://www.microsoft.com/downloads/details.aspx?familyid=F5A6C5E9-4CD9-4E42-A21C-7291E7F0F852&displaylang=en
Thanks for the amalgamation, Balmukund. It is exactly what I needed.
I have a error that occurs while upgrading from SQL2000 to SQL 2008. "RSconfigfile path element is missing"
It then stops the upgrade. Any ideas on how to solve this issue?