[wix-users] Database behavior during Patch Uninstallation

[Colin Dawson (Astronutter)]

Another approach could be to do a backup of the database at install time, then at uninstall restore the backup.   Huge caveat is that any user added data will be lost.

Normally my experience is that once an database is installed it’s left in place, upgraded by patched and not removed when uninstall - unless there’s a specific UI option to facilitate dropping the database.

Colin

Sent from my iPhone

> On 9 May 2018, at 15:23, manish duggal via wix-users <wix-users at lists.wixtoolset.org> wrote:
> 
> You need to add separate action to run during uninstall which should take care of this. For e.g CreateTable statement be running during install so you need DeleteYanle statement to run during uninstall.
> 
> You can use custom properties to set for install and uninstall. Or you can check existing msi properties for this. Then control custom actions on these properties value. 
> 
> Thx
> Manish 
> 
> Sent from my iPhone
> 
>> On May 9, 2018, at 5:57 AM, Ven H via wix-users <wix-users at lists.wixtoolset.org> wrote:
>> 
>> If I am executing a new SQL script file as part of my Patch installation,
>> when I uninstall the patch, will this change rollback to its previous
>> version?
>> 
>> ____________________________________________________________________
>> WiX Toolset Users Mailing List provided by FireGiant http://www.firegiant.com/
> 
> 
> ____________________________________________________________________
> WiX Toolset Users Mailing List provided by FireGiant http://www.firegiant.com/