Continuous Integration with Reporting Services

Question

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

Reports are stored in the SVN repository. when changes occur, they are automatically downloaded from the repository, and any file that needs to be changed must be uploaded to the report services server.

How can you automate the process of downloading and updating .rdl files?

Answer 1

One way is to download them through the Reporting Services web service . You will need to create a proxy server and then write code to read reports from the local file system and upload them to the report server. You can use ReportingService2005.CreateReport Method for this.

You can also use rs utility to write a script . Here is a link to Scripting Deployment and Administrative Tasks