MIgrate 2008 version RDLs to 2019

Question

We have several RDLs that was written when we were using SQL Server 2008, we moved to 2010 and then to 2016. Now we are moving to 2019.
Although current RDLs still continue to work with 2019 to our knowledge (Not fully regressively tested all RDLs yet),, we have decided to target thme for 2019.
Is there a way to mass migrate them to 2019 to save time. We are talking about 150+ RDLs.

Answer 1

What do you mean by migrate? Are you asking how to move the reports from the older server to the new server or are you asking about how to upgrade them to 2019?

As discussed here when an RDL is run on the server it is automatically upgraded to the current version. There is nothing you need to do for this.

If you for some reason want to force an upgrade without running the report then you'd have to open each one and save it. This is the only supported approach to upgrading the report. Of course this could be automated using scripting or something I would expect.

Answer 2

I Installed SSDT with extension to VS 2022, created a SSRS project. The target version did not list 2019.
it listed only the following:

SQL Server 2008
SQL Server 2008R2, 2012, or 2014
SQL Server 2016 or Later
Detect Version...

When I clicked on Detect version by changing the TargetServerURL to a valid server URL that is configured to use SQL Server 2019., i get an error
"Failed to detect ....

Answer 3

I'm not trying to answer to my own post. I was trying to reply to "cooldadtx" because I did not see the option to reply to his response.
Yes, I was trying to forcefully migrate all RDLs to 2019 rather than opening and saving them one by one.
You talked about script in your reply, could you please shed some light on this?

Answer 4

Hi @balu raju ,
One way is to use a 3rd party tool, ReportSync is an open source program that is free to download and use, it is great for downloading reports in batches and even pushing reports from one server to another. See more: https://stackoverflow.com/questions/51439854/ssrs-2008-r2-to-ssrs-2016-migration
You can also choose to perform the report migration manually. The rs.exe utility processes script that you provide in an input file. Use this utility to automate report server deployment and administration tasks.
See more: Sample Reporting Services rs.exe Script to Copy Content between Report Servers.
OR
How to Easily Migrate SSRS Reports Between Two Servers.
Best Regards,
Joy

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
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.

Answer 5

Is there a way to mass migrate them to 2019

Install latest version of SSDT, start SSDT, open your existing SSRS project, change in project properties the TargetServerVersion to 2019, compile the project and deploy it to your SSRS server; = migration done.