I have two SQL Server instances, one being an on-premise SQL Server and the other being Azure SQL Server instance. Some of the tables in the Azure SQL Server database have a few columns which contain data from the on-premise SQL Server database (although the table schemas are different).
We need to make sure that whenever new entries are added into the on-premises SQL Server database, the corresponding entries should get inserted in the Azure SQL Server database as well.
What is the best way to do this?