Pbi Report server Version Upgrade

[Roky]

- we are upgrading the report server version from May 21 to Sep 23 in company on-prem. Need clarification on code backup during version upgrade, any possibility to rollback if there is an error occurs.

- Also is there an option to copy the reports from one remote server to another at a time instead of avoiding downloading and updating

[JoanPinto]

I updated to the May 2024 version but I get this message:

I don't know if it is because the service becomes unavailable after the update.

Need Help!

[Anonymous · Accepted solution]

Hi @Roky ,

To copy reports from one server to another, consider the following methods:

• SSRS Migration Script: You can use the script to migrate report objects (including folders) from one server to another. 

rs.exe -i ssrs_migration.rss -e Mgmt2010 -s http://SourceServer/ReportServer -u Domain\User -p password -v ts="http://TargetServer/reportserver" -v tu="Domain\User" -v tp="password"

• Backup and Restore: Another approach is to back up the source ReportServer database (including the ReportServer Tempdb) and restore it on the target server. This method preserves permissions and configuration settings.
• Reporting Configuration Manager: Use this tool to configure the report server database connection after migration.
• Restart Services: Restart the SQL Server and Report Server services after migration.

Below is the official link will help you:

Sample Reporting Services rs.exe script to copy content between report servers - SQL Server Reportin...

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.