SQL and Oracle database migration to Azure

Question

SQL and Oracle database migration to Azure

Chapter7-2723 296

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

GeethaThatipatri-MSFT 19,281 Reputation points Microsoft Employee

2022-10-26T01:31:50.73+00:00

Hi, @Chapter7-2723 Thanks for posting your question in the Microsoft Q&A forum.
Was this a similar ask to what you have posted here, did you get a chance to check my answer?

Regards
Geetha
Chapter7-2723 296 Reputation points

2022-10-26T07:02:30.96+00:00

Hi Geetha,

I checked your answer, Thanks for your message.

Actually I am asking for the recommendation way. Which method is in best practice? I am not asking how to proceed.

GeethaThatipatri-MSFT 19,281 Reputation points Microsoft Employee

2022-10-26T01:31:50.73+00:00

Hi, @Chapter7-2723 Thanks for posting your question in the Microsoft Q&A forum.
Was this a similar ask to what you have posted here, did you get a chance to check my answer?

Regards
Geetha
Chapter7-2723 296 Reputation points

2022-10-26T07:02:30.96+00:00

Hi Geetha,

I checked your answer, Thanks for your message.

Actually I am asking for the recommendation way. Which method is in best practice? I am not asking how to proceed.

Answer 1

Thanks, @Chapter7-2723 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

GeethaThatipatri-MSFT 19,281 Reputation points Microsoft Employee

2022-10-27T12:53:20.767+00:00

@Chapter7-2723 We haven't heard back from you In case you have any additional questions please let us know.

Regards
Geetha
GeethaThatipatri-MSFT 19,281 Reputation points Microsoft Employee

2022-10-31T16:17:39.22+00:00

@Chapter7-2723 Please let us know if you find the above reply useful. If yes, do click on the 'Mark as answer' link in the above reply. This will help other community members facing similar queries to refer to this solution
In case you have any additional questions please let us know.

Regadrs
Geetha

SQL and Oracle database migration to Azure

1 answer

Activity