Symptoms
When running the Database consolidation tool v1.6, the installer logs throws the following error:-
Could not load file or assembly 'Microsoft.SqlServer.SqlClrProvider, Version=11.0.0.0
Diagnoses
Found that the server had the CLR type version 10 and 12, however, the DB consolidation tool is looking for version 11.
Resolution
CLR type version 11 belongs to SQL 2012. After installing the SQL server 2012 feature pack, it resolves the issue.
For more information, kindly refer to: http://sqlbeyond.blogspot.sg/2012/08/vs-2012-error-could-not-load-file-or.html