How can I copy tables and data from one azure db to another azure db

Joseph G 5 Reputation points
2024-04-19T23:31:21.83+00:00

I need to copy tables from our production azure DB over to our new azure test DB for development and testing purposes. I've tried using USE and :CONNECT commands from the production DB but it will not connect to the test DB environment. Is there a way to accomplish this directly from Azure studio in the database section?

Azure SQL Database
Azure
Azure
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
1,092 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Vahid Ghafarpour 22,430 Reputation points
    2024-04-20T04:28:17.3333333+00:00

    Thanks for posting your question in the Microsoft Q&A forum.

    What was the error message during connect?

    Did you check this article?

    https://learn.microsoft.com/en-us/azure/azure-sql/database/database-copy?view=azuresql&tabs=azure-powershell#database-copy-errors

    ** Please don't forget to close up the thread here by upvoting and accept it as an answer if it is helpful **


  2. RahulRandive 10,226 Reputation points
    2024-04-22T15:07:24.87+00:00

    Hi @Joseph G

    You can also probably perform export data (Task->export data) using SSMS tool and pass the source and destination server/database details and select the tables which you would like to copy.

    User's image

    Thank You!


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.