Consolidate SQL Server Reporting Services
Posted
by
Eric C. Singer
on Server Fault
See other posts from Server Fault
or by Eric C. Singer
Published on 2012-06-07T19:14:40Z
Indexed on
2012/06/08
4:42 UTC
Read the original article
Hit count: 489
I've been a big fan of consolidating as many DB's to a few SQL servers for a while and I've had great success with it. However, I've never had to deal with SQL reporting services. Has anyone migrated SSRS from a bunch of random SQL servers into a consolidated SQL server? I don't exactly know a whole lot about SSRS which is part of the problem. To my knowlege, it's one DB per SSRS instance, so it sounds like i'd need to find a way of exporting data and merging it.
Basically the process used to look like:
- Move DB from SQL Express to shared SQL server
- Change point in APP to point at new SQL server
With reporting services, how do I move the reporting service compenent of the DB as well? I realize I may need to tweak the app, but my question is on the SQL side.
© Server Fault or respective owner