if exists for insert statements

Compares and synchronizes SQL database content.

if exists for insert statements

Postby lkalman@financemgr.com » Thu May 24, 2012 7:40 pm

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@financemgr.com
 
Posts: 22
Joined: Wed Apr 11, 2012 2:03 pm

Postby stanori » Thu May 24, 2012 8:29 pm

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
stanori
 
Posts: 84
Joined: Mon Apr 23, 2012 1:13 pm

if exists for insert statements

Postby lkalman@financemgr.com » Thu May 24, 2012 8:38 pm

Thats great news

Any Ideas when it will be released.
lkalman@financemgr.com
 
Posts: 22
Joined: Wed Apr 11, 2012 2:03 pm

existence checks

Postby lkalman@financemgr.com » Thu May 31, 2012 4:42 pm

Just checking on any updates on this request
lkalman@financemgr.com
 
Posts: 22
Joined: Wed Apr 11, 2012 2:03 pm

Postby lkalman@financemgr.com » Tue Jun 05, 2012 2:34 pm

Any news on SDC-828.

This is something that I really in need for.
lkalman@financemgr.com
 
Posts: 22
Joined: Wed Apr 11, 2012 2:03 pm

Re: if exists for insert statements

Postby Jemmeh » Tue Apr 21, 2015 10:11 pm

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
 
Posts: 1
Joined: Tue Apr 21, 2015 10:04 pm


Return to SQL Data Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 1 guest