It's pretty easy to do in WiX though. You just have to write a sqlstring element that creates the filegroups for you. Use WiX to create your database, then add the following to a SqlString element. One thing to note is you do need a fully qualified filename so you'll need to make sure you resolve FILEGROUPLOCATION in a custom action correctly or this will all fall apart.
alter database [DBNAME] add filegroup YourFileGroup alter database [DBNAME] add file (Name = '[DBNAME]_FG1_Data',Filename = '[FILEGROUPLOCATION]_FG1.ndf', Size=[DATAFILESIZE]MB, FileGrowth=10%) to Filegroup YourFileGroup Dana On Tue, Sep 16, 2008 at 12:00 AM, Rob Mensching <[EMAIL PROTECTED] > wrote: > 1. The overwrite issue was a bug fixed in the most recent build. > > 2. No, multiple files are not supported today. > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto: > [EMAIL PROTECTED] On Behalf Of Jay Thaler > Sent: Monday, September 15, 2008 11:29 > To: wix-users@lists.sourceforge.net > Subject: [WiX-users] SqlDatabase with multiple data files? > > SQL allows you to create databases that span multiple data files. The > primary file has an MDF extension, and the secondary and subsequent files > have an NDF extension. I tried defining multiple SqlFileSpec elements under > my SqlDatabsae, but it seems that the second SqlFileSpec overwrites the > first one in WiX's mind. Does WiX support multiple data files for a SQL > database? > _________________________________________________________________ > See how Windows Mobile brings your life together-at home, work, or on the > go. > http://clk.atdmt.com/MRT/go/msnnkwxp1020093182mrt/direct/01/ > ------------------------------------------------------------------------- > 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
