Settings and activity
1 result found
-
225 votes
We've had a few requests for supporting MERGE statements - https://redgate.uservoice.com/redirect/suggestions/3100622. Would MERGE help this or are you still looking for IF EXISTS on INSERTS? If you'd like to chat about this, please reply.
An error occurred while saving the comment 
Mike
supported this idea
·
An error occurred while saving the comment Mike
commented
We also deploy a meta database on a two week sprint, and then a quarterly release. The release is a combination of all the updates, and currently we have no good way to avoid insert conflicts unless we deploy the entire meta database during the quarterly release. I am currently investigating how to modify the Insert statements that SQL Data Compare creates to add an IF NOT Exists around them. It would be nice not to have to programmatically modify the results from SQL Data Compare in order to accomplish this. The tool should handle this for me.
We've had to roll our own console app to wrap the Inserts with an If Exists. Not the best way to handle the situation. It would be nice if SQL Data Compare would do it automatically so that we don't have to clean up the generated script.