if exists for insert statements

lkalman@financemgr.com · May 24, 2012 2:40PM

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

stanori · May 24, 2012 3:29PM

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

lkalman@financemgr.com · May 24, 2012 3:38PM

Thats great news

Any Ideas when it will be released.

lkalman@financemgr.com · May 31, 2012 11:42AM

Just checking on any updates on this request

lkalman@financemgr.com · June 5, 2012 9:34AM

Any news on SDC-828.

This is something that I really in need for.

Jemmeh · April 21, 2015 5:11PM

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.

if exists for insert statements

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk