How you deploy your reports (with Reporting Services)

Question

Which one you choose?

• Use the Deploy feature in VS
• Build a rss script and execute it through rs.exe
• Build a deployment package
• Another option

Keep in mind that in many of your environments the report developers/designers don't have publish role in Reporting Server.

Answer 1

In Dev, we use the deploy feature in VS. In Prod, our Prod support team will either upload them manually from the ReportServer website (if it's just one or two reports) or use a simple report upload utility that we wrote. The utility uses the SSRS web service.