September 3, 2026 at 12:53 pm
Hi we're a bit behind on versioning ssrs. I think we have over 1600 reports, 65 data sources and over 700 folders on our main sql server. And a smaller amount on a separate sql server in one of our plants. for some reason we also keep xls (over 400) , pdf's (over 3,000) in the catalog as well. i'll probably push for putting a stop to that. And shared datasets (29) and report part(1) in our catalog.
I'm averse to the power bi path for paginated reports mostly because 1) we've coupled a number of OO erp extensions/apps to ssrs, 2) our effort would be significant and 3) the effort would be doubled if we were to plan things like semantic model domains and other things that would eliminate the immediate sprawl.
Right now we keep prod and dev ssrs comingled in different folders on our prod 2019 sql server. my first move would be to migrate all of it to our dev sever probably delineating clearly dev from qa or if its possible having 2 catalogs on our dev machine.
i'd also set up repos for prod, qa and dev.
can the community tell me what tools are available for migrating things like this? I know visual studio is one. What about powershell or some other mechanism?
September 3, 2026 at 1:46 pm
Are your SSRS reports all stored in VS projects.
Are they all source controlled?
Do you have automated deployments from VCS to SQL Server?
If not, that's where I would start.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply