upgrade/migrate from SSRS 2014 to SSRS 2019

Kathi 1 Reputation point
2021-02-19T16:34:35.57+00:00

Kathi-1750 asked · 3 minutes ago
how to upgrade SSRS 2014 to SSRS 2019

I'm currently running SQL Server 2014 (Enterprise Edition) using SSRS 2014 (Native mode) to create reports for my employer. I am also using Visual Studio 2013 Shell (Integrated) to create my reports. I'm wanting to know if I can upgrade the SSRS 2014 (Native mode) to SSRS 2019 (Native mode) while still keeping my SQL Server on the 2014 version? If I can, what pitfalls might I run across?

1) will my SSRS 2014 reports run as is once the upgrade to SSRS 2019 has been completed or will I need to rewrite my reports?
2) will there be a significant down-time for my users - time they will not be able to access current reports?
3) can SSRS 2014 be ran along side SSRS 2019 or is it best to just do the upgrade that way I'm only running one version?
4) will I need to also upgrade my Visual Studio software? If so, what version is best to use?
5) Is there any step by step instructions to do this as I'm not a DBA, so I'm leary doing this especially in my production environment...Would I be better to spin up an entirely new server, install SQL Server 2014 on that then install SSRS 2019 and then copy over my SSRS 2014 files to the new server? Once I'm comfortable that SSRS 2019 is working as I expect and my reports are still ok, then move my end-users to the new server?

Other items I should be aware of?

Thanks!!!

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,849 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 34,581 Reputation points
    2021-02-22T05:49:41.61+00:00

    Hi @Kathi ,

    To upgrade from Reporting Services 2016 and older versions to Reporting Services 2017 and later, follow the article.

    1)When you upgrade a Reporting Services installation to a SQL Server 2016 Reporting Services or later (SSRS) installation, existing reports and snapshots that have been published to a report server are compiled and automatically upgraded to the new schema the first time they are processed. If a report cannot be automatically upgraded, the report is processed using the backward-compatibility mode. The report definition remains in the original schema.

    upgrade-reports

    2)Yes there will be a down-time that the users couldn't access the current reports.

    3)We'd suggest that just run one version you need.

    4)SSDT is backwards compatible, so you can always use the newest SSDT to design and deploy databases, models, reports, and packages that run on older versions of SQL Server. You may upgrade your Visual Studio software as well.
    previous-releases-of-sql-server-data-tools-ssdt-and-ssdt-bi

    5)Here is an official article about upgrade-and-migrate-reporting-services for your reference. Please upgrade on your test environment and then implement it in the product environment. The most important thing is that back up the files and data.

    There are also some third-party teaching blogs online, you could also refer them carefully.

    Also you may create a ticket to Microsoft for Engineer to help if you paid for Microsoft products.

    Microsoft support.

    Regards,

    Zoe


    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.