Exporting SSRS Reports—For Free

Frankly, I would find it hardly worth the effort if I had to restore a single SSRS report and my only option was to restore the entire Reporting Services database. Thankfully, Jasper Smith has (apparently) mastered SOAP and the programmatic interfaces to SSRS and invented a free utility, Reporting Services Scripter, to suck out the RDL and Data Sources and all of the other catalog items from the database. I tried this utility and though it initially didn’t seem to support SQL Server 2008 (2.0.0.0.11), I was able to get it to connect to my SQL Server 2008 instance and script out the reports as well as create a Visual Studio BI project for each directory. This saved me the worry and trouble of propagating my test reports to another system. You can download the utility off the web.