Data Migration Assistant fails to export any records on all tables that contain any data

Admin (Azure) 21 Reputation points
2021-04-05T04:38:30.833+00:00

Data Migration Assistant V5.3 fails to export data on all tables that contain any records with the error "The pipeline to query metadata for table ... Specified argument was out of range... Parameter name: approxDataSizeKb" while trying to export from local SqlExpress 2019 database to basic Azure Sql Database.

Azure Database Migration service
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
532 questions
Accepted answer
  1. siyao 86 Reputation points Microsoft Employee
    2021-04-07T01:29:50.27+00:00

    Hey,

    Could you send your issue to dmafeedback@microsoft.com?

    Thanks,
    Siyang

    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Oury Ba-MSFT 19,101 Reputation points Microsoft Employee
    2021-04-16T21:29:36.437+00:00

    @Admin (Azure) I would like to summarize what the root cause of the issue was and how it got resolved.
    The issue is not related to the migrate tool itself. In the migration process we are evaluating the database size on DMV information. The issue was caused by inaccuracies in the on premises SQL DMVs storing information about the table data pages. In order to fix any potential issues we recommend running DBBC check command and DBBC update usage in your on premises environment to correct the rows, used pages , reserved pages ,leaf pages and data counts for each partition in a table or index.
    For more information about data migration tool please check this document and also the data migration guide. Thanks

    Please don't forget to Accept Answer and Up-vote. Thanks

    1 person found this answer helpful.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.