Looks like you somehow got manually created statistics on that column. Statistics are dropped automatically when they are created by the query optimizer which is the normal case.
The solution: Delete '_dta_stat_386100416_4_2_1' in SQL Management Studio
Hi I have been struggeling with the migration tool for a couple of days, it now stops on the following
[2009-04-29 13:45:44][Information] Finished migrating database data
[2009-04-29 13:45:45][Information] Finalizing database schema...
[2009-04-29 13:45:53][Error] Migration terminated with error:
[2009-04-29 13:45:53][Error] System.Data.SqlClient.SqlException: The statistics '_dta_stat_386100416_4_2_1' is dependent on column 'ManualInsert'.
ALTER TABLE DROP COLUMN ManualInsert failed because one or more objects access this column.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at EPiServer.Migration.SqlDataAccess.ExecuteReplaceableSqlFile(StreamReader sqlStatements, Regex placeHolderRegex, MatchEvaluator placeHolderHandler, Boolean useIntegratedSecurity)
at EPiServer.Migration.SqlDataAccess.ExecuteSqlFile(StreamReader sqlStatements)
at EPiServer.Migration.MigrationWorkflow.FinalizeDbSchema(Object sender, EventArgs e)
at System.Workflow.ComponentModel.Activity.RaiseEvent(DependencyProperty dependencyEvent, Object sender, EventArgs e)
at EPiServer.Migration.MigrationStepActivity.ExecuteHandler(Object sender, EventArgs e)
at System.Workflow.ComponentModel.Activity.RaiseEvent(DependencyProperty dependencyEvent, Object sender, EventArgs e)
at System.Workflow.Activities.CodeActivity.Execute(ActivityExecutionContext executionContext)
at System.Workflow.ComponentModel.ActivityExecutor`1.Execute(T activity, ActivityExecutionContext executionContext)
at System.Workflow.ComponentModel.ActivityExecutor`1.Execute(Activity activity, ActivityExecutionContext executionContext)
at System.Workflow.ComponentModel.ActivityExecutorOperation.Run(IWorkflowCoreRuntime workflowCoreRuntime)
at System.Workflow.Runtime.Scheduler.Run()
Does anyone now why?