0

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

0

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.

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'  | Copy-RsSubscription -ReportServerUri 'http://sql2017/reportserver' -RsItem '/Cooperative Technologies/1035/1035YellowPages/Billing Reports/LookupActivityReport'

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.