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?
@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?
