Automating SSRS Report Deployment

Question

Hello....I have a web site in 3 environments (DEV/TEST/PROD). The Web Site uses SSRS which also has 3 different environments(DEV/TEST/PROD). Currently, I am deploying the reports using the Manual Deployment mechanism provided in the SSRS Solution (i.e., right click a report and click "Deploy"). I have to manually change the Deployment URLs for each environment.

Is there a way to Automate this so that reports are automatically deployeed to PROD and TEST if a change occurs in DEV? I've seen some info on RSScripter but it looks a little tricky/clunky...I was hoping for a more succinct/streamlined solution.

Thanks MikeTWebb

Answer 1

You can script the deployment with RS.exe utility.

http://msdn.microsoft.com/en-us/library/aa179659(v=SQL.80).aspx

http://social.msdn.microsoft.com/forums/en-us/sqlreportingservices/thread/aeb7dbe5-3796-4123-886c-d520b3e62d3e

This sample does this with Powershell and to Sharepoint but you can get the general idea how to do this with Powershell and ignore the Sharepoint bit.

Here's how to format the script file (.rss) & here are some sample scripts.

There is also a Reporting Services Scripter tool that might be of use to you.