Export of all SSRS reports datasources and resources

This PowerShell script exports all (or filtered) reports, data sources and images directly from the ReportServerdatabase to a specified folder. For the file name the complete report path is used; for file name invalid characters arereplaced with a -.

 
 
 
 
 
4.7 Star
(11)
8,582 times
Add to favorites
Databases
9/7/2011
E-mail Twitter del.icio.us Digg Facebook
  • Thanks
    1 Posts | Last post October 16, 2015
    • This was a life saver.  Thanks much!!!
  • Filter options?
    2 Posts | Last post August 06, 2015
    • Hi - thanks for the cool script! However, I am not sure how to filter out reports to download? I only need reports with a creation/modified date that is after a specific date? how do I edit the script to add that filter? I need it as we have migrated many reports to SSRS2012 from SSRS2005. However, since that date, some customers have added new reports on the old SSRS2005 instance, and I only want to download those RDL's since that date! PLEASE HELP ! :) Thanks! Alessandro.
    • Hello Alessandro,
      
      You can add a filter to the entirely SQL Statement, either on "CreationDate" or "ModifiedDate", like:
      
      SELECT CT.[Path] 
            ,CT.[Type] 
            ,CONVERT(varbinary(max), CT.[Content]) AS BinaryContent
      FROM dbo.[Catalog] AS CT 
      WHERE CT.[Type] IN (2, 3, 5)
           AND CreationDate BETWEEN {d N'2014-01-01'} AND {d N'2014-12-31'}
      
      which filter on all reports created in year 2014.
  • The catalog table does not have any changes to the database
    1 Posts | Last post September 18, 2014
    • Hi Olaf,
      
      I know this script is pretty old and wondered if you had an updated one.
      
      I am working with MS on trying to figure out how to capture the correct information on the datasource.
      
      they told me when a datasource is created its inserted into the catalog table.  Any changes to the datasource is in the datasource table.  However its encrypted by design.  I was wondering if you had any ideas.  I need this for auditing reporting server.  Thanks again 
  • Make Script a bit more flexible
    1 Posts | Last post May 16, 2014
    • Would like to see similar script to place backups into date named folder that is created on fly. Perfect world it would also delete items older than xx days from backup directories.  
  • How to Import/ Reverse process from your script
    2 Posts | Last post May 17, 2013
    • Hi Olaf,
      
      Thanks for your script to export .rdl.
      It's help me half way, My goal is to copy all report from 1 server to another.
      From SQL Server 2008 to SQL Server 2012. 
      
      Is there a way to import all the report using script such yours ?
      Or is there another way to copy report from to different server.
      
      Thanks anyway
      
    • You can use the rs Utility (rs.exe) tool to deploy the reports to SSRS:
      http://msdn.microsoft.com/en-us/library/ms162839.aspx
  • How I can export shared datasources?
    1 Posts | Last post November 18, 2012
    • Hi!
      
      Thanks for nice script.
      
      I'm looking for a solution to export shared datasources (as rsd files) also.
      
      Regards
      
      Wojciech Sciesinski