Forum Discussion
Upgrading from 2012 (SP4) to 2019 including SSRS
Hi, I have done a fair bit of googling/reading and found conflicting paths/advice so am looking for a definitive guide. Step by step would be ideal if possible.
One of our servers is currently running SQL 2012 and we need to upgrade to 2019.
The instance also includes SSRS and the report server is on the same server. With approx. 100+ reports in use.
I've read that SSRS does not upgrade when you upgrade the SQL version as it is now a stand alone program (true?)
So basically I need to upgrade (in place) SQL Server (easy) but then do what ever I need to do to get SSRS to 2019 and obviously have the report definitions (RDLs) recognise their new environment and upgrade themselves in the process. I imagine the schema path at the top of the RDL would need changing at the very least. We also have scheduled subscriptions that we need to retain.... and of course datasources that point to the relevant DBs (not sure if these would be affected as part of any upgrade/install of SSRS).
Would be grateful for any legitimate sources that deal with this scenario and I thank you in advance.
2 Replies
I've read that SSRS does not upgrade when you upgrade the SQL version as it is now a stand alone program (true?)
True, since version 2017 a lot has changed in SSRS.
If you don't have a full SSRS project for deploament, then for migration you can export & import the reports, see
Upgrade and migrate Reporting Services - SQL Server Reporting Services (SSRS) | Microsoft Learn
Upgrade and migrate Reporting Services - SQL Server Reporting Services (SSRS) | Microsoft Learn
- Upgrade to Reporting Services 2017 and later from Reporting Services 2016 and older: This upgrade scenario isn't the same as previous versions. When upgrading to Reporting Services 2016 and older versions, you could follow an in-place upgrade process using SQL Server installation media. When upgrading to Reporting Services 2017 and later from Reporting Services 2016 and older, you can't follow the same steps because the new Reporting Services installation is a standalone product. It's no longer part of the SQL Server installation media.
To upgrade from Reporting Services 2016 and older versions to Reporting Services 2017 and later, follow the "Migrate a Reporting Services Installation (Native Mode)" article, with Reporting Services 2017 or later as your destination instance.
As you can see from the above, there's no in-place upgrade path available for you SSRS installation.
Link to Migrate a Reporting Services Installation (Native Mode) - SQL Server Reporting Services (SSRS) | Microsoft Learn- Upgrade to Reporting Services 2017 and later from Reporting Services 2016 and older: This upgrade scenario isn't the same as previous versions. When upgrading to Reporting Services 2016 and older versions, you could follow an in-place upgrade process using SQL Server installation media. When upgrading to Reporting Services 2017 and later from Reporting Services 2016 and older, you can't follow the same steps because the new Reporting Services installation is a standalone product. It's no longer part of the SQL Server installation media.
