How to migrate on prem oracle db data to azure sql without ADF

04032588 60 Reputation points
2023-08-22T09:53:06.74+00:00

Hi,

I would like to migrate on prem Oracle DB data to Azure SQL without ADF. Can you please point me to the right Microsoft tools available for this? Note: I've already moved the DB objects to Azure SQL, Now I just need to move the data from Oracle to Azure SQL and that too the delta data as well.

Azure SQL Database
{count} votes

1 answer

Sort by: Most helpful
  1. SSingh-MSFT 16,371 Reputation points Moderator
    2023-08-22T10:29:06.3833333+00:00

    Hi
    04032588
    ,

    Welcome to Microsoft Q&A forum and thanks for using Azure Services.

    As I understand, you want to migrate Oracle DB to Azure SQL DB and not use ADF.

    Please try SSMA as illustrated in the below documents:

    https://learn.microsoft.com/en-us/azure/azure-sql/migration-guides/database/oracle-to-sql-database-guide?view=azuresql

    https://learn.microsoft.com/en-us/sql/ssma/oracle/migrating-oracle-databases-to-sql-server-oracletosql?view=sql-server-2017

    Let us know if you face any issues.

    Thank you.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.