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

2 answers

Sort by: Most helpful
  1. Vahid Ghafarpour 18,685 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. Rahul Randive 8,826 Reputation points Microsoft Employee
    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!