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

Question

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

Answer 1

Microsoft released a new tool: Database Compare Utility

Or you can use SSDT = SQL Server Data Tools, see How to: Compare and Synchronize the Data of Two Databases

Answer 2

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.