[wix-users] Parameters in SqlScript element

[Edwin Castro]

I don't think SqlScript supports parameters.

Have you tried specifying SqlFileSpec and SqlLogFileSpec elements as
children to SqlDatabase? Have you tried setting SqlFileSpec/@FileName and
SqlLogFileSpec/@FileName to the values of the appropriate properties?
Something like

<SqlDatabase ...>
    <SqlFileSpec ... FileName="[DATA_FILE_PATH]"/>
    <SqlLogFileSpec ... FileName="[LOG_FILE_PATH]"/>
</SqlDatabase>

--
Edwin G. Castro


On Tue, Apr 10, 2018 at 12:30 AM, Ven H via wix-users <
wix-users at lists.wixtoolset.org> wrote:

> I have a .sql file which I am executing using SqlScript element in WiX.
> There are some parameters inside the .sql file which need to be passed
> during the execution of the script. Is it possible to pass parameters
> through SqlScript element? If not, is there any other way to achieve this?
>
> Also, I have a SqlDatabase element. In this I have to make the path for the
> data and log files configurable so that I can let the user decide it at run
> time during MSI installation. Even if I capture the values from the UI, how
> can I pass it to the SqlDatabase element at run time. Please help.
>
> ____________________________________________________________________
> WiX Toolset Users Mailing List provided by FireGiant
> http://www.firegiant.com/
>