Monday, July 17, 2023

SSRS - How to migrate Report Subscriptions from one server to another server

SQL Server always create Subscription jobs in the instance where reporting service is installed/Configured. Or we can say SQL server instance where ReportServer database is configured.

Following are the steps for Report Subscription Migration:
1) We dont need to migrate Report Subscription jobs as part of migration from one server to another.
2) We can take the backup of ReportServer DB and restore to new server for migration.
3) Report server DB contains all subscription definitions.
4) Once you schedule these subscription in new server it will automatically create subscription jobs in SQL Server instance under SQL Server Agent folder==> Jobs folder.
5) Now schedule those Jobs per business requirement
6) Your subscription will start working in new server.

No comments:

Post a Comment