I am having to migrate reports and subscriptions from one SSRS server to another. I have already migrated the RDL and Datasources. I only have the subscription information to move. I am trying to use the ReportingServicesTools (https://github.com/microsoft/ReportingServicesTools) and an example from here http://wragg.io/managing-sql-server-reporting-services-subscriptions-with-powershell/ to accomplish this. I exported the subscription information using Get-RsSubsctiption | Export-RsSubscriptionXml to a file.
I am trying to import it using Import-RsSubscriptionXml | Set-RsSubscription. When this executes, I get no messages, error or informational. When I look in the SSRS database, I don't see the subscription.
Here are the commands:
Get-RsSubscription -ReportServerUri 'http://sql2017/reportserver' -RsItem '/Cooperative Technologies/1035/1035YellowPages/Billing Reports/LookupActivityReport' | Export-RsSubscriptionXml "c:\users\logsdone\desktop\SSRS Subscriptions\1.xml"
Import-RsSubscriptionXml "c:\users\logsdone\desktop\SSRS Subscriptions\1.xml" -ReportServerUri 'http://sql2017/reportserver' | Set-RsSubscription -ReportServerUri 'http://sql2017/reportserver'
Thanks for any suggestions or additional documentation or examples.
Eric
Best Answer
you are using this PowerShell module from the gallery.
You need to use
Copy-RsSubscription
if the subscription on the destination does not already exist.Set-RsSubscription
updates only already created subscriptions.