Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I would be building or correcting the already build SSRS reports through report builder. Once the change is done in Development side, then how to publish the reports on test server/UAT or on production.

What methodology is supposed to be followed?

More information: SSRS would be used of SQL Server 2008 R2 edition, Report builder version is 3.0 and database is also SQL Server 2008 R2

let me know if anything is required.

Please Guide ME! Thanks!!

share|improve this question
    
is it need of share point for deploy of SSRS report compulsory –  user5831 Jan 16 '12 at 13:00
add comment

1 Answer

With RB (and sufficient privilege), users can save reports straight to the Report Manager environment. At that point, they're deployed. But if you want to have them save those reports to a Dev/Test box, and want to push them live, there's a few options.

One easy option is to move reports into a known folder 'For Deployment'. You can then have a script which grabs the RDL for reports in here and uploads them to the proper server. You'll probably want to make sure the data sources are mapped appropriately as this method can annoyingly lose references. You can use rs.exe for your scripts, or just use the web references. PowerShell can be very useful here, as it happily talks WebService, and you can schedule PowerShell scripts using SQL Agent jobs.

share|improve this answer
    
thanks Rob. Any supportive links that could make things a bit more clear? –  Romil N Oct 31 '11 at 12:28
    
It gets discussed in this thread. I haven't read it thorough detail, but there's definitely some examples about how to use a .rss script: social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/… –  Rob Farley Oct 31 '11 at 23:52
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.