Hi Stuart, I've previously written some .NET code that will upload SSRS 2005/2008R2 RDL files to various SSRS servers.
>From memory, all I had to do was add a reference to the SSRS web service and call one of the methods (forget which one) and I was able to upload the report. It's not terribly difficult to do, and i'm sure there's code samples out there which show this. I can find more details if you need it. Regards, Will On 21 June 2012 13:29, Stuart Kinnear <stu...@skproactive.com> wrote: > Thank you > > I will try the command line utility. > > I discovered that by editing the project file directly rather than through > Visual Studio I am able to set up several configurations, this solved an > immediate need, but is useless for a one press of the button solution to > deploy to all servers. > > The codeplex RSbuild utility is out of date as it refers only to 2005 > reporting services - there was a problem with its reference to a relative > path to the current directory when getting the FilePath from the config > file, which is relatively easy to fix. But I've ditched the line of thought > to enhance this project it as I would have to spend time I don't have to > compile against 2008 report services. > > > Regards, Stuart > > > On 21 June 2012 13:09, Donald <donald.w.c...@gmail.com> wrote: > >> 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 <stu...@skproactive.com> 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. >>> >>> ----------------------------------------------------------------------------- >>> >>> >> > > > -- > > ----------------------------------------------------------------------------- > 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. > > ----------------------------------------------------------------------------- > >
