Mass deployment to multiple servers

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Wicky - 30 Jun 2006 14:39 GMT

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

Reply to this Message

Jéjé - 30 Jun 2006 15:24 GMT

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

> Hi
>
[quoted text clipped - 9 lines]
>
> Thanks Much

Reply to this Message

Wicky - 30 Jun 2006 15:29 GMT

Hi,

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

thanks

Reply to this Message

Jéjé - 30 Jun 2006 20:53 GMT

the rs utility tool exists in RS2000

> Hi,
>
> Sorry i should have mentioned. I am on sql server 2000.
>
> thanks

Reply to this Message