Solved

Copying  SSRS Reports

Posted on 2014-10-10
6
221 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 42

Accepted Solution

by:
Eugene Z 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
Resolve Critical IT Incidents Fast

If your data, services or processes become compromised, your organization can suffer damage in just minutes and how fast you communicate during a major IT incident is everything. Learn how to immediately identify incidents & best practices to resolve them quickly and effectively.

 
LVL 42

Expert Comment

by:Eugene Z
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:Eugene Z
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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
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…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

749 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