Drop tables command on the script

pandiani · November 26, 2008 12:57PM

Is there a way to request to DROP a Table or a StoredProc in case it exists as the MSSQL scripting engine does??

F

Eddie D · November 28, 2008 1:26PM

Thank you for your post into the forum.

Unfortunately this feature is not currently available in SQL Compare.

I have the details of this forum post to an existing feature request. The reference for this feature request is SC2909. Hopefully this feature will apppear in a future version of SQL Compare.

Many Thanks
Eddie

prodigit · February 20, 2009 9:34AM

Dear Eddie,

Is this option already available?

This would come in very handy for us. We apply updates to several slightly different databases and we have to modify each synchronisation script manually.

David Atkinson · February 20, 2009 11:57AM

Hi,

Sorry, we haven't put this feature in yet. We've considered this a number of times but it goes a little against the purpose of SQL Compare, which is to generate a script specific to two data sources. What you might want to consider is to write a small application that does a comparison at runtime, such as is done in this example:

http://www.wahooga.com/index.php/2008/0 ... ma-part-i/

Thanks,

David Atkinson
Product Manager
Red Gate Software

prodigit · February 20, 2009 12:46PM

Hi David,

Is this still planned? I noticed you created a feature request for this in 2006:

The reference for this feature request is SC2909

Also, if i'm not mistaken, this feature was included in v2.xx and was abandonned later.

Thanks, Jan

pandiani · February 20, 2009 12:49PM

David,

We all understand this might not be part of the purpose of the tool itself, but I think you should reconsider it as we the uses might expand the usage of the tool outside the initial scope of the intended way ...

Filippo

David Atkinson · February 20, 2009 1:12PM

pandiani wrote:

David,

We all understand this might not be part of the purpose of the tool itself, but I think you should reconsider it as we the uses might expand the usage of the tool outside the initial scope of the intended way ...

Filippo

Yes, we definitely haven't ruled it out and it's a request we get on a fairly frequent basis. Hopefully we'll be able to put it in a future release.

Thanks for giving us the feedback.

David

Drop tables command on the script

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk