THE SQL Server Blog Spot on the Web
Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | Join | Help
in Search

Richard Hundhausen: The DBAgilist

This is a mirror of Richard Hundhausen's (aka The DBAgilist) blog "Tales from the Doghouse."

Deploy RDL files to multiple SQL Server 2005 Reporting Services servers

Last week, while teaching a SQL Server 2005 Reporting Services class, I built this simple C# Windows forms application to help "push" an RDL report to multiple servers. It is a simple application that calls the CreateFolder and CreateReport Web methods on the ReportService2005 Web service. It's easy enough to customize for your purposes.

According to my students, this is a very common problem they face, as they have nine identical servers, with identical folder structures, and reports. They are generating and running scripts today, but wanted something more automated.

Feel free to download the source code.

I did find the Reporting Services Scripter utility, which looked promising.


Published Tuesday, December 26, 2006 1:59 PM by Tales from the Doghouse
Filed under:

Comments

No Comments
Anonymous comments are disabled

This Blog

Syndication

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement