I have a script file that creates a couple of databases. I am trying to
run this script from WiX as follows (parameters captured from GUI):
<Fragment>
<Binary Id="CreateUpsizingDatabase"
SourceFile="SqlScripts/00A_Create Database DC.sql" />
<util:User Id="SQLUser" Name="[SQLUSER]" Password="[PASSWORD]" />
<DirectoryRef Id="INSTALLFOLDER">
<Component Id="SqlComponent"
Guid="15CCE46E-8EA5-42CA-80C5-AC3DB30A9716">
<sql:SqlDatabase Id="SqlDatabase" Database="[SQLDATABASE]"
Server="[SQLSERVER]"
CreateOnInstall="yes"
DropOnUninstall="no" User="SQLUser"
ContinueOnError="no" />
<sql:SqlScript Id="CreateDatabases" SqlDb="SqlDatabase"
ExecuteOnInstall="yes"
BinaryKey="CreateUpsizingDatabase" />
<CreateFolder/>
</Component>
</DirectoryRef>
</Fragment>
When I run this WiX wants to create a database for me using the parameters
specified. Is there a way to NOT create the database and still run the
script? I tried specifying an existing database but got an error. I also
set 'CreateOnInstall' & 'DropOnUninstall' to NO but got a build error that
"one of the following attributes has to be specified" (I assume this means
one must be set to YES).
Brian
If you can't explain it simply, you don't understand it well enough. -
Albert Einstein
------------------------------------------------------------------------------
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://p.sf.net/sfu/Zoho
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users
