Export of all SSRS reports, datasources and images
Requires permission to execute powershell scripts. Use:
Get-Executionpolicy (To see permissions)
Get-Executionpolicy -List (To see complete information about permissions)
Set-Executionpolicy Unrestricted (To change permissions)
This PowerShell script exports all (or filtered) reports, data sources and images directly from the ReportServer database to a specified folder. For the file name the complete report path is used; for file name invalid characters are replaced with a -.
Reports are exported with .rdl as extension, data sources with .rds and resources without any additional extension.
Please change the "Configuration data" below to your enviroment.
Works with SQL Server 2005 and higher versions in all editions.
Requires SELECT permission on the ReportServer database.
Requires permission to execute powershell scripts. Use:
Get-Executionpolicy (To see permissions)
Get-Executionpolicy -List (To see complete information about permissions)
Set-Executionpolicy Unrestricted (To change permissions)
This PowerShell script exports all (or filtered) reports, data sources and images directly from the ReportServer database to a specified folder. For the file name the complete report path is used; for file name invalid characters are replaced with a -.
Reports are exported with .rdl as extension, data sources with .rds and resources without any additional extension.
Please change the "Configuration data" below to your enviroment.
Works with SQL Server 2005 and higher versions in all editions.
Requires SELECT permission on the ReportServer database.
