[wix-users] ExecuteOnInstall and RollbackOnUninstall attributes on SqlScript

[Ven H]

If I include both ExecuteOnInstall and RollbackOnUninstall attributes on
SqlScript element in Visual Studio, it throws a build error saying "The
sql:SqlScript/@RollbackOnUninstall attribute cannot be specified when
attribute ExecuteOnInstall, ExecuteOnReinstall, or ExecuteOnUninstall is
also present."

I am trying this with the intention that, the changes caused by the script
during installation will be rolled back during the uninstall phase. Since
it is not possible to set both the attributes, what is the best way to
rollback the changes during uninstallation. Please advise.


Regards,
Venkatesh