Do you know how to migrate reporting service reports
  v1.0 Posted at 23/02/2017 8:08 PM by Moss Gu
​​​​Figure: How to migrate SSRS reports from an old server to another

Let's say you want to migrate SSRS reports​ from an old reporting service server (e.g., SQL Server 2008 R2) to a new one (e.g., SQL Server 2016). What involves?

There are three steps:​

Step 1: Find the reports that don't need to be migrated

  • You need to install SSW SQL Reporting Service Auditor both on the old and new servers. (You'll also need to run it on 3rd step)
  • Find those reports are not-in-use, as per a rule: Do you know which reports are being used?
  • Find creators of those reports, by clicking “Detail Views” in reports folder
    Figure: Find reports creators by clicking "Details View" inside report folder
  • Send an email to report creater ask for permission to delete 
     Figure:  Send an email to ask permission
    Figure: Email received with permission to delete from creator
  • 2. Migrate those in-use reports from old server to new server​

    Tip: use the ReportSync​ tool to save time

    3. Check audit results

    • Run SSW SQL Reporting Service Auditor on both sides
    • Compare audit results. Note that even error and warning messages also need to be the same

    If audit results are exactly the same on old and new servers, it indicates that migration is successful.​

Related rules

    Do you feel this rule needs an update?

    If you want to be notified when this rule is updated, please enter your email address:


    Note: Social Media login for Yotpo is not working in IE or Safari, please use Chrome. We are waiting for Yotpo to fix it.