Migrating SQL Server Reporting Services

  • blakemcneill

    SSC Enthusiast

    Points: 128

    Comments posted to this topic are about the item Migrating SQL Server Reporting Services

  • terry.home

    SSC Eights!

    Points: 864

    Thank you for very useful post. I have previously had to deal with SSRS Migrations (which were migrated by others) where my biggest gripe was that they failed to migrate subscriptions to reports that had taken lots of time to setup.

    Does this method also copy subscriptions or is a seperate article required to cover that?

  • blakemcneill

    SSC Enthusiast

    Points: 128

    terry.home - Thursday, March 21, 2019 3:33 PM

    Thank you for very useful post. I have previously had to deal with SSRS Migrations (which were migrated by others) where my biggest gripe was that they failed to migrate subscriptions to reports that had taken lots of time to setup.

    Does this method also copy subscriptions or is a seperate article required to cover that?

    According to the article from Microsoft (https://docs.microsoft.com/en-us/sql/reporting-services/report-server/moving-the-report-server-databases-to-another-computer-ssrs-native-mode?view=sql-server-2017), the subscriptions should be copied over.

    Subscriptions, cached reports, and snapshots are preserved in the moved database. If a snapshot is not picking up refreshed data after the database is moved, clear the snapshot options in Report Manager, click Apply to save your changes, re-create the schedule, and click Apply again to save your changes.

  • JSB_89

    Ten Centuries

    Points: 1040

    @blakemcneill

    Thanks for the awesome post , i followed the step by step you mentioned but i have a question ..let me explain my steps

    Guide me to migrate reports from sql 2012 developer server to sql 2016 Standard edition.  I have got the encryption key moved over and all the necessary setup for migration. Installed SSRS on the new server installed the report builder . When i try to backup reportserver DB from SQL 2012 version and restore on SQL 2016 the SSRS reports URL does not work. I have tried multiple ways but nothing worked . Some tables are missing from 2012 and 2016. Cannot do the backup and restore as we are missing some tables on 2012 so higher version of SQL at 2016 has them and 2012 does not so the application will not start without the tables .Tried ETL the tables too.

    First can we migrate dev 2012 to std 2016 edition what are the necessary steps and precautions.

    I have never done SSRS migration

    • This reply was modified 1 month, 1 week ago by  JSB_89.
  • blakemcneill

    SSC Enthusiast

    Points: 128

    I would check the SSRS logs on the new server and see what errors are showing. When you say the URL is not working, do you mean you cannot get to Reporting Services at all via the URL or do you see a Reporting Services error page when navigating to the URL?

    Are you able to try to migrate from 2012 Developer to 2012 Standard? It is possible there could be difference in the server edition.

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

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