Conditional creation scripts

Brian DonahueBrian Donahue Posts: 6,590 New member
edited July 21, 2004 1:45PM in SQL Compare Previous Versions
Hi Peter,

SQL Compare can't be set to add the if exist drop... statements. This is
done in script engines like the one in Query Analyzer (I think it's an
option), but it's loads more efficient to alter things than to blast them
off the face of the earth and re-create them all of the time.

Please let me know your concerns about this!


Brian Donahue
Red Gate Technical Support

"Peter Thistleton" <[email protected]> wrote in message
news:[email protected]
> Is there a way to get SQL Compare to always generate conditional creation
> scripts? i.e.
> if exist xxx
> Drop xxx
> Create xxx
> Rather than the simple create or alter statements.
This discussion has been closed.