[wix-users] Installing SQL database

[Douglas, Keith (STATCAN/STATCAN)]

Others can correct me, but I got the impression that SQLDatabase was for creating a *database*, not a database server install. So you bundle SQL Express (though that seems to be hard, based on the below) and use ExePackage and then use SQLDatabase to create a database instance.


Keith Douglas
Programmer Analyst | Programmeur analyste Questionnaire Development Services - CAI Social | Services de développement de questionnaires - IAO Social Jean Talon Building | Immeuble Jean-Talon / Floor | Étage 4 A-3 Statistics Canada | 170 Tunney's Pasture Driveway, Ottawa ON K1A 0T6 Statistique Canada | 170, promenade Tunney's Pasture, Ottawa ON K1A 0T6 Keith.Douglas at canada.ca Telephone | Téléphone 613-854-5589 Facsimile | Télécopieur 613-951-4674 Government of Canada | Gouvernement du Canada 


-----Original Message-----
From: wix-users [mailto:wix-users-bounces at lists.wixtoolset.org] On Behalf Of Phill Hogland
Sent: October-09-15 2:14 PM
To: WiX Uses (wix-users at lists.wixtoolset.org)
Subject: [wix-users] Installing SQL database

The confusion that reigns in my mind, probably prevents a coherent question, but I will appreciate any advice.

I have been asked to create some setups (bundle/msi) for a client and server application which shares a database.  The developer/business is not clear on the specification and is asking me basically what is possible.  I have seen several posts about installing SqlExpress.  I downloaded it and started to write a bundle/ ExePackage to do some testing.  I have also done some reading on WixSqlExptension, and am left with some questions.  And I saw Rob's comment here:
http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/Burn-SQL-Express-Install-Fails-0x84b40000-td7391182.html
"PS: When you discover the correct set of parameters, let us know here.
There is a plan afoot to "pre-bake" the silent install of a bunch of well known redists so you can use them by just doing PackageGroupRef Id="x" at the correct place in your Chain. "

So if I want to create a SQL db do I just use WixSqlExtenstion and SqlDatabase element or do I also need to install SQLExpress first?
Or do I install SqlExpress and not use SqlDatabase element.  I am not clear on how they relate to each other.

Thanks.
Phill

____________________________________________________________________
WiX Toolset Users Mailing List provided by FireGiant http://www.firegiant.com/