Symptoms

I am running database consolidator tool in one of our dev environment, but it failed to migrate the data. I am getting the following error.

Database consolidation was cancelled or failed. See log for more information.

From Log - Exception: Could not load file or assembly 'Microsoft.SqlServer.SqlClrProvider, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies

However, we have the latest library (12.0.0.0) in our environment and the consolidator tool also coming with version 12.0.0.0.

I met all the prerequisites that are mentioned in the consolidator tool document. So, I should not have any issue.
 

Diagnoses

After reviewing ticket 81421, it is determined that this error was pointing to the fact that version 11 of the Microsoft.SqlServer.SqlClrProvider.dll. SQL 2008 R2 only has version 10.

In the above ticket, after installing SQL Server 2012, which has version 11 of the dll, the tool was able to run properly.

 

Resolution

Do a separate installation of SQL 2012 for the purpose of running the consolidation.