Solved

Copying  SSRS Reports

Posted on 2014-10-10
6
211 Views
Last Modified: 2014-10-15
Hello:

What is the easiest way of copying SQL Reporting Services (SSRS) reports along with their Data Sources from Report Manager on Server A to Report Manager on Server B?

Server B already contains SSRS reports, and I don't want those overwritten.  Again, I just want to copy and not move reports from one server to another.

Thanks!  Much appreciated!

TBSupport
0
Comment
Question by:TBSupport
  • 3
  • 3
6 Comments
 
LVL 42

Accepted Solution

by:
EugeneZ earned 500 total points
ID: 40375057
you can use SSRS rs.exe

see
Sample Reporting Services rs.exe Script to Migrate Content between Report Servers
http://msdn.microsoft.com/en-us/library/dn531017.aspx

and\or try
MS Reporting Services Migration Tool
http://www.microsoft.com/en-us/download/details.aspx?id=29560
0
 
LVL 1

Author Comment

by:TBSupport
ID: 40375598
Thanks, EugeneZ!

This doesn't move reports, does it?   I only want to copy reports and "paste" them into the new server.  And, I want to do so without destroying the reports at the server that I'm copying to.

TBSupport
0
 
LVL 1

Author Comment

by:TBSupport
ID: 40375646
Also, I went to both of these links.  The MS Reporting Services migration tool only works in SharePoint mode.  And, when I go to the page to download rs.exe, all I see is an RSS feed file.

Help!

TBSupport
0
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 
LVL 42

Expert Comment

by:EugeneZ
ID: 40375660
it does not destroy SSRS just copy   reports.

looks like the above links are not easy for you

thus try this utility RS Scripter. RS Scripter is a very popular for such tasks, it was written by Jasper Smith,(known sql expert)

http://sqlserverfinebuild.codeplex.com/wikipage?title=Install%20Reporting%20Services%20Scripter

http://www.mssqltips.com/sqlservertip/2627/migrating-sql-reporting-services-to-a-new-server/
0
 
LVL 1

Author Comment

by:TBSupport
ID: 40375698
With that tool, I get an error saying "Client found response content type of '', but expected text/xml....."

It's disappointing that there's no easy way of doing this.  And, I can't do this manually, because some of the linked SSRS reports refuse to have their .rdl files downloaded.

TBSupport
0
 
LVL 42

Expert Comment

by:EugeneZ
ID: 40375895
if you posted about "RS Scripter": check settings, learn how-to use it
it is the same rs.exe just wrapped in GUI
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
CRM 2011 Lookup and populating related fields 31 261
SSRS parameters, tablix filter question 17 48
SSRS expression Issue finding a string 10 79
SSRS Get Last Day of Year 2016 2 70
Hi, I have heard from my friends that it’s not possible to create Label Printing report using SSRS. I am amazed after hearing this words not possible in SSRS. I googled lot and found that it is possible to some of people know about the Report Bui…
It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question