SqlScript element (Sql extension)
SQL Script
Attributes
BinaryRef
string requiredReference to Binary stream that contains the SQL script to execute.
ContinueOnError
wxs:YesNoTypeUnionContinue executing scripts even if this one fails.
ExecuteOnInstall
wxs:YesNoTypeUnionSpecifies to execute the script when the associated component is installed. This attribute is mutually exclusive with the RollbackOnInstall, RollbackOnReinstall and RollbackOnUninstall attributes.
ExecuteOnReinstall
wxs:YesNoTypeUnionSpecifies 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.
ExecuteOnUninstall
wxs:YesNoTypeUnionSpecifies to execute the script when the associated component is uninstalled. This attribute is mutually exclusive with the RollbackOnInstall, RollbackOnReinstall and RollbackOnUninstall attributes.
Id
stringUnique identifier in your installation package for this sql script. If an Id is not provided, one will generated for you.
RollbackOnInstall
wxs:YesNoTypeUnionSpecifies 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.
RollbackOnReinstall
wxs:YesNoTypeUnionSpecifies 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.
RollbackOnUninstall
wxs:YesNoTypeUnionSpecifies 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.
Sequence
wxs:IntegerSpecifes 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.
SqlDb
stringId of the SqlDatabase to execute the script against. Required when not child of SqlDatabase.
User
stringOptional user used to connect to database.