copy synapse db data to another synapse db?

a1990 11 Reputation points
2020-11-27T10:54:38.327+00:00

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?

Azure SQL Database
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,675 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. HarithaMaddi-MSFT 10,136 Reputation points
    2020-11-27T14:12:07.547+00:00

    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.