We do this using public properties and the SqlString element instead. You
end up embedding the actual sql directly in the MSI, but you can reference
the properties directly. An example follows:
<SqlString Sequence="3" Id="AddRoles" SQL="Use [DBNAME]
exec sp_addrolemember N'db_owner', N'UserName'"
ExecuteOnInstall="yes" ExecuteOnUninstall="no" SqlDb="SqlDB"/>
Dana
On 7/25/07, Arnold Layne <[EMAIL PROTECTED]> wrote:
Hi all,
How do I pass paramteres to my sql script? I would like to do something
similar to what is done by sqlcmd:
SQLCMD MyScript.sql -v Param1=Value1 -v Param2=Value2 ...
Can I do it in WIX ver 2 with the SqlScript tag?
Thanks
-al
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users