Note to Self: Add to The Global Assembly Cache on MSI Imports

Lately, I've been busy with deployment and re-deployment of BizTalk solutions for testing purposes. In the deployment step, I just want to import the MSI and done. But, to do that, I also need to make sure that when I import the MSI, all the assemblies is also added to the GAC. So, I have to modify each of the resources and check the "Add to the global assembly cache on MSI imports (gacutil)" option. Well, it's quite annoying things to do if you need to do this for all the resources.

Thanks to Dmitriy, I just need to run this query in the adpl_sat table of BizTalkMgmtDb database:

update dbo.adpl_sat set properties = replace(cast(properties as nvarchar(4000)),
'UpdateGacOnImport</key><value>False', 'UpdateGacOnImport</key><value>True') where applicationId = <app_id>