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 **
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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?
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 **
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.
Thank You!