Have to agree. Calling the webservice is quite easy and if that's too messy, using the rs command line utility as Donald mentioned below is a good option. There are lots of sample .rss files around. The contents of them is basically like VB but you're best to just start with any sample.
Regards, Greg Dr Greg Low 1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax SQL Down Under | Web: <http://www.sqldownunder.com/> www.sqldownunder.com From: [email protected] [mailto:[email protected]] On Behalf Of Donald Sent: Thursday, 21 June 2012 1:10 PM To: ozDotNet Subject: Re: Deploying SQL reports to multiple sites 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://%3Cserver/> http://<Server 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. ---------------------------------------------------------------------------- -
