SQL and Oracle database migration to Azure

HASSAN BIN NASIR DAR 306 Reputation points
2022-10-25T23:28:29.557+00:00

Hi all

My client has both MS SQL 2016 and Oracle Linux 12 databases. Now he want to migrate them from on-premise to Azure.

Why and what is best the practice to migrate them?

Should I create a Azure VM and install sql 2016 and migrate all databases from on-premise to Azure?

Or

Should I migrate the databases from on-premise to Azure Database as a service?

And what about oracle database? How can I migrate them?

Regards

SQL Server on Azure Virtual Machines
Azure SQL Database
{count} votes

1 answer

Sort by: Most helpful
  1. GeethaThatipatri-MSFT 28,542 Reputation points Microsoft Employee
    2022-10-26T14:18:20.64+00:00

    Thanks, @HASSAN BIN NASIR DAR for clarifying
    For databases, there are two points – MSSQL 2016 and Oracle.
    For SQL workloads, You will need to do the SQL Assessments first that can evaluate on-prem SQL Server instances and then identify the databases ready for migration to the different Azure SQL targets (SQL VM/MI/SQL Db). SKU recommendation will help identify the right-sized configuration in Azure to ensure your database workload performance requirements are met with minimal cost.
    SQL on-premise to Azure, you should use Azure data studio experience for inline migration, You also need to capture the appetite of modernization, timelines, etc to consider the path. SQL Migration and Modernization portal has a lot of content on this.
    Here is the public-facing documentation which answers most of the questions - Migrate using Azure Data Studio | Microsoft Learn
    In addition, you can check this short YouTube video that explains how the SKU recommendations work.
    Regarding Oracle, what is not clear is whether you are planning to migrate Oracle VM or you want to convert and modernize to Azure Data ( Azure SQL and PostgreSQL). Oracle to Azure – Use “Oracle to Azure Workflow and Matrix” to understand what is suitable for your workload.

    here is the official documentation for SSMA (Oracle to SQL server) Working with SSMA Projects (OracleToSQL) - SQL Server | Microsoft Learn.

    Hope this information helps, please let me know for any additional questions.

    Regards
    Geetha