So if you have decided to migrate your SQL Server database to SQL Server 2008 R2, Microsoft TechNet has collected resources for you to easily accomplish the job.
There are many scenarios during an upgrade where you’ll want to migrate a SQL Server installation. We've collected a series of articles and resources that describe the processes and tools to make the task easier.
This set of topics includes information on
how to migrate a reporting services installation,
how to migrate integration services packages, and
how to migrate data transformation services packages.