[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 617
  • Last Modified:

How to transfer reports built using report builder from one server to another

Hi Folks,

The subject says it all.  We have a number of reports built using Report Builder and want to move some of the individual reports to another server.  Unfortunately we can't find a reasonable solution that doesn't involve wiping over anything.

Does anyone have any suggestions?

Thanks,

Jes
0
JesGoth
Asked:
JesGoth
3 Solutions
 
LiorRonCommented:
Can't you use BIDS to deploy them to another server ?
0
 
rickchildCommented:
From Report Manager you can download the .rdl and upload it to another server.

http://YourServerName/Reports

You will also need to make sure the data sources which the reports need are set up.
0
 
Tone' ShelbyMicrosoft® Platform Business Intelligence & Power BI Developer / Data AnalystCommented:
You can Quickly and easily extract all RDL's in mass from a Report Server and move to another with Reporting Services Scripter.

This a .NET Windows Forms application that enables scripting and transfer of all Microsoft SQL Server Reporting Services catalog items to aid in transferring them from one server to another. It can also be used to easily move items on mass from one Reporting Services folder to another on the same server. Depending on the scripting options chosen, Reporting Services Scripter can also transfer all catalog item properties such as Descriptions, History options, Execution options (including report specific and shared schedules), Subscriptions (normal and data driven) and server side report parameters.

and the best part of all ... currently it's FREE! ...

@ http://www.sqldbatips.com/showarticle.asp?ID=62
0
 
JesGothAuthor Commented:
Thanks all, hope you don't mind me splitting points
0
 
KentMarshCommented:
If you are using the MSSQLRS (Business Intelligence Development Studio) you will note that all of the documents are simply XML documents that have the "rds" or "rdl" extension. You can simply copy them from one project to another by doing the following:
1. Create/Open a Target Project that's on the target SQL Server.
2. In the Solution Explorer Right Click the Reports Folder and select "Add > Existing Item..."
2. Copy the files from the Source Project bin folder
3. Test  

NOTE: Report ID's are GUIDS. As long as they are unique, you're good.
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.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now