How to copy reports to different servers

Hi,

Once a report is deployed to a specific server (server A), is there a way to "copy" it to a different server (servers B, C), without having to actually deploy it server by server?

In my case, I am trying to have the developers deploy the reports on the development server first (server A), and then manually or automatically copy them to a Preview server (server B), and later to a production server (server C). I cannot grant the developers full permissions on the production server, so a "copy" is what I'm thinking about....

Thanks in advance for any ideas.

Edwin.

Create one Solution file and add 3 reporting project files to it with different deployment locations. That will allow your devs to test and publish reports to your dev & preview enviroments, as well as copy reports to the production project so that someone with publishing rights to your prod server can deploy them.

Remeber to practice safe source!

|||You can always try Reporting Services Scripter at http://www.sqldbatips.com/

Or you can write some code for yourself either by copying reports from server A to B using the RS webservice, or a program that takes your rdl files and deploys it to all the servers.Check out "rs utility" and "ReportingService2005 class" in Books-OnLine. I can create a small code sample for you if you want to.|||

Right-click on the solution in Solution Explorer -> Properties

You can setup multiple configuration, each with different settings for

TargetDataSourceFolder

TargetReportFolder

TargetServerURL

Default configurations include

Active(Debug)

Debug

Debug(local)

Production

Funny thing is, I just noticed this today, as I used to change the TargetReportFolder a few times within the same solution, so thanks for asking