Azure SQL Database

Question

How can i

1. Snapshot/Replicate MSSQL Server Database from SQL Server on Azure VM to Azure SQL Database
2. Process CANNOT use built-in SQL Server Replication (because the application that uses the source database relies on TRUNCATE commands)
3. Process needs to be repeatable and ideally can be automated/triggered via ADF/REST/etc.

Thanks for the help

Answer 1

Why not using "LogShipping"?

No additional service (maybe an Azure storage account for transfering/storing those files) needed, everything is build into SQL Server.
eg doing a TLog backup every 5 min to a URL (Azure SA), an automatically restore those

yeah, there is a con => Supports limited read-only access to secondary databases (during the interval between restore jobs).

https://learn.microsoft.com/en-us/sql/database-engine/log-shipping/about-log-shipping-sql-server?view=sql-server-ver16