Migrate SQL 2008 R2 reports into 2014

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

Answer 1

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]

Answer 2

“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.

Answer 3

Thank you

Export of all SSRS reports, datasources and resources

Worked like a champ.  Exported all the RDL files.