<div>
Hi<br />
I recommend the detach and attach proccess for databases migration. After the migration, databases remains compatibility level version and collation.<br />
You should use this procedure: <a href="http://msdn.microsoft.com/en-us/library/ms189625.aspx" rel="ugc">http://msdn.microsoft.com/en-us/library/ms189625.aspx</a><br />
<br />
In order to migrate Reporting Services, this is the step-by-step process for success migration: <a href="http://technet.microsoft.com/en-us/library/ms143724.aspx" rel="ugc nofollow">http://technet.microsoft.com/en-us/library/ms143724.aspx</a><br />
And for DTS: <a href="http://technet.microsoft.com/en-us/library/ms143501.aspx" rel="ugc">http://technet.microsoft.com/en-us/library/ms143501.aspx</a><br />
<br />
Good luck<br />
Javier
</div>


Hi
I recommend the detach and attach proccess for databases migration. After the migration, databases remains compatibility level version and collation.
You should use this procedure: http://msdn.microsoft.com/en-us/library/ms189625.aspx [http://msdn.microsoft.com/en-us/library/ms189625.aspx]

In order to migrate Reporting Services, this is the step-by-step process for success migration: http://technet.microsoft.com/en-us/library/ms143724.aspx [http://technet.microsoft.com/en-us/library/ms143724.aspx]
And for DTS: http://technet.microsoft.com/en-us/library/ms143501.aspx [http://technet.microsoft.com/en-us/library/ms143501.aspx]

Good luck
Javier

<div>
<div class="content wysiwyg-content">
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. <br />
<br />
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?<br />
Thanks!
</div>
</div>


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?
Thanks!

Upgrade from SQL Server 2005 to SQL Server 2008 R2

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.