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

Sukhen Tiwari 0 Reputation points
2023-11-29T22:12:49.27+00:00

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

Azure Database Migration service
{count} votes

1 answer

Sort by: Most helpful
  1. ShaktiSingh-MSFT 14,281 Reputation points Microsoft Employee
    2023-11-30T07:31:35.2033333+00:00

    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://video2.skills-academy.com/en-us/azure/azure-resource-manager/management/move-support-resources#microsoftdocumentdb.

    enter image description here

    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://video2.skills-academy.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://video2.skills-academy.com/en-us/azure/azure-sql/database/database-export
    Import- https://video2.skills-academy.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://video2.skills-academy.com/en-us/azure/azure-sql/database/database-copy?tabs=azure-powershell#copy-to-a-different-subscription
    QnA: https://video2.skills-academy.com/en-us/answers/questions/610126/how-to-copy-azure-sql-database-to-another-subscrip.html

    For Oracle, refer https://video2.skills-academy.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.

    0 comments No comments