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
Solved

Copying  SSRS Reports

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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say 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

Have you ever had to extract data from a Microsoft SQL Server database and export it to an Excel file, but did not want to use a DTS package? The concept in this article is not new, but it is the answer and will also work on 64-bit SQL boxes.   …
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
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…

860 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