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?
LVL 1
rwheeler23Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

prequel_serverCommented:
1. 2008R2 rdl reports should work just fine in 2012.

2. You say you have a handful of rdls? you should be able to download ALL rds of the deployed/published reports in production from Report Manager and backup them up.

3. I never did a report server DBs move as you suggest, you can try restoring a backup instead of a detach/move first to test if it works.

4. Not all SSRS info is contained in the Report server dbs, there are some config files in the system folders that you should be aware of.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
rwheeler23Author Commented:
How do you go into Report Manager and export the rdl's? I see where you can import them.
0
prequel_serverCommented:
Hover over a report and click on the dropdown menu that appears and choose download.
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

rwheeler23Author Commented:
Wow, never noticed that option. If a report contains a subreport, will it download the subreport as well?
0
prequel_serverCommented:
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.
0
rwheeler23Author Commented:
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.
0
prequel_serverCommented:
ok and? did you try recovering a copy of the reportserver dbs over to your 2012 instance?
0
rwheeler23Author Commented:
That is what I am in the process of doing right now.
0
prequel_serverCommented:
ok let me know how it goes and if you encounter any issues
0
rwheeler23Author Commented:
After bringing over the encryption keys all the reports fired right up.
0
rwheeler23Author Commented:
Thanks for your help!
0
prequel_serverCommented:
Glad to here
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SSRS

From novice to tech pro — start learning today.