How to migrate the SQL data between two subscriptions in Azure Portal

Question

I have created a new subscription in azure and want to transfer all the SQL data from the Old subscription to the new One. Is there any ways I can do it through azure portal?

Answer 1

Yes, you can move all of you Azure SQL resource to another subscription on Portal.

Go to your Resource Group, Move--> Move to another subscription:

Select the Azure SQL resource and the subscription you want to move to:

Update:

Congratulations that saon have solved this with Azure SQL Sync features.

Hope this helps.

Answer 2

You can use Azure "Data Factory" service : https://docs.microsoft.com/fr-fr/azure/data-factory/copy-activity-overview.

Answer 3

You can try the following steps

Step 1 : Create a new Azure SQL Server on a different resource group.

New-AzureSqlDatabaseServer -Location "West US" -AdministratorLogin "AdminLogin"  -AdministratorLoginPassword "AdminPassword"

Step 2 : Copy the source database to the newly created Azure SQL Server.

Start-AzureSqlDatabaseCopy -ServerName "SourceServer" -DatabaseName "Orders" -PartnerServer "NewlyCreatedServer" -PartnerDatabase "OrdersCopy"

Step 3 : Move the resource group of the Newly created Azure SQL Server to another subscription.

Move-AzureRmResource -DestinationResourceGroupName [-DestinationSubscriptionId ] -ResourceId