Forum Discussion
Migrate SSRS 2008 to 2022
This follows on from a previous thread I started, but the details have changed somewhat so I thought it warranted a new thread of its own. In summary : we have 2 hosts, one is a SQL 2022 databas...
Perform in place upgrades of SSRS from 2008 through to 2022 (in steps of say 2008 - 2008R2 - 2012 - 2016 - 2022).
HuwDG , that's the way to go to upgrade database engine, but in this case not for SSRS.
With version 2017 SSRS got so many changes. Installing SSRS 2017 or higher will completely uninstall the old SSRS instance, so you can also setup a complete new server, that's less effort.
- olafhelper
Thankyou for the reply,
So the number of changes to the SSRS report server database will rule out the incremental "in-place" upgrade on a staging server and will probably also rule out what I already suspected would be impossible which is to point the 2022 SSRS instance directly at the SSRS2008 Report Server database on the database server.
Does this leave me with just the export/import option? I will have to do some tests and see if this causes issues with the subscription agent jobs.
Many thanks.
