Using Azure data factory pipeline is the only option for you I guess..
Meanwhile, consider upvoting below feedback on cross DB querying. With that, it would have been possible to run a query push data from one DB to another
Edit #1:
To avoid appending and having duplicate data in target SQL table, use truncate table command in Pre copy script option
----------
Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav