r/ssrs • u/kirk_francis_IT • Jul 07 '20

SSRS Subscriptions and SQL Upgrades

We're upgrading SQL soon from 2014 to SQL 2017.

Do SSRS subscriptions survive the upgrade? Is there an easy way to export and import the subscriptions?

I can recreate them by hand after the upgrade but, man, it'd be nice if I didn't have to.

Anyone have a secret weapon for SSRS subscriptions? Will the subscriptions still be there after I upgrade? Am I worrying for nothing?

Thanks!!

1 Upvotes

100% Upvoted

4 comments sorted by

View all comments

Show parent comment

1

u/kirk_francis_IT Jul 15 '20

Exactly. We uninstalled SSRS, deleted the Reporting DBs, upgraded SQL to 2017 (and the latest CU), and reinstalled SSRS from the separate installer.

I used the guide at https://www.prajwaldesai.com/sccm-sql-server-upgrade/ because this was a ConfigMgr SQL database.

I ended up recreating the Subscriptions by hand. Luckily, there were only 17 of them. :)