Forum Discussion
Side by side migration of MSSQL and SSRS from 2008 to 2019
HuwDG A bit of time has elapsed since you posted this. Did you manage to complete this migration? I'm facing the same task in the very near future. If you have any tips from your experience, I would be grateful. TIA
Hi, sorry about the delay in responding, the project was delayed until the new year in order for other projects to go through first, but I am back on it again.
After several tests I have confirmed that my SSRS 2008 instance can talk to and is happy with its ReportServer database being on a SQL 2022 instance, with that in mind, In order to de-risk the upgrades/migrations I am doing it in a 2 phase approach:
Phase 1. (very soon) - migrate the outgoing SQL 2008R2 Instance and all databases to the new server running 2022, the old SSRS 2008 server will continue to work when pointed to this server.
Phase 2. (to be done a few weeks later) migrate the SSRS instance to a new server running SSRS 2022. This is the bit which I need to do more investigation into and may need assistance on, primarily whether a 2022 SSRS instance can simply be pointed to a ReportServer database that was previously created by and used by a 2008 version of SSRS ( the Report Server database will be in a SQL 2022 instance)