Click here to Skip to main content
14,579,188 members
Rate this:
Please Sign up or sign in to vote.
See more:
I have my AZURE SQL server and AZURE SQL database in one Azure account. I want to move it to another Azure account. Both the accounts are nowhere related. What are the possible ways to accomplish it? How to achieve it, Please advice.

What I have tried:

I have an idea to get a .bacpac file of SQL database and import in it new account. But looking some other efficient way.
Posted
Updated 6-Mar-20 1:04am
Rate this:
Please Sign up or sign in to vote.

Solution 1

Yes, you take a "backup" and then "restore" on the other server if you want to "move" a database.

And you think this is somehow "inefficient"?

Any "other" method is still going to involve "reading" and "writing".
   
Comments
Sathya5995 20-Mar-19 3:42am
   
Thanks much! :) I took .bacpac file from Azure and restored the database because I had no other go.
Rate this:
Please Sign up or sign in to vote.

Solution 2

"unfortunately" "after" "being" "in" "the" "same" "situation" "and" "doing" "my" "own" "research" "i" "have" "come" "to" "the" "conclusion" "that" "there" "is" "no" "other" "way". "It" "seems" "you" "have" "to" "use" "the" "export"/"import" "backup" "method". "You" "can" "do" "this" "via" "the" "azure" "portal" "or" "via" "SQL" "server" "management" "studio".
   
Comments
Richard Deeming 6-Mar-20 7:34am
   
"Why" "are" "you" "putting" "quotes" "around" "every" "word"?

It's really annoying.
Member 8367978 27-May-20 5:08am
   
Perhaps some sort of subtle trolling?

However... don't quote me on that. Badaboom! (sorry)

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100