SQL Server Objects (Schema Compare with Merge) -


we trying maintain 2 sql environment, let's development , staging. on staging did bug fix on 1 stored procedure called example sproc1, @ same time on development doing changes on same sp. need apply bug fix on development without losing changes on development.

using sql schema compare on visual studio 2015 doesn't merge of code, it's replace version directly.

my question is, other tools on market maintain kind of scenarios?

there no correct answer here. you've created conflict between environments , way resolve compare source of each version , merge differences manually.

while strictly off-topic stack overflow, i'd recommend application called beyond compare kinds of file comparisons. excel @ text comparisons though.

alternatively, you've mentioned using tfs. assuming development changes have been checked in development branch, create branch off hotfix although previous check in, apply changes, merge back. present conflict need manually rectifying per beyond compare, retain conflict history in version control.

edit: following gif explains process better can:

enter image description here source


Comments

Popular posts from this blog

gridview - Yii2 DataPorivider $totalSum for a column -

java - Suppress Jboss version details from HTTP error response -

Sass watch command compiles .scss files before full sftp upload -