[wix-users] Patch for DB(SqlScript) with no Uninstall option available

[Rob Mensching]

Components always have a KeyPath. The KeyPath can be a: file, registry key, ODBC driver in the Component or it will be the directory of the Component. See the MSI documentation.

_____________________________________________________________
 Short replies here. Complete answers over there: http://www.firegiant.com/

-----Original Message-----
From: wix-users <wix-users-bounces at lists.wixtoolset.org> On Behalf Of Ven H via wix-users
Sent: Monday, June 11, 2018 10:22 AM
To: Edwin Castro <egcastr at gmail.com>
Cc: Ven H <venh.123 at gmail.com>; WiX Toolset Users Mailing List <wix-users at lists.wixtoolset.org>
Subject: Re: [wix-users] Patch for DB(SqlScript) with no Uninstall option available

Yes Edwin. You are right. It is adding entry into the CreateFolder table.
Is there a way to avoid it? I tried not having the KeyPath attribute by having something like this. But still, no luck. Not sure how to get it working. Without <CreateFolder /> element, it doesn't compile, even though there is no KeyPath.

 <DirectoryRef Id="INSTALLFOLDER">
      <Component Id="dbComp1" Guid="B4E70B72-DB9C-4215-B4DF-022B56A26C01">
        <CreateFolder />
        <sql:SqlDatabase Id="msiTestDB1" Database="[SQLDB]"
Server="[SQLSERVER]" Instance="[SQLINSTANCE]" CreateOnInstall="yes"
User="SQLUser" />
        <sql:SqlScript BinaryKey="binCreateTbl" Id="script_CreateTbl"
ExecuteOnInstall="yes"  ExecuteOnReinstall="yes" ContinueOnError="no"
SqlDb="msiTestDB1" Sequence="1"  />
      </Component>
    </DirectoryRef>

Regards,
Venkatesh