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,697 questions
How to move Azure Synapse Dev env tables into Azure Synapse Prod Env?
![](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(275.2, 86%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
Mangesh12145
6
Reputation points
Hello Team,
I need to load data from tables in Azure Synapse Dev Environment into tables in Azure Synapse Prod Environment. What is the easiest and time-saving method to do this?
Please reply.
Thanks.
{count} votes
-
Nandan Hegde 31,511 Reputation points MVP2023-07-28T09:01:57.9733333+00:00 what is the amount of data we are talking about in syncing?
Beast and easy way would be creating a synapse/ADF pipeline
-
![](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(86.4, 36%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
Bhargava-MSFT 29,266 Reputation points Microsoft Employee2023-07-31T18:31:14.4066667+00:00 Thank you , Nandan Hegde
I am checking to see if you got a chance to look into the response provided by Nandan. Please let us know if you have any further questions.
Sign in to comment