Thank you Dana! I will give that a go. The lack of support for this in WiX is troubling. I see the "fix" is to simply fail to compile if you specify two files. Boo.
> Date: Tue, 16 Sep 2008 08:20:15 -0400> From: [EMAIL PROTECTED]> To: > wix-users@lists.sourceforge.net> Subject: Re: [WiX-users] SqlDatabase with > multiple data files?> > 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 _________________________________________________________________ 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
