How to merge multiple SSRS instance into one new single SSRS instance?

Question

I'm migrating and consolidating two SQL instances into one new SQL Server 2022 instance. For user databases these are fine as I can just backup and restore them to new instance. But how about the SSRS currently running on both source instance?

Each of them has ReportServerDB and ReportServerTempDB in native mode and has their own encryption key. How do I merge both SSRS instance into one ? I'm not from DBA background hence I do not have any idea on how to merge multiple ReportServerDB into single DB. Hopefully someone could guide me through or provide some steps/insights.

Answer 1

Hi @Marcus Wong

Unfortunately you cannot install multiple instances of SSRS on the same server . it was possible long time ago but it is not right now.

I'll suggest you to choose one of the instances and do the restore and then created a folder and redeploy all the other components from the other one

Regards

Javier

Answer 2

Hi @Marcus Wong Theen Nam,

You cannot merge two different Report Server Databases to the same one.

The best way is to choose one server, then use tools to migrate reports, datasets, and subscriptions over.

Sample Reporting Services rs.exe script to copy content between report servers

Regards，

Zoe Hui

---

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

Answer 3

You can use the "rs.exe" tool of SSRS to copy over reports from one instance to the other, see

Sample Reporting Services rs.exe script to copy content between report servers