RSBuild deployment tool for Sql Server Reporting Services

I just discovered this promising project named on CodePlex for scripting the deploy of Stored Procedures & Sql Reporting artifacts. 

RSBuild is a deployment tool for SQL Server Reporting Service. It currently supports two types of tasks: executing SQL Server scripts and publishing SQL Server Reporting Serivce reports and shared data sources.

  • It uses ADO.NET to execute database scripts in batch. Database script can be specified in the configuration file with specific database connection. (This tool can be extended to support other database provider)
  • To publish reports and data sources to SQL Server Reporting Services, it uses the generic web service interface provided by SQL Server Reporting Services. By specifying data sources and report files in the configuration file, it will publish them to the designated location on the report server.

Besdes the simple command-line interface, the thing I liked most about it is that it isnt just the typical MSBuild wrapper to OSQL.exe and RS.EXE.   Instead it uses ADO.NET and wrappers to the Reporting Services management web services.

Since it is open source, I think I'll try and modify it to address a problem that often prevents me from using Microsoft's deploy tool. The RS.EXE tool that ships with Sql Reporting does not support custom security extensions such as Forms Auth and there is currently no work around other than writing your own replacement for the tool.

1 Comment

  • I'm trying to adapt RSBuild for use with Forms Auth, but so far I did not get it to work. I don't know how to modify the cookie management to make it work. The solution that works fine in a web project doesn't work. Have you succeeded to modify RSBuild for Forms Auth?

Comments have been disabled for this content.