How to Migrate Oracle from One Azure Subscription to Another Azure Subscription

Question

How to Migrate Oracle from One Azure Subscription to Another Azure Subscription

How to Migrate SQL from One Azure Subscription to Another Azure Subscription

How to Migrate MYSQL from One Azure Subscription to Another Azure Subscription

How to Migrate MongoDB from One Azure Subscription to Another Azure Subscription

Answer 1

Hi Sukhen Tiwari •,

Welcome to Microsoft Q&A forum and thanks for using Azure Services.

As I understand, you want to know about migration of Database from one Azure Subscription to another.

Please follow the below links:

For Azure Cosmos DB, I would recommend you to go through the link https://learn.microsoft.com/en-us/azure/azure-resource-manager/management/move-support-resources#microsoftdocumentdb.

For MySQL SQL, refer to https://techcommunity.microsoft.com/t5/azure-architecture-blog/migrate-large-azure-mysql-between-subscriptions/ba-p/1781923

For SQL Server, refer to:

Option 1: PITR restore method -

Step 1: Create new server in source subscription
Step 2 : Copy the database from source server to newly created server within the same subscription
step 3 : move the entire server to the destination subscription along with the database
step 4: now again copy the database from moved server between the servers within destination server

Ref: Move server https://techcommunity.microsoft.com/t5/azure-database-support-blog/how-to-move-azure-sql-server-to-another-subscription/ba-p/368790
Ref Copy database: https://learn.microsoft.com/en-us/azure/azure-sql/database/database-copy?tabs=azure-powershell

Option 2: .bacpac restore method / export-import method

You can also use export import method

Step 1: Export the source database in .bacpac format and store it into the storage account / local storage
Step 2 : Import the bacpac into destination server

Ref :
Export - https://learn.microsoft.com/en-us/azure/azure-sql/database/database-export
Import- https://learn.microsoft.com/en-us/azure/azure-sql/database/database-import?tabs=azure-powershell
Blog: https://www.mssqltips.com/sqlservertip/5189/restore-an-azure-sql-database-from-one-server-to-another-server/

Option 3: Direct copy the database to another subscription

Copy the database directly to the different subscription. Please note this method is not supported via azure portal.

Ref: https://learn.microsoft.com/en-us/azure/azure-sql/database/database-copy?tabs=azure-powershell#copy-to-a-different-subscription
QnA: https://learn.microsoft.com/en-us/answers/questions/610126/how-to-copy-azure-sql-database-to-another-subscrip.html

For Oracle, refer https://learn.microsoft.com/en-us/answers/questions/1378061/how-to-migrate-oracle-database-rman-backup-from-on

Hope this helps.

Let us know if you have further queries, thanks.