Skip to main content
Version: v3

SqlScript Element (Sql Extension)

Description
SQL Script
Windows Installer references
None
Parents
Component, SqlDatabase
Inner Text
None
Children
None
Attributes
NameTypeDescriptionRequired
IdString Yes
BinaryKeyStringReference to Binary stream that contains the SQL script to execute.Yes
ContinueOnErrorYesNoTypeContinue executing scripts even if this one fails. 
ExecuteOnInstallYesNoTypeSpecifies to execute the script when the associated component is installed. This attribute is mutually exclusive with the RollbackOnInstall, RollbackOnReinstall and RollbackOnUninstall attributes. 
ExecuteOnReinstallYesNoTypeSpecifies whether to execute the script when the associated component is reinstalled. Setting ExecuteOnInstall to yes does not imply ExecuteOnReinstall is set to yes. ExecuteOnReinstall must be set in addition to ExecuteOnInstall for it to be executed during both install and reinstall. This attribute is mutually exclusive with the RollbackOnInstall, RollbackOnReinstall and RollbackOnUninstall attributes. 
ExecuteOnUninstallYesNoTypeSpecifies to execute the script when the associated component is uninstalled. This attribute is mutually exclusive with the RollbackOnInstall, RollbackOnReinstall and RollbackOnUninstall attributes. 
RollbackOnInstallYesNoTypeSpecifies whether to execute the script on rollback if an attempt is made to install the associated component. This attribute is mutually exclusive with the ExecuteOnInstall, ExecuteOnReinstall and ExecuteOnUninstall attributes. 
RollbackOnReinstallYesNoTypeSpecifies whether to execute the script on rollback if an attempt is made to reinstall the associated component. This attribute is mutually exclusive with the ExecuteOnInstall, ExecuteOnReinstall and ExecuteOnUninstall attributes. 
RollbackOnUninstallYesNoTypeSpecifies whether to execute the script on rollback if an attempt is made to uninstall the associated component. This attribute is mutually exclusive with the ExecuteOnInstall, ExecuteOnReinstall and ExecuteOnUninstall attributes. 
SequenceIntegerSpecifes the order to run the SQL Scripts. It is recommended that rollback scripts be scheduled before their complementary execution script. This order is also relative across the SqlString element. 
SqlDbStringrequired when not child of SqlDatabase 
UserString  
See Also
Sql Schema