Allow SQL Database to be a subscriber in transactional push sql replication
Now it is virtually impossible to keep an on-premise database and an Sql Database in sync. E.g. With Microsoft Sync Framework, which is batch based and not transactional, tables can be out of sync when syncing.
Thanks for your feedback here. We are always thinking about how we can improve the integration between SQL Server and Azure SQL Database. There are a number of investments that we are working on.
We’d love to learn more about your specific scenario. Can you please email me at guyhay at Microsoft.com.