[wix-users] Regarding Database deployments using WiX

[Habib Salim]

I use custom actions to create a database, create a number of database
objects, and to import data from xml files.
Overall, my needs were fairly limited but it could scale this out quite
nicely.


-----Original Message-----
From: wix-users <wix-users-bounces at lists.wixtoolset.org> On Behalf Of Ven
H via wix-users
Sent: Tuesday, February 05, 2019 12:41 PM
To: WiX Toolset Users Mailing List <wix-users at lists.wixtoolset.org>
Cc: Ven H <venh.123 at gmail.com>
Subject: Re: [wix-users] Regarding Database deployments using WiX

Has anyone got any inputs? Please help / advise.

On Fri, Jan 18, 2019 at 10:40 PM Ven H <venh.123 at gmail.com> wrote:

> I have around 8 Databases that need to be installed using WiX. There 
> are some objects that need to be created in MSDB also. I also need to 
> populate master data in many of the databases post creating the DBs. 
> The master data is in the form of insert statements, wherein audio 
> files are also converted to binary. Hence the data files are pretty big.
>
> I am using SqlDatabase and SqlScript elements to achieve this. But I 
> am facing some challenges.
> 1. The SqlScript seems to be scheduling everything and then executing 
> the scripts. This is slowing down the whole installation, especially 
> with big files having data and large number of files. I saw the below 
> link with a similar issue way back in 2008, but there doesn't seem to be
a solution.
> 2. The SqlScript doesn't accept parameters.
> 3. The status during execution of DB installation is a little confusing.
> In UI, it is showing Creating Databases, but in the logs, it is 
> actually doing Scheduling. Can we get detailed status and display 
> that, including which binary file is executing currently and so on?
> 4. How to manage Patch and Upgrades using SqlScript elements 5. If I 
> use SqlCmd for everything, things might be a little faster, but then I 
> may have to go for Custom Actions. Also, not sure how to manage 
> Patches and Upgrades with SqlCmd
>
> Has anyone faced the above issues? If so, can you please advise?
>

____________________________________________________________________
WiX Toolset Users Mailing List provided by FireGiant
https://link.spamstopshere.net/u/6e118c58/SmlPU20p6RG3cefPgNRvyg?u=http%3A
%2F%2Fwww.firegiant.com%2F