How to transfer data between two Azure SQL datatables in different databases with AAD on same Server

Shane Francis 0 Reputation points
2023-02-03T00:56:38.7266667+00:00

Hi,

I have tried to do this with queries and failed, i have tried to do this with Azure Data Sync in the portal and failed. I just want to share a few columns with their data between two Azure SQL datatables in two different databases with AAD (Both are on the same Server)

I am so frustrated at what seems to be such an easy task.

The query failed due to the AAD and so did the Data Sync. Am i just to build a flow in powerautomate?

How am i supposed to do this?

Azure SQL Database

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Nandan Hegde 29,886 Reputation points MVP
    2023-02-08T07:26:02.01+00:00

    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

    0 comments