Migrate SQL 2008 R2 reports into 2014 RRS feed

  • Question

  • I am looking for a solution to recover 22 reports from a now dismantled 2008r2 SSRS solution.  I did detach and save the ReportServer and ReportServerTemp databases.   I know in hindsight, I should have downloaded each of the RDL files from 2008r2 and then upload into 2014.   A note for anyone considering an upgrade, save your RDL files. 

    I ask anyone with recommendations or ideas, please let me know.  I do not look forward to rebuilding the reports – my memory is not that good. 

    Thank you
    Wednesday, August 24, 2016 4:31 PM


All replies

  • Hello,

    You can restore (or attach) the Report Server database on a new SQL Server and in Reporting Service Configuration Manager you can setup your new SSRS to use that databases; works the same way as: Moving the Report Server Databases to Another Computer (SSRS Native Mode)

    BTW, with this script you can export all from SSRS; when the databases are still running: Export of all SSRS reports, datasources and resources

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    • Proposed as answer by Yuliana Gu Thursday, August 25, 2016 9:03 AM
    • Marked as answer by Envisalution Thursday, August 25, 2016 6:08 PM
    Wednesday, August 24, 2016 5:08 PM
  • “Moving the Report Server… (SSRS Native Mode” relies on the presence of the encryption keys off the original SSRS implementation, which I do not have.  On a clean install of SQL 2008 R2, Report Server Configuration Manager does attach and recognize my saved Report Databases; however, without the original keys SSRS terminates Report Manager URL access with the following error – “The report server installation is not initialized. (rsReportServerNotActivated)”.  I did verify SSRS works properly.  Only after I attach my saved report database files do I receive the “…not initialized error...”.

    I read a little on your “Export of all SSRS reports, datasources and resources” suggestion. I like what I see and a solution looks very promising.   I will examine this option further before I dig further into any possible encryption key resolution.

    Thank you for your suggestions.

    Wednesday, August 24, 2016 6:16 PM
  • Thank you

    Export of all SSRS reports, datasources and resources

    Worked like a champ.  Exported all the RDL files.

    Thursday, August 25, 2016 6:10 PM