We are trying to support two SQL environments, say Development and Staging. At the stage, I made a mistake correction in one stored procedure called, for example, SProc1, at the same time, one of the developers made some changes in the same sp. I need to apply development bug fixes without losing development changes.
Using SQL Schema Compare on Visual Studio 2015 does not merge the code; it simply replaces the version directly.
My question is, what other tools are on the market to support such scenarios?
source
share