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

Joseph G 5 Reputation points

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
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

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

    What was the error message during connect?

    Did you check this article?

    ** 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

    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!