Hi All,
Three questions on the SQL extension.
1) Is there a way to set the database collation (and other database
options) using the SQL extension?
I am assuming it would set on the <Sql:SqlDatabase> element or a child
element of this, however I can't seem to see it in any xsd schema's. We
usually get the database administrator to run the Create database
statement with the COLLATE Latin1_General_CI_AS flag.
I 'could' change the collation after the database with an alter
statement, but if the database already exists I don't want to be
changing the collation when previous objects still exist.
2) Is there a property I can check to see if wix had to create the
database or if the database already existed? Looking at the verbose log
file the MSI generates I can't seem to find it. There are a number of
server logins I need to create only if the database didn't exist. I
could make a check box in the UI and use that as the condition but it's
not as clean.
3) I have an additional question in the SQL namespace to do with
conditions. I have accounted for both authenticated and user/password
scenarios in my user interface dialog and as a result needed to pass
that information into the wix SQL elements. The only way I've achieved
this is by copy and pasting the entire block of SQL code below, one with
the Condition set to = 1, the other with it set to = 0. I find it a
little bulky to have this code almost copy and pasted so I wondered if
there was another method of achieving the same thing.
<Component Id='DatabaseFileAuth'
Guid='2CA253E3-FDAF-46BE-AACA-376969DE7E5B'>
<Sql:SqlDatabase Id="SqlDatabaseIntAuth"
Server="[SQLSERVERNAME]" Database="[SQLDATABASENAME]"
CreateOnInstall="yes" ConfirmOverwrite="yes"
DropOnUninstall="no" CreateOnReinstall="yes" DropOnInstall="yes">
<Sql:SqlFileSpec Id="SqlDatabaseIntAuthDataFile"
Filename="[UNKOWNPROP]"
Name="[SQLDATABASENAME]_Data" Size="512MB"
GrowthSize="512MB" MaxSize="Unlimited" />
<Sql:SqlFileSpec Id="SqlDatabaseIntAuthLogFile"
Filename="[UNKOWNPROP]"
Name="[SQLDATABASENAME]_Log" Size="512MB" GrowthSize="512MB"
MaxSize="25600MB" />
</Sql:SqlDatabase>
<Sql:SqlScript Id="RunDropDatabaseAuth"
SqlDb="SqlDatabaseIntAuth" BinaryKey="DropEverything"
ExecuteOnInstall="yes" ContinueOnError="yes" Sequence="1" />
<Sql:SqlScript Id="RunBuildDatabaseAuth"
SqlDb="SqlDatabaseIntAuth" BinaryKey="BuildDatabase"
ExecuteOnInstall="yes" Sequence="2" />
<Condition>SQLINTEGRATEDSECURITY = 1</Condition>
</Component>
..... Copy and paste above but make new Ids, Guids, set the user
attribute and make the condition = 0.
Thanks for your time,
Murray Hipper
[EMAIL PROTECTED]
This e-mail and any attachments to it (the "Communication") are confidential
and are for the use only of the intended recipient. The Communication may
contain copyright material of the Snowden Group ("Snowden"), or any of its
related entities or of third parties. If you are not the intended recipient of
the Communication, please notify the sender immediately by return e-mail,
delete the Communication, and do not copy, print, retransmit, disclose, store
or act in reliance on the Communication. Any views expressed in the
Communication are those of the individual sender only, unless expressly stated
to be those of Snowden. Although virus protection devices and procedures are in
place, Snowden does not guarantee the integrity of the Communication, or that
it is free from errors, viruses or interference. Snowden advises email
recipients to carry out their own virus checks before opening any attachment.
Please note that the main telephone number for the Snowden Perth office has ch
anged to +61 8 9213 9213.
______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users
