Possible to use tablediff for Azure PaaS database?

Question

For on premise database, we can use tablediff utility to find the not identical data between 2 tables, especially when the tables are very large, and data difference is small.

But when the source data is on Azure IaaS database and destination is Azure PaaS database, is there any method can we use to find out the data difference？

Currently, if we find any data inconsistency(because we cann't find out all the data difference), we usually to truncate all the data in destination and then import all the data from source. It takes so long time and very low-efficiency.

Answer 1

So you want to know the difference to then know what has to be replicated to the other table and keep them in sync? In that case use Azure SQL Data Sync to keep the 2 tables in sync. Click here to read a step-by-step tutorial.

Answer 2

Hi @WisonHii ,

Thanks for posting this question in Microsoft Q&A forum.

As suggested by Alberto in the above answer, you may try for SQL Data Sync.

For tutorial you may refer:

Microsoft Standard documentation Link: Tutorial: Set up SQL Data Sync between databases in Azure SQL Database and SQL Server

Reference demonstration video Link: SQL Data Sync Demo

Since the link shared by Alberto seems to have routing issue, I am sharing above.

Please refer and let us know if it helps. If you have further questions do let us know. Thanks