if exists for insert statements

lkalman@financemgr.com

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

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

Thats great news

Any Ideas when it will be released.

lkalman@financemgr.com

Just checking on any updates on this request

lkalman@financemgr.com

Any news on SDC-828.

This is something that I really in need for.

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.