Steps moving reports from SSRS 2005 to SSRS2008

Hi MSnivek,

As per my understanding, you installed SQL Server 2008 on another server, now you want to move SSRS 2005 reports, subscriptions and reportserver database to the server. If that is the case, please refer to the following steps:

1. Back up database, application, and configuration files.
   


2. Back up the encryption key.
   


3. Move the report server database and other application files from your SQL Server 2005 installation to your new SQL Server 2008 installation.
   


4. Move any custom application files to the new installation.
   


5. Configure the report server.
   


6. Edit RSReportServer.config to include any custom settings from your previous installation.
   


7. Optionally, configure custom Access Control Lists (ACLs) for the new Reporting Services Windows service group.
   


8. Test your installation.
   


9. Remove unused applications and tools after you have confirmed that the new instance is fully operational.

For detail information about migrating a Reporting Services Installation, please refer to the following documents:

http://ift.tt/1lgeBkz

http://ift.tt/15ZlNhW

If you want to update SSRS 2005 projects to SSRS 2008, we can copy project files from report server 2005 to report server 2008, the reports are automatically upgraded on first use. After you upgrade a report, you might notice additional errors, warnings, and messages. This is the result of changes to the internal report object model and processing components, which cause messages to appear when underlying problems in the report are detected.

For detail information about upgrading Reports, please refer to the following document:

http://ift.tt/15ZlP9H

If you have any more questions, please feel free to ask.

Thanks,

Wendy Fu

---

Wendy Fu

TechNet Community Support