all groups > sql server reporting services > june 2006 >
You're in the

sql server reporting services

group:

Mass deployment to multiple servers



Mass deployment to multiple servers Wicky
6/30/2006 6:39:30 AM
sql server reporting services: Hi

I have wrote a set of report for a large company, this company has up
to 20 different divisions, all with a seperate sql server and seperate
instances of reporting services.

My single report project needs deployed to all 20 different instances
on a regular basis (as their is a lot of changes)

Is there an easy way to set these all off, as i am finding it time
consuming and painful at the moment.

Thanks Much
Re: Mass deployment to multiple servers Wicky
6/30/2006 7:29:09 AM
Hi,

Sorry i should have mentioned. I am on sql server 2000.

thanks
Re: Mass deployment to multiple servers Jéjé
6/30/2006 10:24:46 AM
does it RS2005 or RS2000?

in the 2 cases, you have to create a script (like VB.Net script) to do the
job.

RS2005 can create part of this script for you

take a look at the rs.exe command line tool and associated samples

[quoted text, click to view]

Re: Mass deployment to multiple servers Jéjé
6/30/2006 3:53:30 PM
the rs utility tool exists in RS2000

[quoted text, click to view]

AddThis Social Bookmark Button