none
Upgrade and Merge Different SSRS Server Editions

    Question

  • Hi,

    I have two report servers [serverA and serverB].Both got reports server installed...
    2005 SSRS on serverA
    2008 R2 SSRS on serverB

    I want to move both SSRS servers to a completely new server which will run SSRS 2008 R2.

    Is it possible to merge both servers together onto a new server?

    Thanks

    Tuesday, November 19, 2013 5:20 PM

Answers

All replies

  • Hello,

    Please try the Reporting Services Scripter to move reports to a new server:

    http://sqlserverfinebuild.codeplex.com/wikipage?title=Install%20Reporting%20Services%20Scripter  

    You may have to assign permissions manually.

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

    Wednesday, November 20, 2013 3:44 AM
  • Hello,

    Reporting Services Migration Tool can be used for migrating reports and other artifacts from SQL Server 2008 R2 and later versions report servers to the new SQL Server Report Server.

    If you want to migration from SSRS 2005 to SSRS 2008 R2, you can try to use the thrid party tool reportsync. You can download reportsync from here.

    Regards,
    Fanny Liu

    If you have any feedback on our support, please click here.


    Fanny Liu
    TechNet Community Support

    Wednesday, November 20, 2013 6:59 AM
  • OK. Thanks.

    So is my best option as follows?...

    1. Create SSRS Installation on new server - "Files-only" installation
    2. Run Reporting Services Configuration Manager and change database to existing remote (serverA points to this)
    3. On serverB...
    • Backup ReportServer database (mitsubishi\OtherDatabases)
    • Backup ReportServerTempDB database (mitsubishi\OtherDatabases)
    • Backup Encryption Key
    • Use Reporting Services Migration Tool to move reports to newly created server

    Do I have to move any files, etc from serverA?

    And does this tool also migrate and merge SSRS databases?

    Thanks.



    • Edited by obrienkev Wednesday, November 20, 2013 11:23 AM
    Wednesday, November 20, 2013 8:38 AM
  • And does this tool also migrate and merge SSRS databases?

    Hello,

    As per my understanding, it is not support to merge SSRS databases from two source instance into the new SSRS instance.
    You can try the thrid party tool post above (Reporting Services Scripter or reportsync) to move the report items(reports, data sources and subscriptions) from source SSRS web service to new SSRS web service.

    If you want to use the Reporting Services Migration Tool, please also refer to the following blog about limitations of this tool:
    http://blogs.msdn.com/b/jameswu/archive/2012/04/21/reporting-services-migration-tool.aspx

    Regards,
    Fanny Liu

    If you have any feedback on our support, please click here.


    Fanny Liu
    TechNet Community Support

    Monday, December 02, 2013 1:38 AM