I am currently creating an installer which have to create a database. This
works fine as goes, however I have a question:
Right now my code looks like this:
<Binary Id="DB" SourceFile=".\Database\DB.SQL" />
<Binary Id="Data" SourceFile=".\Database\Data.SQL" />
<DirectoryRef Id="INSTALLDIR">
<Component Id="DatabaseInstall" Guid="
1D1A4965-D440-47C0-BA3E-29E43EBF1D03" DiskId="1" KeyPath="yes">
<File Id="CreateDB" Name="DB.SQL" Source=".\Database\DB.SQL"
/>
<File Id="CreateData" Name="Data.SQL" Source="
.\Database\Data.SQL"/>
<Sql:SqlDatabase Id="ScanXNETDatabase" Server="
[DATABASESERVER]" Database="[DATABASENAME]" CreateOnInstall="yes"
ConfirmOverwrite="no">
<Sql:SqlScript Id="CreateDB" ExecuteOnInstall="yes"
BinaryKey="DB" Sequence="1"/>
<Sql:SqlScript Id="Data" ExecuteOnInstall="yes"
BinaryKey="Data" Sequence="1"/>
</Sql:SqlDatabase>
</Component>
</DirectoryRef>
I have a few problems with this:
First, this requires integrated security, if that is not possible, how do I
supply a user id and password for the creation of my database?
Second, how do I ensure that the script files are deleted from INSTALLDIR
after the database has been created?
Third, if the database already exists on the server I do NOT want to delete
it, but rather run an update script, how do I do that?
Please help. The help file is rather vague on the use of the Sql Extension,
and my google-fu seems to be lacking.
--
Thomas Due
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users
