• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 527
  • Last Modified:

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
0
TBSupport
Asked:
TBSupport
  • 3
  • 2
1 Solution
 
planoczCommented:
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.
0
 
TBSupportAuthor Commented:
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
0
 
planoczCommented:
(Unless the reports are the same name on the new server) the copying in reports should not overwrite the reports alright on the server.
0
 
TBSupportAuthor Commented:
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
0
 
planoczCommented:
I would use Visual Studio on the new servr to help you import or copy the files you need. Then from there deploy the reports into the server just as you did on the old server.
0

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now