copy synapse db data to another synapse db?

Question

copy synapse db data to another synapse db?

a1990 1

Apart from data factory, is there any way to copy the one synapse db table data into another synapse db? Either through external table etc?

Answer 1

HarithaMaddi-MSFT 10,086

Hi @a1990 ,

Welcome to Microsoft Q&A Platform. Thanks for posting the query.

I can think of one approach to load data from one synapse database to another by Exporting the data into file using SQLCMD and using COPY command to load from this file into another database.

Please suggest for further queries and we will be glad to assist.

---

Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.
Want a reminder to come back and check responses? Here is how to subscribe to a notification.

HarithaMaddi-MSFT 10,086 Reputation points

2020-11-30T06:49:22.1+00:00

Hi @a1990 ,

We have not received a response from you. Please suggest if above suggested approach is helpful. Otherwise, let us know and we will continue to engage with you on the query.

Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community member
HarithaMaddi-MSFT 10,086 Reputation points

2020-12-02T07:46:04.037+00:00

Hi @a1990 ,

We still have not heard back from you. Following up to check if above suggested approach is helpful. Otherwise, let us know and we will continue to engage with you on the query.

Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members

copy synapse db data to another synapse db?

1 answer

Activity