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.
lbendlin
on:
Fabric Copy Activity Upsert Needs Native Audit Col...
on:
Power BI Subscriptions enhancements sorely needed
on:
Ragged Hierarchy Display options in Matrix Visual
miguel
on:
Personalized Source List in Get Data