<

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x

Move SSRS reports from one server to another

Published on
14,295 Points
5,895 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

Amazon Web Services

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

Join & Write a Comment

Did you know PowerShell can save you time with SaaS platforms? Simply leverage RESTfulAPIs to build your own PowerShell modules. These will kill repetitive tickets and tabs, using the command Invoke-RestMethod. Tune into this webinar to learn how…
See the Basics of Office 365's Note Taking app, OneNote

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month