We're working on getting the WiX v3 documentation up there. However, every download of the WiX toolset includes an up to date (as much as we have it) version of the WiX.chm. That should contain all the information...
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tim Fisher Sent: Friday, June 13, 2008 08:25 To: wix-users@lists.sourceforge.net Subject: Re: [WiX-users] Attach a database Turns out the sourceforge wix2 documentation regarding the SqlDatabase element is still valid for wix3's version of SqlDatabase. http://wix.sourceforge.net/manual-wix2/wix_xsd_sqldatabase.htm Wow, if we could just have one place for all the documentation, it would really help a lot with the confusion and frustration of trying to learn wix. Tim On Thu, Jun 12, 2008 at 6:18 PM, Tim Fisher <[EMAIL PROTECTED]> wrote: > I created a new wxs file with a Fragment in it, then I moved my SqlDatabase > element over into the Fragment element like this: > > <Wix xmlns="http://schemas.microsoft.com/wix/2006/wi"; > xmlns:sql="http://schemas.microsoft.com/wix/SqlExtension";> > <Fragment> > <sql:SqlDatabase Id="DB1" Server="[DBSERVERNAME]" > Database="master"> > <sql:SqlString Id="RollbackDb" > RollbackOnInstall="yes" SQL="DROP DATABASE [\[][DBNAME][\]]" Sequence="1" /> > <sql:SqlString Id="InstallDb" ExecuteOnInstall="yes" > SQL="CREATE DATABASE [\[][DBNAME][\]] ON (FILENAME=N'[#MDF]') FOR ATTACH" > Sequence="2" /> > <sql:SqlString Id="CreateUserId" SQL="IF NOT EXISTS > ( SELECT * FROM sys.server_principals WHERE name = N'[USERIDVALUE]' ) CREATE > LOGIN [USERIDVALUE] WITH PASSWORD='[PWDVALUE]', DEFAULT_DATABASE=[DBNAME], > CHECK_POLICY=OFF;USE [DBNAME];IF EXISTS(SELECT name FROM sys.sysusers WHERE > name=N'[USERIDVALUE]')DROP USER [USERIDVALUE];CREATE USER [USERIDVALUE];EXEC > sp_addrolemember db_owner, [USERIDVALUE];" ExecuteOnInstall="yes" > Sequence="3" /> > </sql:SqlDatabase> > </Fragment> > </Wix> > > Now I have two new questions. > > First, how do I reference this SqlDatabase element over in the Component > element that uses it over in the main wxs file? > > Second, when I try to compile I get, "SqlString element cannot be specified > unless the element has a component as an ancestor." How did you get your > SqlStrings to work using a Fragment? > > Tim > > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Rob Mensching > Sent: Friday, June 06, 2008 12:46 PM > To: General discussion for Windows Installer XML toolset. > Subject: Re: [WiX-users] Attach a database > > If you place the SqlDatabase element under a Component element that will > attempt to create the database. My SqlDatabase element is a direct child of > one of my Fragment elements. It is a little confusing but that causes the > SqlDatabase element to search for an existing database. Unfortunate naming > a long time ago that hasn't been straightened out. > > > ------------------------------------------------------------------------- Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://sourceforge.net/services/buy/index.php _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users ------------------------------------------------------------------------- Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://sourceforge.net/services/buy/index.php _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
