combining multiple reportservers into one reportserver - toughts

I am currently in a SQL consolidation proces; many SQL servers will be merged into one big SQL server. Several applications are using reportserver (i.a. Dynamics AX2009). Since Reportserver is using GUIDs for referential IDs, merging reportserver databases should be possible. Does somebody have experience with merging reportserver databases and some useful hints?

asked Feb 13 '12 at 02:35 PM in Default

Wilfred van Dijk
549 ● 13 ● 18 ● 20

(comments are locked)

1 answer:

Merging Reporting Services databases can be tricky even it uses GUIDs for referential IDs. There are encrypted data in the database and a lot of other things.

The easiest way to merge/migrate reports from one or multiple reporting services servers/databases is to use s Reporting Services Scripter. It's GUI utilizing the rs.exe and allows you easily script whatever report, schedule, role. Then you simply run the script on destination server and you are done.