Moving SSRS
I have an ERP solution that has a series of customized SSRS reports that were written by a third party. That third party is no longer available and I only have a handful of rdl files and none of the original projects. The original reports were deployed to a SQL 2008 R2 instance which has been moved to a SQL 2012 instance. Would it be possible to detach the original reports and temp reports databases and move them to the new server and attach them and expect the reports to work?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hover over a report and click on the dropdown menu that appears and choose download.
ASKER
Wow, never noticed that option. If a report contains a subreport, will it download the subreport as well?
Do you have one with a sub report? Try it and see what happens. I think it would depend on if the subreport(s) were reference from the VS project or to a published report on the server.
ASKER
These reports are for utility bills. I see on one of the reports in addition to the actual amount of the bill there is a subreport that lists monthly consumption for the prior 12 months.
ok and? did you try recovering a copy of the reportserver dbs over to your 2012 instance?
ASKER
That is what I am in the process of doing right now.
ok let me know how it goes and if you encounter any issues
ASKER
After bringing over the encryption keys all the reports fired right up.
ASKER
Thanks for your help!
Glad to here
ASKER