[wix-users] Separate Component for each SqlScript element?

[Hoover, Jacob]

Good reading:

http://robmensching.com/blog/posts/2003/10/18/component-rules-101/

https://msdn.microsoft.com/en-us/library/windows/desktop/aa372795%28v=vs.85%29.aspx?f=255&MSPPError=-2147217396


-----Original Message-----
From: wix-users [mailto:wix-users-bounces at lists.wixtoolset.org] On Behalf Of Ven H via wix-users
Sent: Monday, May 14, 2018 9:40 AM
To: Edwin Castro <egcastr at gmail.com>
Cc: Ven H <venh.123 at gmail.com>; WiX Toolset Users Mailing List <wix-users at lists.wixtoolset.org>
Subject: Re: [wix-users] Separate Component for each SqlScript element?

Thank you very much for the details. So, if I understand correctly, I should include every SqlScript element under it's own component as per the Component Rules.

Regards,
Venkatesh

On Mon, May 14, 2018 at 7:43 PM, Edwin Castro <egcastr at gmail.com> wrote:

> You are not allowed to change components. You are breaking the 
> component rules. Rob has a few blog posts on the component rules that 
> you should read and understand. I can't look them up right now, I'm on 
> my phone, but I'll look for them after I get to work.
>
> The only time you can change a component is if you are doing a major 
> upgrade *and* RemoveExistingProducts is scheduled early (so that all 
> old components are completely uninstalled before the new, different 
> components can be installed). For all other kinds of upgrades, 
> including major ugrades scheduled late, you cannot change components 
> as the Windows Installer engine requires components to be immutable.
>
> --
> Edwin G. Castro
>
>
>
> On Mon, May 14, 2018, 04:43 Ven H via wix-users < 
> wix-users at lists.wixtoolset.org> wrote:
>
>> Sorry to bring this topic again. But, if we don't allocate individual 
>> component for each SqlScript, then Patch doesn't seem to be working 
>> properly. For example, if I have an SqlScript in first version and I 
>> add another SqlScript element in my Patch, if they are within the 
>> same component, it doesn't seem to be working. But if they are within 
>> their own components, then it seems to be working. Please advise.
>>
>> Regards,
>> Venkatesh
>>
>> On Wed, Feb 28, 2018 at 5:37 PM, Nir Bar via wix-users < 
>> wix-users at lists.wixtoolset.org> wrote:
>>
>> > Since SqlComponent are not key paths anyway, you can nest some 
>> > under a single component
>> >
>> >
>> >
>> > --
>> > Nir Bar, Independent WiX Expert. Creator of-
>> > JetBA: WiX WPF Bootstrapper User Interface Framework
>> >
>> > JetBA++: WiX Native Bootstrapper User Interface Framework
>> >
>> >
>> >
>> >
>> >
>> > ___________________________________________________________________
>> > _ WiX Toolset Users Mailing List provided by FireGiant 
>> > http://www.firegiant.com/
>> >
>>
>> ____________________________________________________________________
>> WiX Toolset Users Mailing List provided by FireGiant 
>> http://www.firegiant.com/
>>
>

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