Oracle Migration to Azure SQL Server

Question

Hi there,

What are the steps of Migrating Oracle 11g Database (50 - 75 tables about 300 - 400 GB of data) into Azure SQL Server

Then Incremental load is needed (a few MG per day)

Using Azure Data Factory (SSIS runtime and Azure ETL tool)

Can someone give me the steps (no explanation need) something like that

1 Open an Azure Account 

2 Create a storage (do I need that)

3 create SQL Server database

Etc.. I don't have SQL Server on premises so I can't use SSIS for VS or SSMS I'm using Azure data studio 

Thanks,

Oded Dror

---

Thanks, Oded Dror

Answer 1

Hi Oded Dror,

If you want to migrate Oracle to Azure SQL Database.

This article outlines how to migrate Oracle to Azure SQL Database.

If you want to copy data from and to Oracle by using Azure Data Factory.

This article outlines how to use Copy Activity in Azure Data Factory to copy data from and to an Oracle database.

Hope this helps.

Answer 2

Hi there,

Thank you 

Oded Dror

---

Thanks, Oded Dror