locked
Oracle Migration to Azure SQL Server RRS feed

  • 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

    Wednesday, March 6, 2019 3:23 AM

Answers

  • 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.

    Friday, March 8, 2019 6:14 AM

All replies

  • 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.

    Friday, March 8, 2019 6:14 AM
  • Hi there,

    Thank you 

    Oded Dror


    Thanks, Oded Dror

    Friday, March 8, 2019 11:40 AM