The Reporting Services Scripter

Every developer and DBA needs a well stocked toolkit in order to get their work done efficiently and effectively.  Lots of useful tools ship with SQL Server.  For example, PerfMon and SQL Profiler are tools that every top-drawer DBA and developer should have and know how to use.

But there are lots of things that the native toolkit doesn't do well or at all.  In cases like that, it's important to stock your toolkit with scripts, utilities, shareware, and third-party tools to make you even more effective.

Here's one example - how do you move all of your Reporting Services objects from one server to another.  If you've never tried it before, let me tell you that it ain't easy.  Luckily for us, SQL Server MVP Jasper Smith, has created the Reporting Services Scripter.  (It's  a free download at http://www.sqldbatips.com/showarticle.asp?ID=62).

According to the descriptions...

"Reporting Services Scripter is a .NET Windows Forms application that enables scripting and transfer of all Microsoft SQL Server Reporting Services catalog items to aid in transferring them from one server to another. It can also be used to easily move items on mass from one Reporting Services folder to another on the same server. Depending on the scripting options chosen, Reporting Services Scripter can also transfer all catalog item properties such as Descriptions, History options, Execution options (including report specific and shared schedules), Subscriptions (normal and data driven) and server side report parameters."

That's just to sort of thing to add to our toolkit!  Thanks Jasper for sharing your wisdom and experience!

Cheers,

-Kevin