We are upgrading to SQL Server 2008 from SQL Server 2005. We are running SQL Server Reporting Services 2005 as well. Please suggest any good sources/links to upgrade articles. Also, if anyone has experience upgrading SQL Server, anything we should watch out for? I heard that the reports we have created with SQL Server 2005 will not function after the upgrade??
We built our previous reports using SQL Management Studio/Visual Studio 2005. Anything difficult about this upgrade? How long did it take?