SQL Server Objects (Schema Compare with Merge)

Question

We are trying to maintain two SQL environment, let's say Development and Staging. On Staging I did a bug fix on one stored procedure called for example SProc1, at the same time someone on development was doing some changes on the same sp. I need to apply the bug fix on development without losing the changes on development.

Using SQL Schema Compare on Visual Studio 2015 doesn't do a merge of code, it's just replace the version directly.

My question is, which other tools are on the market to maintain this kind of scenarios?

Answer 1

Late answer, but I hope it will be useful to new readers

I recently stumbled upon new free tool, ApexSQL Compare, that offers files and folders comparison and merging. Tool can integrate into SSMS/VS and looks like this:

This tool will create merge script, which will include bug fix and changes on the same sp, but the script can only be executed manually. Also, to execute this script manually, CREATE PROCEDURE statement should be changed to ALTER PROCEDURE