Extract RDL's from SSRS

http://www.sqldbatips.com/showarticle.asp?ID=62

Overview

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 Reporting Services Scripter (2.0.0.17) View the Readme file

Key Features

• Quickly and easily extract all RDL from a Report Server
  
• Automatically generates scripts to load reports, datasource's, resources, linked reports and folders with all their associated properties to enable report migration between servers with no manual intervention e.g. avoids having to try and copy execution options between servers manually using Report Manager which is prone to mistakes and not as repeatable or efficient as scripting
  
• Automatically generates command files to load scripted items onto a new server
  
• Automatically transfer items from one server to another (including from SQL2000 to SQL2005 to SQL2008)
  
• Generate scripts for Shared Schedules
  
• Generate Scripts for System and Item Level Roles
  
• Generate Scripts for Normal and Data Driven Report Subscriptions
  
• Easily generate loader scripts to load existing RDL files e.g. if RDL is kept under source control then it can just generate the scripts to load the reports rather than extract the report definition as well
  
• Automatically backs up reports before overwriting them
  
• Easily generate scripts from the command line
  
• Reverse engineer Visual Studio Report Projects from a Report Server
  

Tested Environments

• Windows 2000, XP, Vista
  
• Windows Server 2003, 2008
  
• SQL ServerReporting Services 2000, 2005, 2008

Requirements

In order to run Reporting Services Scripter you need to have the .NET Framework 1.1 installed. In order to be able to run the generated command files or use the Transfer mode of deployment you will need the Reporting Services Management Tools installed, specifically the command line utility RS.EXE (this is version specific and the correct versions for your environment are required for full functionality)