While exploring to upgrade from FIM 2010 SP1 to MIM you may encounter the following error when upgrading from latest FIM 2010 R2 SP1 hotfixes (4.1.3646.0 / 4.1.3634.0 / 4.1.3627.0 / 4.1.3733 / 4.1.3766) to Microsoft Identity Manager. We are aware of this issue and have a solution
We have a workaround for this issue. We simply replace the file <iso_drive>\Service and Portal\Program Files\Microsoft Forefront Identity Manager\2010\Service\Microsoft.IdentityManagement.DatabaseUpgrade.exe.config with the one below before installing.
In the Microsoft.Identitymanagement.DatabaseUpgrade_tracelog you would see the following error below if you attempted this upgrade without replacing the configuration file.
Microsoft.ResourceManagement Verbose: 0 : Execute SQL : The transaction failed with the following errors System.Data.SqlClient.SqlException: Column, parameter, or variable #1: Cannot find data type fim.ObjectKeyListInternal.
Must declare the table variable “@objectKeyList”.
Parameter or variable ‘@objectKeyList’ has an invalid data type.
Identity and Security Team / AKA Support
Note: please rename to Microsoft.IdentityManagement.DatabaseUpgrade.exe.config