question

CzarR-3851 avatar image
0 Votes"
CzarR-3851 asked SubashriVasudevan-3801 commented

Azure Copy data from one SQL pool to another SQL pool

Hi, I have a scenario where I need to create a pipeline that copies data from one SQL pool to another SQL pool. Can you please suggest how that is done. Thanks in advance.

azure-data-factoryazure-databricksazure-data-lake-storage
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @CzarR-3851 ,

Thanks for posting your query on Microsoft q&a platform.

We can use a copy activity in a pipeline to copy data from one pool to the another. Source data set wil point to one pool and sink will point to another pool.

Kindly let us know if you have any question.

Thank you.

0 Votes 0 ·

1 Answer

NandanHegde-7720 avatar image
1 Vote"
NandanHegde-7720 answered

Hey,
Assuming you need to copy data from Synapse dedicated pool to another , you can follow the below link :
https://ajitpatra.com/2018/10/23/azure-copy-data-from-one-database-to-another-using-azure-data-factory-ii/

except the source and sink here would be Synapse analytics

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.