I need to transfer a fairly large number of SSRS reports and subscriptions from one server to another. I've managed to transfer the reports, data sources, etc. by way of a detach/attach of the original SSRS database from Server A to Server B. I'm able to verify this by going into Report Manager and viewing all reports and their data sources, subscriptions, etc.

What I am having an issue with is getting the actual SQL Server Agent Subscription jobs over to the new server. I had thought that stopping and restarting Reporting Services would be enough for SQL Agent to "pick up" the subscriptions, but to no avail.

Is there an "easy" way to get the jobs to also transfer to a new server?

T

use SSIS

Transfer Jobs Task is used to transfer SQL Server Agent jobs from one SQL Server instance to another. This task gives you an option to copy all the jobs or selected jobs from the source server to the destination server.

I'm aware of that SSIS task, but my concern is if that task will keep all SSRS subscription/job settings intact.

Would like to know if anyone has actually used that task to move SSRS subscription jobs to another server and if they had any success with it.

select Encryption Keys, then click Backup. Enter a Password in the Encryption Key Information dialog and click the button next to Key File to specify a location and name for the key backup file.

I believe if you go into "Reporting Server Configuration Manager" and to the "Database" section and click "Change Database" and point it as your restored databases, it should scan for the subscriptions and recreate the jobs for you.

• Proposed as answer by Qiuyun YuMicrosoft contingent staff, Moderator Tuesday, July 07, 2015 1:54 AM

I've already made the key backup and restore part of the migration of my databases...

Sorry...haven't had a chance to reply back!

I'll be giving both suggestions a try and will post my results shortly!