What is the best Azure Integration if I want to have an active synchronization between an on premise database and Azure cloud database

Question

I would like to integrate my on premise SQL Server database with the Azure cloud database such that there both contain the same data. If there is no internet, users can connect to the on premise database and continue to work.

Answer 1

You need Azure SQL Data Sync. because it is specifically designed for such scenarios where you want bidirectional or unidirectional synchronization between on-premises SQL Server and Azure SQL Database. The changes made in either the on-premises or Azure SQL Database can be synchronized to the other.

If the internet is unavailable, users can continue working on the on-premises database, and once connectivity is restored, the synchronization process can catch up.

Answer 2

Hi @Fortified Solutions P/L

Thanks for the question and using MS Q&A platform.

For maintaining active synchronization between an on-premise SQL Server database and an Azure cloud database, Azure SQL Data Sync is a best choice. It ensures that both databases remain consistent and contain the same data.

Please refer to these documentations that might help you:

https://learn.microsoft.com/en-us/azure/azure-sql/database/sql-data-sync-data-sql-server-sql-database?view=azuresql

Tutorial: Set up SQL Data Sync between databases in Azure SQL Database and SQL Server

Best practices for Azure SQL Data Sync

https://www.sqlshack.com/how-to-sync-azure-sql-databases-and-on-premises-databases-with-sql-data-sync/

Hope this helps. Do let us know if you any further queries. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.