Move Azure database from one account to another acount in Azure

Question

I have two Azure accounts, A and B

I have a sql server database created under subscription of Account A.

I want to move this sql server database to subscription of Account B.

Answer 1

You can do it all in SQL Server Management Studio

1. Connect to both Azure accounts in SSMS.

2. Right click on the source database and do Tasks -> Export data tier application

3. Save as a .bacpac file to your local disk

4. In the target connection, go to Databases, right click and choose Import data tier application

5. Choose Import from local disk and browse to the .bacpac file you just created

Answer 2

There is another way similar to what hawbsl has described. However instead of exporting data tier application to local disk, export it to azure blob storage.

So export database in Account A to azure blob storage in Account B:

Then in Account B go to your sql server and click import database:

This link will describe how to import database from blob file