Thursday, March 29, 2007

Scripting Reporting Services Reports

Do you need to migrate your SQL Server 2005 Reporting Services instance from one server to another? Look no further than Reporting Services Scripter:

"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."

Download it here.