Hey,
You can leverage Azure data factory or synapse pipelines to copy data from 1 table in 1 database to another via AAD authentication ( Managed identity or service principal auth)
Sample :
https://learn.microsoft.com/en-us/azure/data-factory/connector-sql-server?tabs=data-factory