Solved

Copying  SSRS Reports

Posted on 2014-10-10
6
272 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 43

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
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.

 
LVL 43

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 43

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

Want Experts Exchange at your fingertips?

With Experts Exchange’s latest app release, you can now experience our most recent features, updates, and the same community interface while on-the-go. Download our latest app release at the Android or Apple stores today!

Question has a verified solution.

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

In this short article I will be talking about two functions in the SQL Server Reporting Services (SSRS) function stack.  Those functions are IIF() and Switch().  And I'll be showing you how easy it is to add an Else part to the Switch function. T…
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…
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

615 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