We have used a set of batch files to deploy SSRS to various different environments
Use the command line deployment utility rs -i PublishSampleReports.rss -s http://<Server <http://%3Cserver/> Name>/reportserver Create a 'core' batch file that contains all the files (reports, images, data sources, etc) to deploy, but with parameters. Then create a batch file for each environment with parameters passed into the 'core' batch file. Hope that this makes sense. Don. On 21 June 2012 11:23, Stuart Kinnear <[email protected]> wrote: > When deploying SQL reports 2008 from Visual Studio it is a pain when it > comes to deploying to a few different sites. I tried setting up different > configurations using the Configuration Manager & that failed miserably. I > have a couple of test virtual machines and a couple of customers to deploy > to with patches and new reports, it seems ridiculous to have to manually > set up the target server every time. > > Anyway I came across this application called RSBuild, but it seems to be a > bit buggy & not updated for a while. When I try to use UNC paths for the > location of the rdl files it fails and if I map the UNC path to a drive I > get a error stating that "the given path's format is not supported". > Perhaps if I move the config and/or the rsbuild app to the unc location it > may work. > > Is there a better way ? Surely there must be ! > > -- > > ----------------------------------------------------------------------------- > Stuart Kinnear > Mobile: 040 704 5686. Office: 03 9589 6502 > > SK Pro-Active! Pty Ltd > acn. 81 072 778 262 > PO Box 6117 Cromer, Vic 3193. Australia > > Business software developers. > SQL Server, Visual Basic, C# , Asp.Net, Microsoft Office. > > ----------------------------------------------------------------------------- > >
