How can we help you today? How can we help you today?

if exists for insert statements

Is there any way to add the existence checks prior to performing inserts/deletes when generating migration script with SQL Data Compare? That would allow me to make this script re-runnable
lkalman
0

Comments

5 comments

Sort by
  • stanori
    Thanks for your post. Currently, what you are asking for has been submitted as a feature request. The number for your reference is SDC-828. I will add you to the requestor list.

    Best Regards,
    Steve
    stanori
    0
  • lkalman
    Thats great news

    Any Ideas when it will be released.
    lkalman
    0
  • lkalman
    Just checking on any updates on this request
    lkalman
    0
  • lkalman
    Any news on SDC-828.

    This is something that I really in need for.
    lkalman
    0
  • Jemmeh
    Checking to see if there's any news on this.

    Also if it's implemented, I think this Stack Overflow question should be looked at for a slightly different solution that should run faster.
    From my understanding If Exists has some issues with being slower because it hits the database twice instead of just once.
    http://stackoverflow.com/questions/1354 ... sql-server


    I know that SQL 2008+ has MERGE but those of us working on older systems don't have that luxury. :(
    Jemmeh
    0

Add comment

Please sign in to leave a comment.