<

Move SSRS reports from one server to another

Published on
13,948 Points
5,548 Views
4 Endorsements
Last Modified:
Approved
Hi All,

I am here to write a simple article to move SSRS (SQL Server Reporting Services) reports from one server to another. When I have faced the same issue to move reports those were developed by developer on development server and now need to be moved on production server. I have tried many ways to move report to productions server. But, all are routine work to publish from BIDS to server. However, I need the easy way to move all reports from Development to Production server.  After long time googling I found the best industry freeware tool, Reporting Services Scripter, on sqldbatips.com.

The Tool is developed by Microsoft MVP (Jasper Smith).

Let's move on tool and dig and see the features.

Tool is available with User Interface and Command-line application.

First set the Parameters to use application for Report transfer. It has facility to layman can set parameters easily. i.e. Objects which you want to export from server, where you wan to export, from which server you want to export etc. etc.. The application export all objects like folder, Data source, Reports, Data set etc.

Set Options
Set Options

Set Options  

Set Options

Set Options

Set Options

Set Options

Set Options
When you click on Get Schema will generate script in the specified folder and create user friendly (.bat) Batch file to load report and objects to another Report Server..

Generate Schema
You can see the generated script folder structure as shown in image.

Output files
To move reports to another location move this files to destination server (Optional) or just edit the file (RS Scripter Load All Items.cmd) and set the path of script and destination server name => save it and execute.

Edit Command file
It will load all the objects to the destination server. If any problem occurs to load the reports it will generate the log file at the specified location. (By default in the script folder)

That's It for now. Hope you enjoyed and learned something new.

Let me know if you have any question.

Thanks,

Alpesh
4
Comment
0 Comments

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Join & Write a Comment

Learn the basics of Skype For Business in office 365
Learn how to collaborate with office 365 Office Online

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month