Conditional creation scripts
Brian Donahue
Posts: 6,590 Bronze 1
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!
Regards,
Brian Donahue
Red Gate Technical Support
"Peter Thistleton" <peter.thistleton@achievehealthcare.com> wrote in message
news:KODbutobEHA.3276@server53...
> 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.
>
>
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!
Regards,
Brian Donahue
Red Gate Technical Support
"Peter Thistleton" <peter.thistleton@achievehealthcare.com> wrote in message
news:KODbutobEHA.3276@server53...
> 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.
