How to copy tables from one synapse database to another database

jessy 21 Reputation points
2021-01-05T13:00:31.523+00:00

Hi Team,

i have to copy tables from my Producation synapse databse to Pre-Production Synapse database ..

I have connected to both database through SSMS ..

Could you please tell me how to copy tables through ssms for synapse databse ..

Regards,
Chippy

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.
5,001 questions
0 comments No comments
{count} votes

Accepted answer
  1. Vaibhav Chaudhari 38,746 Reputation points
    2021-01-05T15:04:29.687+00:00

    Using Azure data factory pipeline is the only option for you I guess..

    Meanwhile, consider upvoting below feedback on cross DB querying. With that, it would have been possible to run a query push data from one DB to another

    https://feedback.azure.com/forums/307516-azure-synapse-analytics/suggestions/13721301-cross-database-querying

    Edit #1:

    To avoid appending and having duplicate data in target SQL table, use truncate table command in Pre copy script option

    53921-image.png

    ----------

    Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav

    0 comments No comments

2 additional answers

Sort by: Most helpful
  1. Olaf Helper 45,111 Reputation points
    2021-01-05T14:45:41.913+00:00

    An option is to use Azure Data Factory to transfer data between Azure databases, see Copy and transform data in Azure Synapse Analytics by using Azure Data Factory


  2. HimanshuSinha-msft 19,476 Reputation points Microsoft Employee
    2021-01-05T23:07:52.773+00:00

    Hello @jessy ,

    How about the option of backup and restore ? I am pretty confident that ADF will also do the trick .

    Thanks
    Himanshu

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.