• subscribe
February 16, 2009 12:00 AM

Exporting SSRS Reports—For Free

SQL Server Pro
InstantDoc ID #101198

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.



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
  • SP1?
    I know there is a SP1 for SQL 2008 R2 available....and there is a "feature pack" as well... ...
  • SQL database mirroring
    I have SQL Server 2008 R2 Enterprise 64bit on Windows 2008 R2 Enterprise 64bit.  Each SQL Server has...
  • Dell Compellent Disk Drive
    Does anybody has experience with Dell Compellent Disk Drive? Basically, this system manages all disk...
  • Sql server performance tuning
    I need to find a tool that help me to optimize sql server,queries,improve the performance and solve ...