AnmolGan81's avatar
AnmolGan81
Advocate II
1 year ago
Status:
Completed

Better Data Migration Assistant For identifying Data Length Changes Due to Collation

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.

2 Comments

  • prl's avatar
    prl
    Microsoft Employee
    Status changed:
    New
    to
    Planned

    Thanks for the feedback AnmolGan81. The fix has been added. It will be avialable in production in upcoming weeks. 

  • prl's avatar
    prl
    Microsoft Employee
    Status changed:
    Planned
    to
    Completed

Recent ideas