SSMS integration - compare single object
hello, i appreciate that we only need this feature because my company's processes are lacking but what I would love to have is to be able to...
right-click an object in SSMS and click an option called something like 'compare against other environment'.
it would then bring up a message box where you could browse an object-explorer for the corresponding object.
the use cases I see all the time for this are
- when people have stored procs next to each other called
etc on the same database.
2 when you are troubleshooting and you want to double check the same object across environments. i.e.
at the moment (because we don't have source control) I have to script the objects to file and then use k-diff or winmerge. redgate sql compare seems to more appropriate for comparing whole databases and sometimes you want to focus in on one or two objects
hope that makes sense
ben b commented
Hello - this was raised and discussed in this forum post. I would personally love this feature.