If you have not seen this utility for SQL Server Reporting Services, it is an excellent edition to any tools you may have to manage your SSRS environment.
Here is the project description:
Project Description
This windows application lets you manage a Microsoft Reporting Servicer server. It supports both SQL 2000,SQL 2005 and SQL 2008, even when running in SharePoint Integration mode.
Currenly it allows you to:
- Download reports stored on the server, optionally including any (sub)folders by recreating the folder structure on the server by selecting a folder on the server. It will then download all reports and subfolders to the client.
- Upload multiple reports to the server, optionally you can upload a folder structure to the report server by selected a folder with reports and subfolders stored on the client.
- Get detailed information about the items on the server, like used datasources, parameters and permissions.
- Create and delete folders on the server.
- Move reports, datasources and folders.
- Rename reports, datasources and folders.
- Delete reports, datasources and folders.
- Set the datasource of multiple report on the server by first selecting folders and reports on the server and then the datasource to use. When targeting a folder all reports in that folder and any subfolder will be updated.
- Get an overview of item properties (used datasources, security settings, parameters and properties)
- Create or edit datasource
- Supports models - upload new models, replace existing (with compatibility check, great when administrating big sites w many users)
In my testing of this utility, I’ve found it to be useful, and easy to setup. Screen shot below of my local environment.
