Hello,
Can anyone out there provide a working Wix 3.0 example of using the
SqlDatabase and SqlScript tags to create a database and run a few
scripts in Sql Server Express 2005 using windows authentication?
I've been trying to do it using the documentation and prior emails to
this list and have not been successful.
Here's my latest code, if it's of interest:
<Property Id='DBNAME' Value='newdb' Secure='yes' />
<!-- This "server" value works when logging into the management
console -->
<Property Id='DBSERVER' Value='localhost\SQLEXPRESS' Secure='yes' />
<!-- SQL Binaries -->
<Binary Id='CreateLogin_Network_Service'
SourceFile='database\1_CreateLogin_Network_Service.sql' />
<Binary Id='CreateDBSchemas'
SourceFile='database\2_CreateDBSchemas.sql' />
<Binary Id='Add_db_newdb' SourceFile='database\3_Add_db_newdb.sql' />
<Binary Id='Add_Tables_And_Stored_Procs'
SourceFile='database\4_Add_Tables_And_Stored_Procs.sql' />
<Directory Id="TARGETDIR" Name="SourceDir">
<Directory Id='ProgramFilesFolder' Name='PFiles'>
<Directory Id="INSTALLDIR" Name ="AppDir">
<Component Id='SqlComponent'
Guid='{A45BFBEF-1C37-44df-846F-C424B182EF08}'>
<sql:SqlDatabase Id="SqlDatabase" Database="[DBNAME]"
Server="[DBSERVER]" CreateOnInstall="yes" ConfirmOverwrite="yes"
DropOnUninstall="no" ContinueOnError="no">
<sql:SqlScript Sequence='001' Id='CreateDB1'
BinaryKey='CreateLogin_Network_Service' ExecuteOnInstall='yes' />
<sql:SqlScript Sequence='002' Id='CreateDB2'
BinaryKey='CreateDBSchemas' ExecuteOnInstall='yes' />
<sql:SqlScript Sequence='003' Id='CreateDB3'
BinaryKey='Add_db_newdb' ExecuteOnInstall='yes' />
<sql:SqlScript Sequence='004' Id='CreateDB4'
BinaryKey='Add_Tables_And_Stored_Procs' ExecuteOnInstall='yes' />
</sql:SqlDatabase>
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users
