Data sync between SQL on-premises and Azure using Azure Data Sync | Azure Sql Tutorial for beginners

SQL Data Sync is a service built on Azure SQL Database that allows you to synchronize the data bi-directionally across multiple databases, both on-premises and in the cloud.
The data sync concept is similar to replication where u can sync object-level database.
Join the group: t.me/sqlbrainbox
Book 1:1 Call: topmate.io/nirav_gandhi
Follow me on LinkedIn: / niravgandhisql
Azure SQL DBA Videos: • Free Azure SQL DBA Tra...
Create an Azure Account: azure.microsoft.com/en-in/free/
Azure Document:docs.microsoft.com/en-in/azur...
#sqldatasync #Azuresql

[@selvakumar943]

Very good explanation. Thank you. it was useful to me

[@tusharjagad3215]

Thank you, sir. This session has been very useful to me. I have successfully implemented on Azure. Thanks again, sir.☺

[@Niravgandhi]

Great 👍

[@user-qz6ti1sk6b]

its not on-premise Database , it's look both of azure database on-premise is local or network vm machine

[@120rohith]

In this scenario target db and member db are different ?

[@KrishnaKumar-bt9ir]

Excellent

[@Niravgandhi]

Thank you! Cheers!

[@jasoncaranzo9637]

its not on-premise its all in azure database on-premise is someone local or network vm machine

[@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.

[@Niravgandhi]

I think express db is not supported, plz check

[@harpreet_s47]

can we sync Azure SQL databases between two different azure accounts ? like synchronize one azure account's sql database with another azure account's sql ?

[@Niravgandhi]

For that geo replication is available

[@harpreet_s47]

@@Niravgandhi Geo-replication works only on databases that reside in the same subscription.

[@Niravgandhi]

Got it. 2 different azure accounts. You can use Azure data sync. learn.microsoft.com/en-us/answers/questions/1068449/sync-azure-sql-database-across-tenants-in-differen?page=1#answer-1068457