[wix-users] Regarding Database deployments using WiX

[Ven H]

I am not sure how you handle Patches with your approach? Anyways, I would
prefer using SqlScript elements whenever possible. Can anyone please
provide inputs?

On Tue, Feb 5, 2019 at 11:19 PM Habib Salim via wix-users <
wix-users at lists.wixtoolset.org> wrote:

> 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
>
> ____________________________________________________________________
> WiX Toolset Users Mailing List provided by FireGiant
> http://www.firegiant.com/
>