[wix-users] Installing SQL database

[John Cooper]

It can do it.  Use a basic SqlDatabase to make an empty database.  The use SqlScript to apply a schema/schemas.  Then use SqlScript/SqlString to load data.

--
John Merryweather Cooper
Senior Software Engineer | Integration Development Group | Enterprise Notification Service
Jack Henry & Associates, Inc.® | Lenexa, KS  66214 | Ext:  431050 |JoCooper at jackhenry.com



-----Original Message-----
From: wix-users [mailto:wix-users-bounces at lists.wixtoolset.org] On Behalf Of Douglas, Keith (STATCAN/STATCAN)
Sent: Friday, October 9, 2015 1:31 PM
To: WiX Toolset Users Mailing List <wix-users at lists.wixtoolset.org>
Subject: Re: [wix-users] Installing SQL database

The e-mail below is from an external source.  Please do not open attachments or click links from an unknown or suspicious origin.

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/

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

NOTICE: This electronic mail message and any files transmitted with it are intended
exclusively for the individual or entity to which it is addressed. The message, 
together with any attachment, may contain confidential and/or privileged information.
Any unauthorized review, use, printing, saving, copying, disclosure or distribution 
is strictly prohibited. If you have received this message in error, please 
immediately advise the sender by reply email and delete all copies.