CODEWITHSUNDEEP
deploymentreporting-services
Bruno Lopes
Bruno Lopes

Reputation: 323

How you deploy your reports (with Reporting Services)

Which one you choose?

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

Upvotes: 16

Views: 22369

Answers (4)

Oszkar
Oszkar

Reputation: 682

We use rss scripts to get all reports from a folder and upload them to the given Report Server.

Upvotes: 0

Sam
Sam

Reputation: 7678

Developers can publish to development using the deploy command in visual studio. Admins move the reports from dev to prd with rsscripter.

Upvotes: 0

Dustin Brooks
Dustin Brooks

Reputation: 2591

For the developers we have a custom built ReportDeployer where we choose what environment to deploy to (development, test, production) and branch to deploy from (also development, test, production). There is a config file with all the reports available for deployment along with their directory structure.

For production builds, the ReportDeployer has a command line interface and our build script pulls the latest reports from the Prod branch in TFS, then deploys all using our custom app.

Upvotes: 0

PJ8
PJ8

Reputation: 1278

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.

Upvotes: 2

Related Questions