I need to replace our reporting server. The old server is SQL 2008 R2. The new server will be SQL 2012 and will have a different name. We use the classic Report Manager, not SharePoint. How do I get our reports on the new server? I doubt I can just restore a backup of our ReportServer database as it won't get any of the changes an in-place upgrade would make. I can easily re-deploy all the reports but the security on them has got so many manual tweaks. I have a query to list the security out but it would take me days to set it all up again by hand.
Any suggestions how I can get this done with the minimum of effort, please?
asked Oct 29, 2012 at 09:04 AM in Default
David, the simple backup and restore should work. Steps to do:
After those speps you whould have fully running SSRS on the 2012 version with all your reports and everything properly set-up.
This works perfectly for me and migrated serveral SSRS instances in that way.
answered Oct 29, 2012 at 11:11 AM
I haven't done this step myself but I'd test out taking a project / solution and upgrading it to a new report server and see how I like the results. we don't have a hideous number of reports so upgrading each solution would be viable on a time required basis and would give good granularity to the process so each team can have their reports upgraded when its convenient.
answered Oct 29, 2012 at 12:14 PM