WIX在卸载过程中运行sqlcmd

问题描述：

我有一个wix安装程序，它将sqlclr安装到数据库中。我正在使用sqlcmd来运行脚本。WIX在卸载过程中运行sqlcmd

我还想在用户删除应用程序时删除sqlclr。这是我迄今为止，它似乎并没有工作。

<InstallExecuteSequence> 
    <Custom Action="sqlcmd.install" After="InstallFiles">NOT Installed</Custom> 
    <!--Ensure this runs after the CA to set up the property for its cmd line--> 
    <Custom Action="sqlcmd" After="sqlcmd.install">NOT Installed</Custom> 
    <Custom Action="NewerVersion" After="FindRelatedProducts">NEWERVERSIONDETECTED</Custom> 
    <RemoveExistingProducts After="InstallInitialize" /> 
    <Custom Action="sqlcmd.uninstall" After="InstallInitialize">Installed AND NOT UPGRADINGPRODUCTCODE</Custom> 
</InstallExecuteSequence> 
<!--Find sqlcmd.exe path--> 
<Property Id="SQLBINDIR"> 
    <RegistrySearch Id="SqlBinDir" Root="HKLM" Key="SOFTWARE\Microsoft\Microsoft SQL Server\90\Tools\ClientSetup" Name="Path" Type="raw" /> 
</Property> 
<!--Need to use "property" CA to get variable substitution--> 
<CustomAction Id="sqlcmd.install" Property="sqlcmd" Value="&quot;[SQLBINDIR]sqlcmd.exe&quot; -S [SQLSERVER] -d [SQLDATABASE] -U [SQLUSER] -P [SQLPASSWORD] -i &quot;[#Install.sql]&quot; -v PROGRAMDIR=&quot;[APPLICATIONFOLDER]&quot;" /> 
<!--Note that the cmd line and args will come from a property with the same name as the CA, this has been set by the CA above--> 
<CustomAction Id="sqlcmd" BinaryKey="WixCA" DllEntry="CAQuietExec" Return="check" Execute="deferred" Impersonate="yes" /> 
<CustomAction Id="sqlcmd.uninstall" Property="sqlcmd" Value="&quot;[SQLBINDIR]sqlcmd.exe&quot; -S [SQLSERVER] -d [SQLDATABASE] -U [SQLUSER] -P [SQLPASSWORD] -i &quot;[#Uninstall.sql]&quot;" />

答

这里是对任何感兴趣的人的修复。

似乎我的卸载遇到鸡或鸡蛋问题。我的uninstall.sql文件在执行sqlcmd之前被删除。所以我在RemoveFiles之前将卸载更改为occure。

<InstallExecuteSequence> 

    <Custom Action="installcmd.install" After="InstallFiles">NOT Installed</Custom> 
    <!--Ensure this runs after the CA to set up the property for its cmd line--> 
    <Custom Action="installcmd" After="installcmd.install">NOT Installed</Custom> 

    <Custom Action="uninstallcmd.uninstall" Before="RemoveFiles">Installed AND NOT REINSTALL</Custom> 
    <!--Ensure this runs after the CA to set up the property for its cmd line--> 
    <Custom Action="uninstallcmd" After="uninstallcmd.uninstall">Installed AND NOT REINSTALL</Custom> 

    <Custom Action="NewerVersion" After="FindRelatedProducts">NEWERVERSIONDETECTED</Custom> 
    <RemoveExistingProducts After="InstallInitialize"/> 

</InstallExecuteSequence> 



<!--Find sqlcmd.exe path--> 
<Property Id="SQLBINDIR"> 
    <RegistrySearch Id="SqlBinDir" Root="HKLM" Key="SOFTWARE\Microsoft\Microsoft SQL Server\130\Tools\ClientSetup" Name="Path" Type="raw" /> 
</Property> 

<!--Need to use "property" CA to get variable substitution--> 
<CustomAction Id="installcmd.install" Property="installcmd" Value="&quot;[SQLBINDIR]sqlcmd.exe&quot; -S [SQLSERVER] -d [SQLDATABASE] -U [SQLUSER] -P [SQLPASSWORD] -i &quot;[#Install.sql]&quot; -v PROGRAMDIR=&quot;[PROGRAMDIR]&quot;" /> 
<!--Note that the cmd line and args will come from a property with the same name as the CA, this has been set by the CA above--> 
<CustomAction Id="installcmd" BinaryKey="WixCA" DllEntry="CAQuietExec" Return="check" Execute="deferred" Impersonate="yes" /> 

<CustomAction Id="uninstallcmd.uninstall" Property="uninstallcmd" Value="&quot;[SQLBINDIR]sqlcmd.exe&quot; -S [SQLSERVER] -d [SQLDATABASE] -U [SQLUSER] -P [SQLPASSWORD] -i &quot;[#Uninstall.sql]&quot;" /> 
<!--Note that the cmd line and args will come from a property with the same name as the CA, this has been set by the CA above--> 
<CustomAction Id="uninstallcmd" BinaryKey="WixCA" DllEntry="CAQuietExec" Return="check" Execute="deferred" Impersonate="yes" />

WIX在卸载过程中运行sqlcmd

相关推荐