I had the same concern. Actually this solution implies to have the SQLCMD tool on the machine you're running the installer on. The only workaround I could find for this was to make myself a customaction which parses the script (with regex) to replace $() by some value and remove :setvar. Additionnally, since ADO.NET does not supports GO in CommandText, I also had to split the script on GO. No I can say it works pretty well.
Hope it helps also. Nicolas Penin -----Message d'origine----- De : Neil Sleightholm [mailto:n...@x2systems.com] Envoyé : jeudi 24 novembre 2011 16:20 À : General discussion for Windows Installer XML toolset. Objet : Re: [WiX-users] how to run a sql script in SQLCMD Mode using WIX Tool Does this help http://neilsleightholm.blogspot.com/search/label/SQL Neil On 24 Nov 2011, at 14:39, Nageswara wrote: Hi Team, Can you please let me know how to run a sql script in SQLCMD Mode using WIX Tool -- View this message in context: http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/how-to-run-a-sql-script-in-SQLCMD-Mode-using-WIX-Tool-tp7028337p7028337.html Sent from the wix-users mailing list archive at Nabble.com<http://Nabble.com>. ------------------------------------------------------------------------------ All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity, and more. Splunk takes this data and makes sense of it. IT sense. And common sense. http://p.sf.net/sfu/splunk-novd2d _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users ------------------------------------------------------------------------------ All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity, and more. Splunk takes this data and makes sense of it. IT sense. And common sense. http://p.sf.net/sfu/splunk-novd2d _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users ------------------------------------------------------------------------------ All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity, and more. Splunk takes this data and makes sense of it. IT sense. And common sense. http://p.sf.net/sfu/splunk-novd2d _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
