SSRS: Copying Reports to a New Server without Losing Reports
Posted on 2014-04-18
I want to copy SQL Reporting Services (SSRS) reports from a SQL 2008 R2 box to another similar box that also has SSRS on it.
First of all, there are a lot of reports and data sources to be copied. So, I'm going to want to pull the ReportServer database from the "old" server.
Secondly, the "new" server has about twenty reports and two data sources that I want to keep.
How do I copy these reports over from one server to another and still allow for the new server to retain its current reports and data sources?