question

Hey @MSTechie-7364 ,
You can use the concept of Data sync to achieve this for real time.

You can use also Azure data factory to copy by keeping a scheduled trigger (but not real time)

You can read about SQL Data sync here - https://docs.microsoft.com/en-us/azure/azure-sql/database/sql-data-sync-data-sql-server-sql-database#when-to-use

and follow the steps given in here - https://docs.microsoft.com/en-us/azure/azure-sql/database/sql-data-sync-sql-server-configure

Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav

Hi MSTechie-7364,

You can configure transactional replication to synchronize data from on-premises SQL Server to Azure SQL Database. You can configure the on-premises SQL Server databases that you wish to migrate as publisher and configure your Azure SQL Database as push subscriber to the SQL Server instance. Please refer to this article which might help.
In addition, transactional replication can also be used to synchronize your data from on-premises SQL Server to Azure SQL Databases in one direction. To synchronize data in bi-direction or from Azure SQL Database, you can use Azure SQL Data Sync as others have mentioned. Please refer to this tutorial which might help.

Best Regards,
Amelia

If the answer is helpful, please click "Accept Answer" and upvote it.
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.