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
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
_________________
Steve Tanori
Product Support
Red Gate Software Ltd.
866-997-0378
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.
Comments
Best Regards,
Steve
Steve Tanori
Product Support
Red Gate Software Ltd.
866-997-0378
Any Ideas when it will be released.
This is something that I really in need for.
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.