Our current SQL Server is SQL 2005 Enterprise Edition, we will move to SQL Server 2008 R2 Enterprise Edition. We have several hundred databases need to upgrade to SQL 2008 R2.
We could detach databases from SQL 2005 then attach them to SQL 2008 R2. Or backup databases from SQL 2005 and then restore on SQL 2008 R2. Is it in the right way? Do you have any good suggestions about this upgrade? How about reporting services upgrade and data transformation service packages upgrade?