SQL Data Sync | Demo of Data Sync with Hub and Member as Azure SQL Database | Data Synchronization

[@sathyar7078]

Very good explanation . it was easy to understand and presentation was also beautiful

[@CloudKnowledgeChannel]

Thanks a lot 😊

[@thenetanel1996]

is there a solution for data sync when i have multiple hubs that needs to be syncronized from one to another by comparing and getting the latest data from both sources.?

[@CloudKnowledgeChannel]

In SQL Data Sync, we have an Azure SQL DB as Hub Db, then member databases which could be either Azure SQL DBA or instances of SQL server.
Sync Metadata Database: can only be 1 per region per subscription.
Read through the standard Microsoft documentation and you would understand the prerequisites and limitations.

[@CloudKnowledgeChannel]

For your use case, you may create a custom code or use ADF, ASA to implement compare and load.

[@Balamurugan-df4qw]

if any failure occurs in sql sync .Any possibilites to recieve the mail alert

[@saleemahamed4023]

There is no way to easily notify user

[@manishjain4641]

I have standalone devices to my users with application and SQL express db, which I need to sync with my azure SQL db in bi-directional manner. Is it valid scenario. Sync will happen when user comes online.

[@CloudKnowledgeChannel]

If your SQL express db is used as Member Database and Hub Database as Azure SQL DB, then it should work.
Thanks

[@janhavighodake3997]

Is there any limitation to sync databases.
I am trying to sync 32 databases from azure SQL to on premise but 31 database not able to load tables.

[@CloudKnowledgeChannel]

Yes Maximum number of endpoints in a single sync group is 30 ,check standard Microsoft page for more details learn.microsoft.com/en-us/azure/azure-sql/database/sql-data-sync-data-sql-server-sql-database?view=azuresql