Red Gate forums :: View topic - IF [NOT] EXISTS Checks
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Compare 10
SQL Data Compare 10 forum

IF [NOT] EXISTS Checks

Search in SQL Data Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
aleko



Joined: 28 Feb 2012
Posts: 5

PostPosted: Fri Apr 27, 2012 4:38 pm    Post subject: IF [NOT] EXISTS Checks Reply with quote

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
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 939
Location: Red Gate Software

PostPosted: Fri Apr 27, 2012 5:54 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
lkalman@financemgr.com



Joined: 11 Apr 2012
Posts: 22

PostPosted: Thu May 24, 2012 7:39 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message Send e-mail
chris eckhout



Joined: 25 Oct 2012
Posts: 1

PostPosted: Thu Oct 25, 2012 2:34 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
lkalman@financemgr.com



Joined: 11 Apr 2012
Posts: 22

PostPosted: Thu Mar 07, 2013 9:39 pm    Post subject: Any new Status on Reply with quote

Any Ideas on when this will be in production
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group