Export SSRS report from 2207 to a new 2409

Question

I am trying to export custom reports from an old site and bring them into the new site, what would be the best option to do so?

Answer 1

Hi, @Belgian Malinois

Thank you for posting in Microsoft Q&A forum.

If you modify predefined or created custom reports in SQL Server Reporting Services, create a backup for the report server database files. The report server backup must include the following components:

• The source files for reports and models
• Encryption keys
• Custom assemblies or extensions
• Configuration files
• Custom SQL Server views used in custom reports
• Custom stored procedures

For more information about backing up your custom reports in Reporting Services, see Backup and Restore Operations for Reporting Services.

For more details:

https://learn.microsoft.com/en-us/mem/configmgr/core/servers/manage/backup-and-recovery#back-up-custom-reports

---

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 "Add comment".

Answer 2

Report export & import is an option as well.

Aditional see

https://learn.microsoft.com/en-us/sql/reporting-services/install-windows/upgrade-and-migrate-reporting-services?view=sql-server-ver16

Answer 3

This is what I have used in the past to back up RDL from one site to another site. https://www.recastsoftware.com/resources/how-to-backup-sccm-reports/