Subscribe to Windows IT Pro
February 16, 2009 12:00 AM

Exporting SSRS Reports—For Free

SQL Server Pro
InstantDoc ID #101198
Rating: (0)

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.

Related Content:

ARTICLE TOOLS

Comments
    There are no comments to display. Be the first one!
You must log on before posting a comment.

Are you a new visitor? Register Here

advertisement

advertisement

Windows is a trademark of the Microsoft group of companies. Windows IT Pro is used by Penton Media Inc. under license from owner.