exRS tool to deploy SSRS reports and subscriptions

There is a nice tool to deploy reports and/or subscription to SSRS - RS tool. And I described a way to use this tool here.

But it is not so easy to support VB scripts, so there is a new tool exRS. This tool helps to deploy reports and create subscriptions for reports.

Currently there is a small console application with name exRSConsole.

To deploy sample Report1 report and it’s subscription from Report1.xml: exRSConsole.exe -n Report1 -p SampleReport -r -s

Also this tool allows to delete all folders at SSRS server:

exRSConsole.exe -d

And backup all existing reports to local folder:

exRSConsole.exe -b

To configure exRS you need to change configuration file:

<applicationSettings>
    <exRS.Properties.Settings>
        <!-- URI of SSRS server -->
        <setting name="exRS_SSRSService_ReportingService2010" serializeAs="String">
            <value>http://desktop-name:80/ReportServer/ReportService2010.asmx</value>
        </setting>
    </exRS.Properties.Settings>
</applicationSettings>
<userSettings>
    <exRS.Properties.Settings>
        <!-- a user to connect to SSRS server -->
        <setting name="SSRSUser" serializeAs="String">
            <value>desktop-name\user</value>
        </setting>
        <!-- a password to connect to SSRS server -->
        <setting name="SSRSPassword" serializeAs="String">
            <value></value>
        </setting>
        <!-- a path to folder where put reports and subscriptions during backup process -->
        <setting name="backupPath" serializeAs="String">
            <value>C:\Temp</value>
        </setting>
        <!-- a name of folder with subscription configuration for reports (near exRSConsole.exe) -->
        <setting name="subscriptionSettingsFolder" serializeAs="String">
            <value>Subscriptions</value>
        </setting>
        <!-- a user name to connect to DB for data sources -->
        <setting name="dbUserForDataSource" serializeAs="String">
            <value>test</value>
        </setting>
        <!-- a password name to connect to DB for data sources -->
        <setting name="dbPasswordForDataSource" serializeAs="String">
            <value>test</value>
        </setting>
        <!-- a path at SSRS server where put reports created by subscription -->
        <setting name="subscriptionFileSharePath" serializeAs="String">
            <value>\\DESKTOP-NAME\Temp</value>
        </setting>
        <!-- a name of folder with reports (*.rdl, *rds and *.rsd files) (near exRSConsole.exe) -->
        <setting name="sourceFolderPath" serializeAs="String">
            <value>.\Reports</value>
        </setting>
        <!-- a name of folder at SSRS server with data sources -->
        <setting name="datasourcesServerFolderName" serializeAs="String">
            <value>Data Sources</value>
        </setting>
        <!-- a name of folder at SSRS server with datasets-->
        <setting name="datasetsServerFolderName" serializeAs="String">
            <value>Datasets</value>
        </setting>
    </exRS.Properties.Settings>
</userSettings>

After deployment you should see 3 folders in SSRS: “Data Sources”, “Datasets” and “SampleReport”. Please find the source code here.

Thanks.