Post reply

How to recreate subscriptions on a new server without doing a restore?

  • March 26, 2018 at 9:59 am

    #344121

    Hi all,
    Is it possible to safely recreate subscriptions (standard & data driven) from one server on another server without doing a restore of the reportserver DB & subscriptions table?  A new server will be built and instead of doing a restore migration we would prefer to do a clean rebuild. 
    thanks

  • March 26, 2018 at 11:35 am

    #1984570

    Darwin101 - Monday, March 26, 2018 9:59 AM

    Hi all,
    Is it possible to safely recreate subscriptions (standard & data driven) from one server on another server without doing a restore of the reportserver DB & subscriptions table?  A new server will be built and instead of doing a restore migration we would prefer to do a clean rebuild. 
    thanks

    you can try using rs.exe
    http://www.forrards.com/howtoeasilymigratessrsreportsbetweentwoservers/

    Alex S

  • March 26, 2018 at 11:51 am

    #1984574

    Darwin101 - Monday, March 26, 2018 9:59 AM

    Hi all,
    Is it possible to safely recreate subscriptions (standard & data driven) from one server on another server without doing a restore of the reportserver DB & subscriptions table?  A new server will be built and instead of doing a restore migration we would prefer to do a clean rebuild. 
    thanks

    Another option would be to use Powershell and the ReportingServicesTools module. They added some cmdlets recently which allow for exporting and importing subscriptions. This link goes over the details of using those:
    Managing SSRS Subscriptions with PowerShell

    Sue

  • March 26, 2018 at 5:39 pm

    #1984606

    I have not used either of these tools, should be interesting.  Thanks for the links!
    Thank you Alex and Sue, your input is greatly appreciated.

Viewing 4 posts - 1 through 3 (of 3 total)

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