Using IM Update Client
Browes to the client (http://localhost/IMUpdate/UpdateClient/), Start to upload the last version of IM, 4.0.0.XX.zip
Click on Environments and select the Environment to update.
If the version is older blue arrows are showed after the version for each item and Update all is enabled.
Enter the password for the installation account and Validate the Account.
Then click on Update Integration Manager
IMLog database cannot be updated using this process for the moment due to the time spent on it and transaction log size, that might have to be shrinked.
Open the 4.0.0.XX.zip and copy the IMLog.dacpac to a folder eg c:\temp\
In the file named Database readme.txt a description can be found how to update the IMLog database using dacpac.
"C:\Program Files (x86)\Microsoft SQL Server\120\DAC\bin\SqlPackage.exe" /Action:Publish /TargetDatabaseName:"IMLog_20150101" /TargetServerName:"localhost" /SourceFile:"C:\temp\IMLog.dacpac" /Properties:RegisterDataTierApplication=True /Properties:BlockOnPossibleDataLoss=False /Properties:BlockWhenDriftDetected=False /Properties:PopulateFilesOnFilegroups=False
Use correct version of dacpac 110 for SQL Server 2012 or 120 for SQL Server 2014
Update the /TargetDatabaseName - with correct name of the database to update
Update the /TargetServerName - with the servername\instance
Update the /SourceFile - with the path to the .dacpac file