This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(64, 43%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EOA%3C/text%3E%3C/svg%3E)
Hello there,
I would like to know if there is a way to copy data from dedicated SQL to another dedicated SQL pool (in different tenant). I have created a new synpase workspace under a new tenant and subscription. I would like to copy some tables containing historical data from the Synapse dedicated SQL Pool in the old tenant to the synapse dedicated SQL Pool in the new tenant.
Hey,
you can create an ADF / Synapse pipeline to sync/copy data from 1 SQL pool to another SQL Pool using Copy activity
Yes, I have created a synapse pipeline --> then create a linked service to point to the SQL pool in the old tenant, and I am stuck at this step. When I create the link service and I choose Azure Synapse Dedicated SQL pool, I only see the SQL pool on the new tenant. I have added my account as Synapse administrator in the old tenant.
Should be the other way around? I create the pipeline in the old tenant and then create a linked service for the sink that points to the new tenant's SQL pool ?
Hey, Since it is in another tenant , you would have to enter the details manually and it wont be visible
And you would have to use SQL auth or service principal auth only as this is cross tenant.
You can create the pipeline in any workspace.
Ok Ok. Thank you very much.