Using wix3 SqlScript to run generated temporary sql-script files.

Posted by leiflundgren on Stack Overflow See other posts from Stack Overflow or by leiflundgren
Published on 2010-04-28T07:53:28Z Indexed on 2010/05/01 22:47 UTC
Read the original article Hit count: 557

Filed under:

wix

|

wix3

I am starting to write an installer which will use the SqlScript-element.
That takes a reference to the Binary-table what script to run.

I would like to dynamically generate the script during the installation.

I can see three possibilities:

Somehow to get SqlScript to read it data from a file rather then a Binary entry.
Inject my generated script into the Binary table
Using SqlString
Which will cause the need to place some rather long strings into Properties, but I guess that shouldn't really be a prolem.

Any advice?

Regards
Leif

(My reason, should anyone be interested is that the database should have a job set up, that calls on an installed exe-file. I prefer to create the job using sqlscript. And the path of that file is not known until InstallDir has been choosen.)

© Stack Overflow or respective owner

Related posts about wix

WiX 3: Using heat.exe to add bulk files to a new WiX project: HEAT5150

as seen on Stack Overflow - Search for 'Stack Overflow'
If this is a repeat question, please direct me to the existing solution. I wasn't able to find a matching query. We currently use InstallShield. I'm attempting to covert a project with 407 files to a WiX3 installation package. I tried using heat.exe to do some of the automation but I get the following… >>> More
Detect an Uninstall in a Launch Condition using Wix MSIs

as seen on Stack Overflow - Search for 'Stack Overflow'
I've been playing around with Wix, making a little app with auto-generated installer and three versions to test the upgradability, 1.0, 1.1 and 2.0. 1.1 is meant to be able to upgrade from 1.0, and not to allow the user to install 1.1 if 1.1 is already present. <Upgrade Id="F30C4129-F14E-43ee-BD5E-03AA89AD8E07"> … >>> More
How to modify IIS handler mapping permissions via Wix or a Custom Action

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I'm using Wix to create an installer for a Silverlight application. When I install the application the virtual directory that has been created has the execute permission checked for the *.dll handler mapping (IIS 7 Web site VDir Handler Mappings *.dll Edit Feature Permissions Execute)… >>> More
Wix XmlFile is keeping SqlDatabase from creating databases

as seen on Stack Overflow - Search for 'Stack Overflow'
I've got a Wix project made up of several fragments. One of those fragments has the database components, another has a component that manipulates xml files. When I include the XmlFile element to manipulate a file, the databases defined by the SqlDatabase do not get created. If I comment out the… >>> More
I'm referencing an WiX extension in a WiX library project -- how do I avoid having to reference this

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm referencing a WiX extension in a WiX library project. This WiX library project is itself referenced by my main WiX MSI project. Why does the main project have to also reference the WiX extension, even though it doesn't directly need it? I'd like to keep my wixlib's as self-contained as possible… >>> More

Related posts about wix3

Using wix3 SqlScript to run generated temporary sql-script files.

as seen on Stack Overflow - Search for 'Stack Overflow'
I am starting to write an installer which will use the SqlScript-element. That takes a reference to the Binary-table what script to run. I would like to dynamically generate the script during the installation. I can see three possibilities: Somehow to get SqlScript to read it data from a file… >>> More
WiX - Modifying an existing service to be dependent on the service I am installing

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi all, Using Wix3, its trivial to ensure that a windows service being installed is given a dependency on a service that is already installed on the target machine, but I need to do the opposite - i.e. as part of my install I need to modify the service dependencies of an existing service (i.e. already… >>> More
Change Wix Merge Module Package GUID?

as seen on Stack Overflow - Search for 'Stack Overflow'
When is it necessary to change the package GUID of a merge module? <Wix xmlns="http://schemas.microsoft.com/wix/2006/wi"> <Module Id="MyMergeModule" Language="1003" Version="1.0.0.0"> <Package Id="SOME_GUID" Manufacturer="Me" InstallerVersion="301" /> </Module> </Wix> Wix3… >>> More
WiX 3: Using heat.exe to add bulk files to a new WiX project: HEAT5150

as seen on Stack Overflow - Search for 'Stack Overflow'
If this is a repeat question, please direct me to the existing solution. I wasn't able to find a matching query. We currently use InstallShield. I'm attempting to covert a project with 407 files to a WiX3 installation package. I tried using heat.exe to do some of the automation but I get the following… >>> More
Wix, Launch application after installation complete, with UAC turned on.

as seen on Stack Overflow - Search for 'Stack Overflow'
Good day. I've been building an installer for our product using the WIX(Windows Installer XML) technology. The expected behavior is that the product is launched, if the check box is checked after installation. This has been working for some time now, but we found out recently that UAC of Win 7,… >>> More