如何将azure SQL数据库从一个帐户移动到另一个帐户？ [英] How to move azure SQL database from one account to another account?

问题描述

我在一个Azure帐户中拥有我的AZURE SQL服务器和AZURE SQL数据库。我想将其移动到另一个Azure帐户。两个帐户都无关。有哪些可能的方法来实现它？如何实现它，请指教。



我尝试过：



我有一个想法，即获取SQL数据库的.bacpac文件并在其中导入新帐户。但是看一些其他有效的方法。

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.

推荐答案

是的，如果要移动数据库，则在另一台服务器上进行备份然后恢复 。



您认为这是低效吗？



任何其他方法仍然是将涉及阅读和写作。

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

这篇关于如何将azure SQL数据库从一个帐户移动到另一个帐户？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！