When trying to migrate profile properties I get the following error. I am using the standard setup of properties in MigrationTool.config. I am using the new version (1.1.0.32) of the Migration tool which is supposed to be case insensitive, but this looks like a problem with the case of column names?
I'm grateful for any help.
[2009-03-06 10:05:07][Information] Migrating users...
[2009-03-06 10:05:08][Information] Finished migrating users. Migrated 869 users
[2009-03-06 10:05:08][Information] Migrating Roles...
[2009-03-06 10:05:08][Information] Finished migrating roles. Migrated 6 roles
[2009-03-06 10:05:08][Information] Migrating Profile Properties...
[2009-03-06 10:05:08][Error] Migration terminated with error:
[2009-03-06 10:05:08][Error] System.Data.SqlClient.SqlException: Invalid column name 'fkpagedefinitionid'.
Invalid column name 'pkid'.
Invalid column name 'name'.
Invalid column name 'name'.
Invalid column name 'name'.
Invalid column name 'name'.
Invalid column name 'name'.
Invalid column name 'fkPageId'.
Invalid column name 'name'.
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.GetSubscriptionInfo()
at EPiServer.Migration.MigrateUsersProperty.MigrateSubscriptionInfo()
at EPiServer.Migration.MigrateUsersProperty.MigratePerofileInfo()
at EPiServer.Migration.MigrationWorkflow.MigrateProfiling(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()