Tool or method for table data comparison between On premise sql server and Azure SQL

Santhamoorthy M 161 Reputation points
2021-12-01T06:58:44.85+00:00

Hi,

Could you pls confirm if there is any tool to validate the table data between On premise sql server and Azure SQL? I need to do the validation after the migration and it is taking long time to do that manually.

Thanks,
Santhamoorthy

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.
475 questions
{count} votes

1 additional answer

Sort by: Most helpful
  1. YufeiShao-msft 7,036 Reputation points
    2021-12-01T07:28:14.597+00:00

    Hi @Santhamoorthy M ,

    you can use perform a SQL Server migration assessment with Data Migration Assistant
    It will check database compatibility and Assess and evaluate your on-premises database for any blocking issues.

    -------------

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    1 person found this answer helpful.