By Dylan Moses | Senior Consultant
For organizations using Blackbaud CRM™, it may be necessary to migrate from one environment to another - whether during development and testing or during an upgrade or migration. This process can become cumbersome at times. One task that we’ve seen organizations have challenges with is migrating all of their SSRS reports.
One option in SQL Server Reporting Services is to log onto the report server and download each individual report. However, if your organization has hundreds of reports this would be very time consuming but is also subject to human error.
There is a simpler way to export your SSRS reports using PowerShell. The following code will export all report content in the exact same file structure as on the report server.
#------------------------------------------------------
#Install-Module -Name ReportingServicesTools
#------------------------------------------------------
#Lets get security on all folders in a single instance
#------------------------------------------------------
#Declare SSRS URI
$sourceRsUri = 'http://server/ReportServer/ReportService2010.asmx?wsdl'
#Declare Proxy so we don’t need to connect with every command
$proxy = New-RsWebServiceProxy -ReportServerUri $sourceRsUri
#Output ALL Catalog items to file system
Out-RsFolderContent -Proxy $proxy -RsFolder / -Destination 'C:\SSRS_Out' -Recurse
TIPS:
To get your SSRS URL open SSRS, connect to the correct Report Server Instance and click on the Web Service URL. Copy the URL and add the following to the url: /ReportService2010.asmx?wsdl
You will need to create the output folder ahead of time.
For more information on migrating between Blackbaud CRM™ environments, please feel free to connect with us.