Deploying SQL reports to multiple sites
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. -
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://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 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. > > - > >
Re: Deploying SQL reports to multiple sites
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 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://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 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. -
Re: Deploying SQL reports to multiple sites
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 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 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://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 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. > > - > >
RE: Deploying SQL reports to multiple sites
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: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] 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:///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 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. -