I am still trying to "decipher" the proper use of SQLDatabase on all scenarios, install, upgrade, rollback, etc. If you manage to work it out, let us know.
-----Original Message----- From: Sandeep Gautam (HCL Technologies Ltd) [mailto:[EMAIL PROTECTED] Sent: Monday, October 06, 2008 5:02 AM To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] Condition for Component Thanks Eithan, But I just want to know what ever I am using is this known open issue or I am giving some thing wrong condition. Regards -Sandeep -----Original Message----- From: Eitan Behar [mailto:[EMAIL PROTECTED] Sent: Sunday, October 05, 2008 12:25 AM To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] Condition for Component Sandeep, If you are using this to work with databases, I would suggest you a different approach. I am creating my databases using SQLScripts elements, and not using WIX's SQLDatabase element. That way, I have a better granularity of what I want to do, particularly regarding the way I create the database. This is my code: <sql:SqlDatabase Id="SQL_DB" Database="master" Server="[DB_SERVER_NAME]"> /sql:SqlDatabase> <DirectoryRef Id="INSTALLDIR"> <Component Id="01_Database_Create" Guid="DC55A10C-53F6-4A2E-B2A9-166895594960" KeyPath="yes" Transitive="yes"> <Condition>INSTALL_DATA=1 And Not Installed</Condition> <sql:SqlScript Id="_01_Database_Create" SqlDb="SQL_DB" ExecuteOnInstall="yes" Sequence="1" BinaryKey="_01_Database_Create" /> </Component> <Binary Id="_01_Database_Create" SourceFile="scripts\01_Database_Create.sql" /> Note that the SqlDatabase element is not within a component. Also, I have a component per script to create/alter tables, and one script for dropping the database. Hope this helps. Eitan On Sun, Oct 5, 2008 at 8:34 AM, Sandeep Gautam (HCL Technologies Ltd) < [EMAIL PROTECTED]> wrote: > I have tried this option also. On repair/repair, with this option it is > deleting the data base . But On remove/repair, I don 't want to do any with > this component on repair/DB(component which is creating DB at the time of > installation). > > Please help me out. > > Regards > Sandeep > > -----Original Message----- > From: Eitan Behar [mailto:[EMAIL PROTECTED] > Sent: Saturday, October 04, 2008 11:23 PM > To: General discussion for Windows Installer XML toolset. > Subject: Re: [WiX-users] Condition for Component > > <Component Id="YOUR-ID-GOES-HERE" Guid="YOUR-GUID-GOES-HERE" KeyPath="yes" > Transitive="yes"> > <Condition>Not Installed</Condition> > > > > On Sun, Oct 5, 2008 at 1:45 AM, Sandeep Gautam (HCL Technologies Ltd) < > [EMAIL PROTECTED]> wrote: > > > No, I did not use this attribute.Shall I mark this attribute as No ? > > > > > > > > -----Original Message----- > > From: Rob Mensching [mailto:[EMAIL PROTECTED] > > Sent: Friday, October 03, 2008 10:33 PM > > To: General discussion for Windows Installer XML toolset. > > Subject: Re: [WiX-users] Condition for Component > > > > Is the Component marked Transitive? > > > > -----Original Message----- > > From: Sandeep Gautam (HCL Technologies Ltd) [mailto: > [EMAIL PROTECTED] > > ] > > Sent: Friday, October 03, 2008 19:28 > > To: General discussion for Windows Installer XML toolset. > > Subject: [WiX-users] Condition for Component > > > > Hi , > > I have one component which is creating Data bases. Now I want to execute > > this component only at the time of first time installation. I don't want > to > > execute this on repair and remove(don't want to drop the Db at the time > > remove) options. I have tried conditions so many conditions with > component > > like > > <Component Id='XXX' Guid='{XXX}' > > > <Condition>Not Installed </Condition> > > > > But every time is going into this component. > > > > Please help me out. > > > > Regards > > Sandeep > > > > ------------------------------------------------------------------------- > > 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 > > > > > > ------------------------------------------------------------------------- > > 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 > > > > > > ------------------------------------------------------------------------- > > 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 > > > ------------------------------------------------------------------------- > 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 > > > ------------------------------------------------------------------------- > 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 > ------------------------------------------------------------------------- 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 ------------------------------------------------------------------------- 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 ------------------------------------------------------------------------- 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
