• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 902
  • Last Modified:

SSRS Reports Deployment and Release Process

Hi,

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.


Thanks.
0
ezkhan
Asked:
ezkhan
  • 2
1 Solution
 
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.
0
 
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.

Thanks.
0
 
ValentinoVBI 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.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

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