SSRS Reports Deployment and Release Process


In my organization I have to plan and implement SSRS reports deployment and release process that will cover Development, UAT and Production environment and SVN will be used as source control. Can you please help me with your experience how to implement it that should be acceptable to technical users. Your help and suggestions are appreciated.

Who is Participating?
ValentinoVConnect With a Mentor BI ConsultantCommented:
I'm not aware of any existing document on that particular topic. But I can share a bit how I handle it in my projects.

DEV: deployed straight from BIDS

UAT: I create one batch file that deploys all SSRS objects using the method as demonstrated in the download I posted earlier.

PRD: copy of UAT deploy script with just one change: the report server URL needs to be the one of PRD.

So in situations where another team is responsible for the actual deployment to UAT/PRD you just give them the package, they copy it to the destination server and run it.
ValentinoVBI ConsultantCommented:
You can use the RS utility to automate report deployment.

I've built some general RSS scripts that can be used for that purpose. You can download them through the download link mentioned here: Automating SSRS Deployment: Download

I also wrote a blog post about how you could use queries to generate the batch file that uses the RSS scripts: SSRS Deployment: Generate The Batch Script Through SQL!

Let me know if you've got any questions on that.
ezkhanAuthor Commented:
Hi Valentino,

Thanks for the information you have provided above; but, I am also looking for some documentation how to carry out release process of ssrs reports from dev to UAT to Production. Any documented details with industry best practices will be really appreciated.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.