Settings and activity

  1. 215 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    16 comments  ·  SQL Data Compare  ·  Flag idea as inappropriate…  ·  Admin →

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    An error occurred while saving the comment
    Mike commented  · 

    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.

    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.