I have a customer consolidating and upgrading two different SQL instances into a new 2019 cluster. Both of those older instances have an SSRS deployment on them. 2019 doesn't allow multiple SSRS instances on the same server, so I was wondering if it is possible to merge two different SSRS databases. Or am I going to have to go the route of upgrading/migrating one instance and then export/import the reports and data source definitions from the second instance? If that is the answer, then is this powershell module the best way to do that and are there any gotchas that I need to be careful of? (ReportingServicesTools https://github.com/microsoft/ReportingServicesTools).
Late update to this question as the customer postponed the migration by a few months. Following on from the answer provided below, I ran the following commands to merge the reporting server instances.
On source server create a folder to hold exported objects, e.g. C:\SSRS_Txfr The following command will start at the top level folder and recurse down the folder tree exporting most SSRS objects.
Out-RsFolderContent -ReportServerUri 'http://<Source SSRS Server>:80/reportserver' -RsFolder / -Destination "C:\SSRS_Txfr" -Recurse -Verbose
On target server, create folder to hold exported objects and copy over from source server, again example used is C:\SSRS_Txfr
Create a folder in SSRS to hold transferred reports to avoid accidental overwrite or objects not copied due to existing object with the same name
New-RsFolder -ReportServerUri 'http://<Target SSRS server>/reportserver' -Path / -Name SSRS_Transfer -Verbose
Then load the exported objects retaining folder structure
Write-RsFolderContent -ReportServerUri 'http://<Target SSRS server>/reportserver' -Path "C:\SSRS_Txfr" -Destination /SSRS_Transfer -Recurse -Verbose
I will note that the customer had a number of Models in their source SSRS server that the scripts would not transfer. The customers BI team picked those up as well as updates to the Data Sources post-transfer.
