What are the challenges you face when working across database platforms? Take the survey

Conditional creation scripts

Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
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" <peter.thistleton@achievehealthcare.com> wrote in message
> 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.