Continous integration with Reporting Services

Question

I'm implementing a continuous integration environment with SVN and reporting services.

The reports are stored in the SVN repository. when a change occurs, they are automatically downloaded from the repository, and any file changed should be uploaded to the reporting services server.

How could you automate the upload/update process for .rdl files?

Answer 1

One way would be to upload them via the reporting services web service. You'll have to generate a proxy and then write some code to read the reports from the local file system and upload them to the report server. You can use the ReportingService2005.CreateReport Method to do this.

You can also use the rs Utility to write a script. Here's a link to Scripting Deployment and Administrative Tasks