cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
dinesh_ravin
Level 3

SQL Script on uninstall for multiple instances

Hi,

We are doing multiple instances of the same product by manually modifying the package and product code in the ISM file. We are not using the instance transform. Even though we modify the package code, the component GUID within each instance is the same.

With this mechanism, we have an issue on uninstall to cleanly remove registries and removing SQL database.

There is a component in the MSI project for an SQL script which is run during uninstallation. As the component GUID is the same across all instances, only the last uninstall of the product is executing the remove SQL script. But we want to treat all instances as an independent product and not to share any single file or registry.

is there any solution or workaround to specify to run the remove SQL script always on uninstall of any instance?

Project type is Basic MSI project.

Labels (1)
0 Kudos
(3) Replies
Jenifer
Flexera Alumni

Hi @dinesh_ravin ,

 

Since components belonging to different instances share the same component GUID that would be limitation from MSI installer i would say.

How about creating separate components for different instances ?

As well shared property of component might be "yes" in this case i guess.

I would also suggest you to go through this blog,that might help you achieve somethings not in full fledged way!!

http://www.installsite.org/pages/en/isp_uninst.htm

 

Thanks,

Jenifer

0 Kudos

@Jenifer  it looks not that easy. is there a solution using custom action? can I trigger this remove sql script using custom action in the execute sequence?

0 Kudos

Hi @dinesh_ravin ,

How about following the below article?Which states how to execute script during uninstall?

 

https://community.flexera.com/t5/InstallShield-Knowledge-Base/Conditionally-run-SQL-scripts-during-uninstall/ta-p/3863

 

Thanks,

Jenifer

0 Kudos