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.

   Njama Braasch supported this idea  ·  Feb 13, 2018
   An error occurred while saving the comment
   Njama Braasch commented  ·  Feb 13, 2018  ·  Edit…  ·  Delete…

   script out a merge statement instead of a simple insert! Easy enough!

   Save Submitting...