http://wixtoolset.org/documentation/manual/v3/xsd/sql/sqldatabase.html
Nesting SqlDatabase under a Component element will result in a SqlDatabase being installed to the machine as the package is installed.Nesting SqlDatabase under Product, Fragment, or Module results in a database "locator" record being created in the SqlDatabase table. This means that the database itself is neither installed nor uninstalled by the MSI package. It does make the database available for referencing from a SqlString or SqlScript record. This allows MSI to install SqlScripts or SqlStrings to already existing databases on the machine. The install will fail if the database does not exist in these cases. _____________________________________________________________ Short replies here. Complete answers over there: http://www.firegiant.com/ -----Original Message----- From: Brian Enderle [mailto:bria...@gmail.com] Sent: Tuesday, October 14, 2014 7:33 AM To: WiX Users Subject: [WiX-users] Running SQL script without creating a database 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
