Settings and activity

1 result found

1. add If not exists to data compare

   225 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   18 comments  ·  SQL Data Compare  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   AdminStephanie (Product Manager, Redgate) responded

   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
   Steve Haley commented  ·  Nov 29, 2016  ·  Edit…  ·  Delete…

   Would like this feature, Right now I'm having to go in to every INSERT INTO, and add a IF NOT EXISTS before each line. Use case: occasionally we distribute table entries "early" to select databases, but still want to include in main release scripts.

   Save Submitting...
   Steve Haley supported this idea  ·  Nov 29, 2016