TBSupport
asked on
SSRS: Copying Reports to a New Server without Losing Reports
Hello:
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?
Thanks!
TBSupport
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?
Thanks!
TBSupport
Howard Cantrell
You can copy all the reports to the new server, But you still have to select all the reports again to be deployed to that new server. Copying the reports is different than just doing a deployment.
ASKER
I'm still unclear as to (a) what the steps are to accomplish this copying and (b) how to do so without overwriting the reports currently on the new server.
TBSupport
TBSupport
(Unless the reports are the same name on the new server) the copying in reports should not overwrite the reports alright on the server.
ASKER
Hi planocz:
Thanks, for the excellent responses!
I still am concerned, though, about the fact that I'm going to be pulling the ReportServer database from the old server to the new. Again, I don't see of a way around that since the old server has a lot of reports. I don't want to just export and import .rdl files.
And, in so doing, I don't want to overwrite the reports that are already on the new server.
How do I accomplish all of this?
Thanks!
TBSupport
Thanks, for the excellent responses!
I still am concerned, though, about the fact that I'm going to be pulling the ReportServer database from the old server to the new. Again, I don't see of a way around that since the old server has a lot of reports. I don't want to just export and import .rdl files.
And, in so doing, I don't want to overwrite the reports that are already on the new server.
How do I accomplish all of this?
Thanks!
TBSupport
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.