This is of interest... http://blogs.msdn.com/sqlexpress/archive/2007/08/23/diy-sql-express-sp2-bootstrapper.aspx
Near the bottom: (Quoted below) re: DIY SQL Express SP2 Bootstrapper Monday, October 27, 2008 6:26 PM by sqlexpress Response to David - The SQL Express 2005 SP2 bootstrapper was released as part of Visual Studio 2008 RTM, so you can either move to that product to get that level of the SQL bootstrapper or you can install the VS 2008 Express product and then copy the entire SQL Express bootstrapper folder into the location used by the VS 2005 prerequisite system. You may also be interested to know that we released the SQL Express 2008 bootstrapper as part of VS 2008 Express SP1 so that you are covered when you need to move to the SQL 2008 product line. - Mike -----Original Message----- From: Arun Perregatturv [mailto:aperregatt...@napcosecurity.com] Sent: Thursday, February 25, 2010 8:21 AM To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] SQL2008 Express Merge Module http://blogs.msdn.com/sqlexpress/archive/2007/08/23/diy-sql-express-sp2-bootstrapper.aspx this is done for SQL 2005 but you can do the same for SQL 2008. I am currently using it and it works fine. Arun Perregattur -----Original Message----- From: John H. Bergman (XPedient Technologies) [mailto:john.berg...@xpedienttechnologies.com] Sent: Wednesday, February 24, 2010 5:07 PM To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] SQL2008 Express Merge Module Where do you get the contents of this directory? <BootstrapperFile Include="Microsoft.Sql.Server.Express.10.0"> -----Original Message----- From: Arun Perregatturv [mailto:aperregatt...@napcosecurity.com] Sent: Wednesday, February 24, 2010 3:35 PM To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] SQL2008 Express Merge Module <ItemGroup> <BootstrapperFile Include="Microsoft.Windows.Installer.4.5"> <ProductName>Windows Installer 4.5</ProductName> </BootstrapperFile> <BootstrapperFile Include="Microsoft.Net.Framework.3.5.SP1"> <ProductName>.NET Framework 3.5</ProductName> </BootstrapperFile> <BootstrapperFile Include="Microsoft.Sql.Server.Express.10.0"> <ProductName>Microsoft SQL Server 2008 Express Edition</ProductName> </BootstrapperFile> <BootstrapperFile Include="BusinessObjects.CrystalReports.10.5"> <ProductName>BusinessObjects.CrystalReports.10.5</ProductName> </BootstrapperFile> </ItemGroup> <Target Name="AfterBuild"> <GenerateBootstrapper ApplicationFile="WixSetup.Msi" ApplicationName="Setup 3.0" BootstrapperItems="@(BootstrapperFile)" ComponentsLocation="Relative" CopyComponents="true" OutputPath="$(OutputPath)" Path="C:\Program Files\Microsoft SDKs\Windows\v6.0A\Bootstrapper\" /> </Target> Arun Perregattur -----Original Message----- From: John H. Bergman (XPedient Technologies) [mailto:john.berg...@xpedienttechnologies.com] Sent: Wednesday, February 24, 2010 3:40 PM To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] SQL2008 Express Merge Module The way I am including the other components is by modifying the WixProj to include this type of Markup... Also of Note is the location of the SDK varies depending on which one you install, so I added code that conditionally locates the SDK. Is there a walkthrough for including SQl2008 anywhere? <ItemGroup> <BootstrapperFile Include="Microsoft.Net.Framework.3.5.SP1"> <ProductName>.NET Framework 3.5 SP1</ProductName> </BootstrapperFile> <BootstrapperFile Include="Microsoft.Windows.Installer.4.5"> <ProductName>Windows Installer 4.5</ProductName> </BootstrapperFile> <BootstrapperFile Include="Microsoft.Office.PIARedist.2007"> <ProductName>Microsoft Office 2007 Primary Interop Assemblies</ProductName> </BootstrapperFile> </ItemGroup> <PropertyGroup> <SDK70>$(registry:HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft sdks\windows\v7...@installationfolder)</SDK70> <SDK70A>$(registry:HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft sdks\windows\v7....@installationfolder)</SDK70A> <SDKPath>$(SDK70A)</SDKPath> <SDKPath Condition=" '$(SDKPath)' == ''">C:\Program Files\Microsoft SDKs\Windows\v6.0A\</SDKPath> </PropertyGroup> -----Original Message----- From: Arun Perregatturv [mailto:aperregatt...@napcosecurity.com] Sent: Tuesday, February 23, 2010 2:44 PM To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] SQL2008 Express Merge Module Use the bootstrapper to include SQL2008. I don't think you will get merge modules of SQL 2008. Arun Perregattur -----Original Message----- From: John H. Bergman (XPedient Technologies) [mailto:john.berg...@xpedienttechnologies.com] Sent: Tuesday, February 23, 2010 3:21 PM To: General discussion for Windows Installer XML toolset. Subject: [WiX-users] SQL2008 Express Merge Module Does anyone know where I can find the SQL2008 Express Merge Module? I have a requirement to install a local database, and have been unable to locate a way to include the SQL2008 Express in my installer. I have seen several other products do this, so I know the capability exists... Thanks, John ------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users ------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users ------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users ------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users ------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users ------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users ------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
