Hi What is the WiX build you are using to build the MSI ?
I got a WiX project with one database creation and multiple XML file modifications and that works fine. But I had issues creating the database in MSI built with WiX 3.5 Build 1602. Regards, Asiri Wanigarathne http://www.asiri.name On 21 April 2010 22:23, Will Sullivan <wsulli...@softdocs.com> wrote: > XmlFile breaks SqlDatabase. > > See > http://stackoverflow.com/questions/2602950/wix-xmlfile-is-keeping-sqldatabase-from-creating-databasesand > https://sourceforge.net/tracker/?func=detail&aid=2986062&group_id=105970&atid=642714 > > -----Original Message----- > From: Carolina Zuqueto Amaral [mailto:carolina.ama...@conv.com.br] > Sent: Friday, April 16, 2010 8:21 AM > To: 'General discussion for Windows Installer XML toolset.' > Subject: [WiX-users] Execute a script > > Hi, > > I created a path for to do the following changes: > > > - Remove a file > > - Update some files > > - Execute a script > > But, the third option did not work. > > > Setup Commands: > > <?xml version="1.0" encoding="UTF-8"?> > <Wix xmlns="http://schemas.microsoft.com/wix/2006/wi"; > xmlns:Util="http://schemas.microsoft.com/wix/UtilExtension"; > xmlns:Sql="http://schemas.microsoft.com/wix/SqlExtension";> > <Product Id="{F57E0806-B8E9-4e4b-A4B7-83797657175E}" > Name="WiX Patch Example Product" > Language="1064" > Version="1.0.0" > Manufacturer="Convergencia" > UpgradeCode="{71C36DBF-DED5-4367-8D27-ED1D438AADC6}"> > <Package Description="Installs a file that will be patched." > Comments="This Product does not install any executables" > InstallerVersion="200" > Compressed="yes" /> > <Media Id="1" /> > <?define path = > "C:\Dev\usr\carolina.amaral\PatchCreation\Product\Product"?> > <?define Version = "1.1"?> > <?define RTMProductVersion="0.0.0" ?> > <?define ProductVersion="1.0.0" ?> > <?define UpgradeCode="{F57E0806-B8E9-4e4b-A4B7-83797657175E}"?> > <Property Id="ALLUSERS">1</Property> > <Property Id="ProductID">none</Property> > <Property Id="DBNAME">ConvergenciaAHClientCFG</Property> > <Property Id="SQLSN">(local)\CONVERGENCIA</Property> > <Property Id="WIXUI_INSTALLDIR" Value="INSTALLLOCATION" /> > <Property Id="WIXUI_DATA" Value="DATA" /> > > <Directory Id="TARGETDIR" Name="SourceDir"> > <Directory Id="ProgramFilesFolder" Name="PFiles"> > <Directory Id="INSTALLLOCATION" Name="Patch Sample Directory"> > <Component Id="SampleComponent" > Guid="{C28843DA-EF08-41CC-BA75-D2B99D8A1983}" DiskId="1"> > <File Id="SampleFile" Name="Sample.txt" > Source="$(var.path)\1.1\Sample.txt" Compressed="no" /> > <File Id="ConvergenciaAHAppexeCONFIG" > Name="Convergencia.AH.App.exe.config" > Source="$(var.path)\$(var.Version)\Convergencia.AH.App.exe.config" > Compressed="no" /> > <File Id="WpfControlLibraryDLL" Name="WpfControlLibrary.dll" > Source="$(var.path)\$(var.Version)\WpfControlLibrary.dll" Compressed="no" > /> > <File Id="WpfUpdatableAppEXE" Name="WpfUpdatableApp.exe" > Source="$(var.path)\$(var.Version)\WpfUpdatableApp.exe" Compressed="no" /> > </Component> > > <Directory Id="DataFolder" Name="DATA"> > <Component Id="DataFolderComp" > Guid="{C0054A15-8E33-49a6-B13A-8FD0743C328D}"> > <CreateFolder Directory="DataFolder"/> > </Component> > </Directory> > > <Component Id="DatabaseComp" > Guid="{FA1987E8-EBB6-4886-B2C0-C92CAACF8C84}"> > <CreateFolder/> > <Sql:SqlDatabase Id="DropDatabase" Database="[DBNAME]" > Server="[SQLSN]" DropOnInstall="yes" > ContinueOnError="yes" /> > > <Sql:SqlDatabase Id="CreateDatabase" Database="[DBNAME]" > Server="[SQLSN]" DropOnUninstall="yes" > ContinueOnError="no" > > > <Sql:SqlScript Id="BinarySql" ExecuteOnInstall="yes" > ExecuteOnUninstall="no" BinaryKey="ScriptDB" > ContinueOnError="no" Sequence="1"/> > </Sql:SqlDatabase> > </Component> > > </Directory> > </Directory> > </Directory> > > <Upgrade Id="$(var.UpgradeCode)"> > <UpgradeVersion Minimum="$(var.ProductVersion)" > IncludeMinimum="no" > Language="1046" > OnlyDetect="yes" > Property="NEWPRODUCTFOUND" /> > <UpgradeVersion Minimum="$(var.RTMProductVersion)" > IncludeMinimum="yes" > Language="1046" > Maximum="$(var.ProductVersion)" > IncludeMaximum="no" > Property="UPGRADEFOUND" /> > </Upgrade> > > <CustomAction Id ="SAVETARGETDIR" Property="ARPINSTALLLOCATION" > Value="INSTALLLOCATION"/> > > <Binary Id="ScriptDB" > SourceFile=".\sources\FACTConfigurationScript.sql"/> > <Binary Id="InsertDB" SourceFile=".\sources\FactInsert.sql" /> > > <InstallExecuteSequence> > <Custom Action="SAVETARGETDIR" After="InstallValidate"/> > <RemoveExistingProducts After="InstallInitialize" /> > </InstallExecuteSequence> > > <Feature Id="SampleProductFeature" Title="Sample Product Feature" > Level="1"> > <ComponentRef Id="SampleComponent" /> > <ComponentRef Id="DatabaseComp"/> > <ComponentRef Id="DataFolderComp"/> > </Feature> > </Product> > </Wix> > > > Upgrade Commands: > > <?xml version="1.0" encoding="UTF-8"?> > <Wix xmlns="http://schemas.microsoft.com/wix/2006/wi"; > xmlns:Util="http://schemas.microsoft.com/wix/UtilExtension"; > xmlns:Sql="http://schemas.microsoft.com/wix/SqlExtension";> > <Product Id="{F57E0806-B8E9-4e4b-A4B7-83797657175E}" > Name="WiX Patch Example Product" > Language="1064" > Version="1.0.1" > Manufacturer="Convergencia" > UpgradeCode="{71C36DBF-DED5-4367-8D27-ED1D438AADC6}"> > <Package Description="Installs a file that will be patched." > Comments="This Product does not install any executables" > InstallerVersion="200" > Compressed="yes" /> > <Media Id="1" /> > <?define path = > "C:\Dev\usr\carolina.amaral\PatchCreation\Product\Product"?> > <?define Version = "1.1"?> > <?define RTMProductVersion="1.0.0" ?> > <?define ProductVersion="1.0.1" ?> > <?define UpgradeCode="{F57E0806-B8E9-4e4b-A4B7-83797657175E}"?> > <Property Id="ALLUSERS">1</Property> > <Property Id="ProductID">none</Property> > <Property Id="DBNAME">ConvergenciaAHClientCFG</Property> > <Property Id="SQLSN">(local)\CONVERGENCIA</Property> > <Property Id="WIXUI_INSTALLDIR" Value="INSTALLLOCATION" /> > <Property Id="WIXUI_DATA" Value="DATA" /> > > <Directory Id="TARGETDIR" Name="SourceDir"> > <Directory Id="ProgramFilesFolder" Name="PFiles"> > <Directory Id="INSTALLLOCATION" Name="Patch Sample Directory"> > <Component Id="SampleComponent" > Guid="{C28843DA-EF08-41CC-BA75-D2B99D8A1983}" DiskId="1"> > <File Id="ConvergenciaAHAppexeCONFIG" > Name="Convergencia.AH.App.exe.config" > Source="$(var.path)\$(var.Version)\Convergencia.AH.App.exe.config" > Compressed="no" /> > <File Id="WpfControlLibraryDLL" Name="WpfControlLibrary.dll" > Source="$(var.path)\$(var.Version)\WpfControlLibrary.dll" Compressed="no" > /> > <File Id="WpfUpdatableAppEXE" Name="WpfUpdatableApp.exe" > Source="$(var.path)\$(var.Version)\WpfUpdatableApp.exe" Compressed="no" /> > <RemoveFile Id="RemoveTXT" Name="Sample.txt" On="install"/> > </Component> > > <Directory Id="DataFolder" Name="DATA"> > <Component Id="DataFolderComp" > Guid="{C0054A15-8E33-49a6-B13A-8FD0743C328D}"> > <CreateFolder Directory="DataFolder"/> > </Component> > </Directory> > > <Component Id="DatabaseComp" > Guid="{FA1987E8-EBB6-4886-B2C0-C92CAACF8C84}"> > <CreateFolder/> > > <Sql:SqlDatabase Id="FACT4SQLDatabase" Database="[DBNAME]" > Server="[SQLSN]" ContinueOnError="no" > CreateOnInstall="no" CreateOnReinstall="yes"> > > <Sql:SqlScript Id="scriptInsert" BinaryKey ="InsertDB" ContinueOnError="no" > ExecuteOnInstall="yes" Sequence="1"/> > </Sql:SqlDatabase> > </Component> > > </Directory> > </Directory> > </Directory> > > <Upgrade Id="$(var.UpgradeCode)"> > <UpgradeVersion Minimum="$(var.ProductVersion)" > IncludeMinimum="no" > Language="1046" > OnlyDetect="yes" > Property="NEWPRODUCTFOUND" /> > <UpgradeVersion Minimum="$(var.RTMProductVersion)" > IncludeMinimum="yes" > Language="1046" > Maximum="$(var.ProductVersion)" > IncludeMaximum="no" > Property="UPGRADEFOUND" /> > </Upgrade> > > <CustomAction Id ="SAVETARGETDIR" Property="ARPINSTALLLOCATION" > Value="INSTALLLOCATION"/> > > <Binary Id="ScriptDB" > SourceFile=".\sources\FACTConfigurationScript.sql"/> > <Binary Id="InsertDB" SourceFile=".\sources\FactInsert.sql" /> > > <InstallExecuteSequence> > <Custom Action="SAVETARGETDIR" After="InstallValidate"/> > <RemoveExistingProducts After="InstallInitialize" /> > </InstallExecuteSequence> > > <Feature Id="SampleProductFeature" Title="Sample Product Feature" > Level="1"> > <ComponentRef Id="SampleComponent" /> > <ComponentRef Id="DatabaseComp"/> > <ComponentRef Id="DataFolderComp"/> > </Feature> > </Product> > </Wix> > > > > Patch Commands: > > > <?xml version="1.0" encoding="utf-8"?> > <Wix xmlns="http://schemas.microsoft.com/wix/2006/wi";> > <PatchCreation > Id="{BE9AB67E-7226-4ef0-8F0A-D68183543979}" > CleanWorkingFolder="yes" > OutputPath="patch.pcp" > WholeFilesOnly="yes" > > > > <PatchInformation > Description="Small Update Patch" > Comments="Small Update Patch" > ShortNames="no" > Languages="1064" > Compressed="yes" > Manufacturer="Dynamo Corp"/> > > <PatchMetadata > AllowRemoval="yes" > Description="Small Update Patch" > ManufacturerName="Dynamo Corp" > TargetProductName="Sample" > MoreInfoURL="http://www.dynamocorp.com/"; > Classification="Update" > DisplayName="Sample Patch"/> > > <Family DiskId="5000" > MediaSrcProp="Sample" > Name="Sample" > SequenceStart="5000"> > <UpgradeImage SourceFile="C:\Teste\Upgrade\Product.msi" Id="Upgrade"> > <TargetImage SourceFile="C:\Teste\Setup\Product.msi" Order="2" > Id="Target" IgnoreMissingFiles="no" /> > </UpgradeImage> > </Family> > > <TargetProductCode Id="{F57E0806-B8E9-4e4b-A4B7-83797657175E}"/> > > <PatchSequence PatchFamily="SamplePatchFamily" > Sequence="1.0.0.0" > Supersede="yes" /> > > </PatchCreation> > </Wix> > > > How do I execute a script using a patch? > > > Thanks, > > Carolina Zuqueto Amaral > carolina.ama...@conv.com.br<mailto:carolina.ama...@conv.com.br> > tel +55 21 2494-5476 > cel +55 21 9524-7186 > > > ________________________________ > Confidencialidade: A informa??o contida nesta mensagem de e-mail, incluindo > quaisquer anexos, ? confidencial e est? reservada apenas ? pessoa ou > entidade para a qual foi endere?ada. Se voc? n?o ? o destinat?rio ou a > pessoa respons?vel por encaminhar esta mensagem ao destinat?rio, voc? est?, > por meio desta, notificado que n?o dever? rever, retransmitir, imprimir, > copiar, usar ou distribuir esta mensagem de e-mail ou quaisquer anexos. Caso > voc? tenha recebido esta mensagem por engano, por favor, contate o remetente > imediatamente e apague esta mensagem de seu computador ou de qualquer outro > banco de dados. Grato. > > Confidentiality Notice: The information contained in this email message, > including any attachment, is confidential and is intended only for the > person or entity to which it is addressed. If you are neither the intended > recipient nor the employee or agent responsible for delivering this message > to the intended recipient, you are hereby notified that you may not review, > retransmit, convert to hard copy, copy, use or distribute this email message > or any attachments to it. If you have received this email in error, please > contact the sender immediately and delete this message from any computer or > other data bank. Thank you. > > ------------------------------------------------------------------------------ > Download Intel® Parallel Studio Eval Try the new software tools for > yourself. Speed compiling, find bugs proactively, and fine-tune applications > for parallel performance. > See why Intel Parallel Studio got high marks during beta. > http://p.sf.net/sfu/intel-sw-dev > _______________________________________________ > WiX-users mailing list > WiX-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/wix-users > > > ------------------------------------------------------------------------------ > _______________________________________________ > WiX-users mailing list > WiX-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/wix-users > ------------------------------------------------------------------------------ _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
