I built an extension that uses SqlFormattedScript elements. It's basically just SqlScript, plus formatting. I used the same design, up to and including the table it stores into in the final MSI DB. I just rename it for my own purposes. I then take advantage of the fact that SqlScript elements just schedule sql for running in a deferred CA, and I load the scripts in myself in a DTF CA, and schedule them the same way. I also make sure to load in the WixSqlExtension stuff, including it's CA's.
I did it at work, and if they're fine with me sharing that, then I'll be happy to do so. I would assume it wouldn't be included as part of the official distro, since it's DTF dependent, not all native. Worst case, you could reimplement using this design, as it works like a champ for me. Chris On Mon, Aug 11, 2008 at 2:36 PM, Eitan Behar <[EMAIL PROTECTED]> wrote: > Hi, > > I am willing to write the CA. Some writing using DFT sounds cool. But, the > only solution that comes to my mind is: loop through the Binary table, > export every Sql script, do a find and replace, import the Sql script back > to the database. My scripts are pretty long, and I don't want to paste them > into wix every time I change it. I prefer the approach, change script, push > red button "build and deploy". > > If you think about an easier way to custom action it, I will appreciate it. > > Thanks, > > Eitan > > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Christopher > Karper > Sent: Monday, August 11, 2008 8:10 PM > To: General discussion for Windows Installer XML toolset. > Subject: Re: [WiX-users] Dynamically naming a database during its > installation - WiX VERSION 3.0.4318.0 > > No, you're right, you can only assign explicit scripts. By "load", I > meant > copy & paste. > > The two elements have different capabilities, and unfortunately for you, > you're looking for one that's only available with SqlString. > > You either have to cut & paste your statements into the .wxs, or write your > own CA to do the work. > > Chris > > On Mon, Aug 11, 2008 at 9:31 AM, Eitan Behar <[EMAIL PROTECTED]> wrote: > > > Hi, > > > > Please, can you expand a little more on how to load the scripts into a > > sqlstring and use the properties? > > > > I only saw how to assign SqlString explicit scripts, and not reading the > > scripts from a .sql file in the Binary table. > > > > Thanks in advance, > > > > Eitan > > > > > > > > On Fri, Aug 8, 2008 at 12:40 AM, Christopher Karper < > > [EMAIL PROTECTED]> wrote: > > > > > There is not anything built in to Wix right now that will let you use > > > variables in SqlScripts. You can load them into SqlString elements > and > > > use > > > the normal [property] syntax. > > > > > > You can build a CA that will do this as well, which is what I did. > > > > > > Good luck! > > > Chris > > > > > > On Thu, Aug 7, 2008 at 5:01 PM, Nic Barden <[EMAIL PROTECTED]> > wrote: > > > > > > > Sorry forgot to mention I am running the latest WiX version - > > 3.0.4318.0. > > > > And SQL 2005 if that makes any difference. > > > > > > > > > > > > > > > > Hi guys, > > > > > > > > > > > > > > > > I am trying to use the SqlDatabase and SqlScript elements to install > a > > > > database and run some scripts to generate stored procs and tables > etc. > > > > > > > > What I would ideally like is the user to be able to specify the > > database > > > > name in the setup UI, and then use that within the scripts. > > > > > > > > The SqlDatabase element has a "Database" attribute which specifies > the > > > name > > > > of the database to create, so obviously this can be a WiX variable at > > > > runtime. > > > > > > > > However, inside the sql scripts I need to reference the name of the > > > > database > > > > also. I am unsure whether it is possible to pass parameters into the > > > > script > > > > at run time? > > > > > > > > > > > > > > > > How would this task normally be achieved? Do we have to hard code > the > > > > database name and then manually change it? :-( > > > > > > > > > > > > > > > > Thanks for your help! > > > > > > > > > > ------------------------------------------------------------------------- > > > > 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 > ------------------------------------------------------------------------- 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
