We need to have better migration assistant like DMA, that can Identify what all issues can we encounter due to collation, for example we faced an issue related to data length, when having the same lengths at source and destination we were not able to migrate anything untill we increased the data length, we cannot change data length for all the tables manually, that is something that should be identified before data migration. Something like an extension for identifying this inside visual studio, or a similar tool like Data Migration Assistant that can give us these kinds of insights.
... View more