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: 565
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 aBinary
entry.Inject my generated script into the
Binary
tableUsing SqlString
Which will cause the need to place some rather long strings intoProperties
, 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