RE: Deploying SQL reports to multiple sites

2012-06-22 Thread Greg Low (GregLow.com)
d 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/>

Re: Deploying SQL reports to multiple sites

2012-06-21 Thread William Luu
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 d

Re: Deploying SQL reports to multiple sites

2012-06-20 Thread Stuart Kinnear
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

Re: Deploying SQL reports to multiple sites

2012-06-20 Thread Donald
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) t

Deploying SQL reports to multiple sites

2012-06-20 Thread Stuart Kinnear
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