Migrating SQL 2008 Reporting Server - Problems with subscriptions migration

  • I am currently working on migrating SQL Server 2008 Reporting server to another Windows server. I have moved all the user databases along with the ReportServer and the ReportServerTempDB database and I am able to login to the reports website. However the subscriptions that we had in the previous server are not showing up in the new server. Can anyone tell me how I can move the Subscriptions??

    I am trying to use RSScripter.exe but this tool looks to use the RS.exe command prompt utility which for some reason is not available in my SSRS installation. Is this a separate tool that we need to download from MSDN?? OR is there another of migrating the subscriptions.

  • Nevermind, I just found the solution. I just had to move the databases and restart the services. Everything is fine now and I can see all the subscriptions in SQL agent.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply