Exporting All Blackbaud CRM™ SSRS Reports

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.


#------------------------------------------------------

#Prerequisites

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

© 2017 BrightVine Solutions | All Rights Reserved

Offices:

Boston*

Charleston*

Charlotte

Nashville

Tallahassee 

Jacksonville/ Savannah

Atlanta 

843-900-4287

  • BrightVine on LinkedIn
  • BrightVine on Facebook
  • Twitter
Let's Connect

BrightVine Solutions, Inc. (BrightVine) is a member of the Blackbaud partner network. BLACKBAUD®, THE RAISER'S EDGE®, BLACKBAUDINTERNETSOLUTIONS®, BLACKBAUD CRM®, and RAISER'S EDGE® are registered trademarks of Blackbaud.  BRIGHTVINE, the BRIGHTVINE® LOGO, BRIGHTVINE DATALOADER® and DELIVERING EXCELLENCE FOR GOOD® are registered trademarks of BrightVine Solutions.

 

All other third-party trademarks mentioned on this website are the property of their respective owners.  Learn more about BrightVine on our blog