PowerShell scripts to deploy a SQL Server Reporting Services project (*.rptproj) to a Reporting Server
There's a project wiki on github, go ahead and expand it
This repository was forked from:
I've turned it into a proper github repo to allow discussion, pull requests etc.
Download a .zip or tarball from https://github.com/timabell/ssrs-powershell-deploy/releases/latest - this will be the current stable release.
.\Deploy-SSRSProject.ps1 -path YourReportsProject.rptproj -configuration Release -verbose
Full parameter list is defined at the top of Deploy-SSRSProject.ps1
If I understand it correctly (I didn't write it) you can specify either a build
configuration to read deployment settings from or you can specify all these
settings manually (
To open the example reports project in visual studio and edit the reports you'll need Sql Server Data Tools (SSDT)
Disappearing dataset panel - http://stackoverflow.com/questions/7960824/i-lost-datasets-pane-in-visual-studio/28883272#28883272
The project caches both datasets and data. Remove all the
.data files and the
bin/ folder(s) to be sure your changes will work when deployed.