Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

SSRS Reports Deployment and Release Process

Posted on 2013-05-29
3
Medium Priority
?
886 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 2000 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

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

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…
I have a large data set and a SSIS package. How can I load this file in multi threading?
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

636 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