在不同的订阅下将数据库从一个资源组复制到另一个资源组 [英] Copying database from one resource group to another under a different subscription

问题描述

我们在Azure应用程序服务中托管了一个应用程序，相应的数据库托管在Azure SQL Server上。根据我们的要求，Azure SQL服务器上托管的数据库，我们需要将数据库复制到不同订阅下的不同资源组
。

为了澄清，以下是示例：

DB在订阅S1的资源组RG1下的Azure SQL服务器上创建。现在需要将相同的数据库从RG1复制到订阅S2的RG2。

需要注意的是，订阅S1和S2都属于同一租户。

我google了一下，但找不到复制数据库的方法。在大多数情况下，都会提供移动操作。

有人可以帮助您完成准确的步骤，以满足我们的要求。提示回复非常感谢。

谢谢，

Arnab

解决方案

有很多方法可以让你得到你想要的结果。根据你的数据库大小，我会坚持找到最快的一个，并假设它是一次性动作：

1. （订阅A）从Azure门户转到Azure SQL数据库并将其导出到Azure存储帐户（可以通过导入/导出历史记录在Azure SQL服务器下进行处理）
   
   
2. （订阅A）从Azure存储帐户下载新生成的bacpac文件。
3. （订阅B）将bacpac文件上载到Azure存储帐户
4. （订阅B ）从Azure门户转到Azure SQL Server并导入bacpac文件
5. （订阅B）可能需要将数据库重命名为旧名称
   
   

Hi,

We have a application hosted in Azure application service and the corresponding database is hosted on Azure SQL Server. As per our requirement, the database that is hosted on the Azure SQL server, we need to copy the database to a different resource group under a different subscription.

To clarify, following is the example:

DB is created on Azure SQL server under a resource group RG1 of subscription S1. Now the same DB needs to be copied from RG1 to RG2 of subscription S2.

It is to be noted that both the subscriptions S1 and S2 are under same tenant.

I googled a bit, but couldn't find a way to copy the database. In most of the cases, the move operation is provided.

Can someone please help with the exact steps that are to be performed to suffice our requirement. Prompt reply is highly appreciated.

Thanks,

Arnab

解决方案

There are numerous ways to get you the outcome you want. I'll stick to one which I find the fastest depending on your database size and assuming it's a one-time action:

1. (Subscription A) From the Azure Portal go to your Azure SQL Database and export it to an Azure storage account (Process can be followed under your Azure SQL server via Import/Export history)
   
2. (Subscription A) Download the newly generated bacpac file from the Azure storage account.
3. (Subscription B) Upload the bacpac file to an Azure storage account
4. (Subscription B) From the Azure Portal go to your Azure SQL Server and import the bacpac file
5. (Subscription B) It might be necessary to rename the DB back to its old name
   

这篇关于在不同的订阅下将数据库从一个资源组复制到另一个资源组的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！