Solved

SSRS Reports Deployment and Release Process

Posted on 2013-05-29
3
850 Views
Last Modified: 2013-06-11
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
Comment
Question by:ezkhan
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 37

Expert Comment

by:ValentinoV
ID: 39206776
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
 

Author Comment

by:ezkhan
ID: 39209276
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
 
LVL 37

Accepted Solution

by:
ValentinoV earned 500 total points
ID: 39210340
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

What Is Transaction Monitoring and who needs it?

Synthetic Transaction Monitoring that you need for the day to day, which ensures your business website keeps running optimally, and that there is no downtime to impact your customer experience.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

724 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question