IF [NOT] EXISTS Checks

Compares and synchronizes SQL database content.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, Michelle Taylor, chengvoon.tong

IF [NOT] EXISTS Checks

Postby aleko » Fri Apr 27, 2012 4:38 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.

Thanks
aleko
 
Posts: 5
Joined: Tue Feb 28, 2012 4:08 pm

Postby eddie davis » Fri Apr 27, 2012 5:54 pm

Thank you for your post into the forum.

I have added the details of this forum post to an existing feature request, reference number SDC-828 and set the request for review.

I cannot guarantee that your request will be successful or if approval is given what future version of SQL Data Compare it will appear in.

Thank you for your suggestion and feedback.

Best Regards
Eddie
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
 
Posts: 942
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software

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

IF [NOT] EXISTS Checks.

I am very interested in this feature as well.

I agree that would allow me to make this script re-runnable.
lkalman@financemgr.com
 
Posts: 22
Joined: Wed Apr 11, 2012 2:03 pm

Postby chris eckhout » Thu Oct 25, 2012 2:34 pm

The addition of this feature would be very useful. Due to time delays within the releases and needs of other locations around the world, there are times when by time we have created the compare script, peer reviewed it, given it to the other site and they have run it, there could be over a week or more between the database being compared and the script being run. During this time, it is very possible that through outside processes some of the data which is needed for foreign keys gets entered into the database. Then, when we run the scripts, it then errors. If we had this, we would run into less chances of this happening and smoother releases to our other sites.
chris eckhout
 
Posts: 1
Joined: Thu Oct 25, 2012 2:29 pm

Any new Status on

Postby lkalman@financemgr.com » Thu Mar 07, 2013 9:39 pm

Any Ideas on when this will be in production
lkalman@financemgr.com
 
Posts: 22
Joined: Wed Apr 11, 2012 2:03 pm


Return to SQL Data Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests

cron