|
 This
section of the Options dialog holds any options that affect the
overall scripting logic, as opposite to the scripting of specific
schema objects.
Transactions.
To protect you from accidental loss of data, the Diff can put
transaction code around any generated SQL. See also
here for the details of
how
SQL Code Viewer supports
transactions.
Always
begin with USE ... When you run scripts from within the Diff, the
target connections are configured for specific databases, so
explicitly choosing the database at the beginning of each script is
not necessary. However, if you plan to save the generated
scripts and then run them elsewhere, always having a USE in the
beginning may be convenient.
Use IF
NOT EXISTS logic. With
this option enabled, every CREATE statement will be preceded by a
check whether the object already exists. Note that this
option is used only
in CREATE scripts (that is, when the Diff
doesn't know what database the script will be executed
against). A difference script also can contain CREATE
statements, but the "IF NOT EXISTS..." logic will not be included
there.
NOTE: Starting from Diff
1.96 Build 98, the IF NOT EXISTS logic is implemented for all
supported schema objects. Earlier versions only had it for tables
and stored procedures.
|
