The repository migration assistant doesn't like my process, it keeps bailing out saying:
Statement: Copying data for eMSWorkflowEvent
Artefact: AML (Metastorm.RepositoryMigration.Model.Artefacts.Project)
Error: System.Data.SqlClient.SqlException: Invalid object name 'eMSWorkflowEvent'.
I can see a table called eMSWorkflowEvent in the databse, so it can't be a table. Maybe it's got something to do with renaming objects or whatever, cos there was a fair amount of renaming in this one process that's failing.
I don't have a mapping file because the process had its initial migration prior to the release of the repository migration assistant.
What would be nice is, in the log file if the sql statement that fails could be recorded so we can tweak it, run it and then carry on. Or better still, just output the whole migration to sql script so we can run it in Query analyser bit by bit and tweak as necessary till we get to the end. But as it is, I can't get past the current error. I don't seem to have been given any chance to have an input into how the migration gets over whatever errors it finds.
Is there any way of fixing this error? Otherwise I'm going to have to write the migration by hand...