Copying SSRS Reports

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
LVL 1
TBSupportAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

EugeneZ ZhitomirskySQL SERVER EXPERTCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
TBSupportAuthor Commented:
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
TBSupportAuthor Commented:
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
OWASP: Threats Fundamentals

Learn the top ten threats that are present in modern web-application development and how to protect your business from them.

EugeneZ ZhitomirskySQL SERVER EXPERTCommented:
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/
TBSupportAuthor Commented:
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
EugeneZ ZhitomirskySQL SERVER EXPERTCommented:
if you posted about "RS Scripter": check settings, learn how-to use it
it is the same rs.exe just wrapped in GUI
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SSRS

From novice to tech pro — start learning today.