Hi as i prepare for using source control, it occurs to me report builder is the most common way we edit and save reports to ssrs. Is there a hook into dev ops from report builder when a developer prefers RB for ssrs modification? or will we need to get vs involved also after the developer has done his/her thing in RB?
As far as I am aware, there is no source control module for report builder. But that being said, there is no reason you need visual studio either. There area lot of tools out there to manage source control, so if the developers prefer RB over VS, they are choosing to ALSO use some other tool for their source control. For example, with Git source control you have a host of servers you can set up - github, gitlab, gerrit, bitbucket, probably more that I'm not thinking of - and multiple desktop applications you can use - SourceTree and command line are what is used in my environment, but as you said Visual Studio works too.
You could even set up a powershell job that pulls all of the rdl's from the report server and pushes them up to git nightly and it wouldn't be that hard to do. Downside is you'd not be able to have any commit comments as it would be automated unless you got some AI doing that bit, but that feels like overkill for something like this.
The developers should be doing code review prior to release and if they are, then source control is a great way to manage that and it can just be part of their release process - push to source control, get code reviewed, merge to main, push to live. Anything not in main doesn't go live.
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply