We are currently on SQL 2008 R2 and need to move to 2014 to take the next HEAT upgrade. An in-place upgrade is not an option so we are looking to migrate to a fresh 2014 instance on the same server.
I have tested moving the STG/UAT application databases between instances and this seemed to go fine, however I don't have reporting in that environment I'm having difficulty finding a process for SSRS that fits what we're trying to do.
I spoke to an ivanti consultant but they didn't know of any instances of reports being moved, just recreated from scratch. We have over 200 custom reports scheduled for automatic issue overnight and rely very heavily on them during the day - trying to re-uploading all those templates and recreating the reports would be a nightmare.
Has anybody performed a successful migration of (native) reporting between same-server instances and managed to keep all their reports/subscriptions/SQL schedules (and would be willing to share their experience/process)?
Any thoughts very much appreciated