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. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

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:… – Rob Farley Oct 31 '11 at 23:52

Your Answer


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.