If anyone is interested I have just posted a blog showing how to run sqlcmd from WiX: http://neilsleightholm.blogspot.com/2008/08/executing-sqlcmd-from-wix.ht ml.
Neil -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Neil Sleightholm Sent: 22 August 2008 06:25 To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] Passing Parameters to a SQL file I agree that would be a useful addition, I am trying to replace an existing install that shells out to sqlcmd and passes command line option to that. One option might be to do the same with WiX. Neil -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Eitan Behar Sent: 22 August 2008 05:33 To: 'General discussion for Windows Installer XML toolset.' Subject: Re: [WiX-users] Passing Parameters to a SQL file Well, this sounds like a good workaround, but I wanted to do it Install Shield style, where you can just place parameters (like %blabla%) and assign them to MSI properties. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dana Gutride Sent: Thursday, August 21, 2008 5:48 PM To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] Passing Parameters to a SQL file How many parameters are you talking about? If it's just a few, why don't you use a sqlstring action to put them in some temporary table in your db, read them out with your scripts and get them that way. SqlScripts are not designed for passing in parameters and they most likely don't have access to regular MSI properties because I believe they run deferred. Dana On Thu, Aug 21, 2008 at 10:18 AM, Eitan Behar <[EMAIL PROTECTED]> wrote: > Hi, > > I know that I already asked this already, but maybe somebody new to the > list > has an answer. > > I need an easy way to pass parameters to a SQL file using <SqlScript>. I > cannot use <SqlString> since the scripts are generated automatically, and > are pretty long. > > Thanks, > > Eitan > ------------------------------------------------------------------------ - > This SF.Net email is sponsored by the Moblin Your Move Developer's > challenge > Build the coolest Linux based applications with Moblin SDK & win great > prizes > Grand prize is a trip for two to an Open Source event anywhere in the world > http://moblin-contest.org/redirect.php?banner_id=100&url=/ > _______________________________________________ > WiX-users mailing list > WiX-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/wix-users > ------------------------------------------------------------------------ - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users ------------------------------------------------------------------------ - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users ------------------------------------------------------------------------ - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
