Could not load file or assembly 'RedGate.Reflector.SQLCompar

chris1324

I updated to Redgate Readyroll and am getting an error when trying to view pending import. What's going on?? I don't have time for this!!

Message = Error during compare. Could not load file or assembly 'RedGate.Reflector.SQLCompare, Version=0.0.0.0, Culture=neutral, PublicKeyToken=7f465a1c156d4d57' or one of its dependencies. The system cannot find the file specified., Stack: at RedGate.SQLCompare.Engine.ClrAssembly.CanBeAlteredTo(ClrAssembly target)
at RedGate.SQLCompare.Engine.DatabaseCollaborators.DirectObjectsComparison.ProcessDatabaseObject[T](Differences differences, IDatabaseObjects`1 targetObjects, Options options, DatabaseMapper dbmapper, IDatabaseObject t1, ProgressTracker progressTracker)
at RedGate.SQLCompare.Engine.DatabaseCollaborators.DirectObjectsComparison.<>c__DisplayClass8_0`1.<PopulateDifferences>b__0(IDatabaseObject t1)
at System.Threading.Tasks.Parallel.<>c__DisplayClass32`2.<PartitionerForEachWorker>b__30()
at System.Threading.Tasks.Task.InnerInvoke()
at System.Threading.Tasks.Task.InnerInvokeWithArg(Task childTask)
at System.Threading.Tasks.Task.<>c__DisplayClass3.<ExecuteSelfReplicating>b__2(Object )
at RedGate.SQLCompare.Engine.DatabaseCollaborators.DirectObjectsComparison.PopulateDifferences[T](Differences differences, IDatabaseObjects`1 objects, IDatabaseObjects`1 targetObjects, Options options, DatabaseMapper dbmapper, ProgressTracker progressTracker)
at RedGate.SQLCompare.Engine.DatabaseCollaborators.DirectObjectsComparison.PopulateDifferences(Differences differences, ICancellable subscriber)
at RedGate.SQLCompare.Engine.DatabaseComparison.CompareDatabases(Database source, Database target, Options options, SqlCompareOwnerMappings ownerMappings, SqlCompareTableMappings tableMappings, ITemporaryDatabaseFactory`1 temporaryDatabaseFactory)
at RedGate.SQLCompare.Engine.Database.CompareWith(Database targetDatabase, Options options)
at ReadyRoll.Services.RefreshService.Refresh(DatabaseProject databaseProject, ProgressReporter progressHandler, Boolean doDataCompare, TaskLoggingHelper logger, String sourceDatabaseName, FileInfo sourceSnap)
Data = System.Collections.ListDictionaryInternal
InnerException =
TargetSite = Void ThrowForNonSuccess(System.Threading.Tasks.Task)
StackTrace =
Server stack trace:
at ReadyRoll.Services.RefreshService.Refresh(DatabaseProject databaseProject, ProgressReporter progressHandler, Boolean doDataCompare, TaskLoggingHelper logger, String sourceDatabaseName, FileInfo sourceSnap)
at ReadyRollAdvancePtyLtd.ReadyRoll_VSPackage.ViewModels.PendingChangeModel.<CompareSandboxToProject>b__163_0()
at System.Threading.Tasks.Task.InnerInvoke()
at System.Threading.Tasks.Task.Execute()

Exception rethrown at [0]:
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccess(Task task)
at ReadyRollAdvancePtyLtd.ReadyRoll_VSPackage.ViewModels.PendingChangeModel.<CompareSandboxToProject>d__163.MoveNext()

Exception rethrown at [1]:
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccess(Task task)
at ReadyRollAdvancePtyLtd.ReadyRoll_VSPackage.Commands.SyncCommand.<Execute>d__6.MoveNext()
HelpLink =
Source = Microsoft.CompilerServices.AsyncTargetingPack.Net4
HResult = -2146233088

dnlnln

Hi Chris,

Sorry for the delay in replying to you and apologies for the error.

I have managed to reproduce the problem with a database containing CLR objects. Would you happen to know if that is the case with your database?

We now have a fix available if you would like to try it. Before installing the following build, unfortunately you'll need to first uninstall your current version of ReadyRoll:
http://download.ready-roll.com/ReadyRol ... 2.1034.exe

Please let me know if this resolves the issue for you.

chris1324

Works perfect - thank you Daniel for the quick fix!

(no db clr objects)

dnlnln

That's great to hear Chris! Thank you for confirming.