Data validation tools while migrating on-prem oracle DB to Azure SQL DB

Raja 1 Reputation point
2024-08-27T05:54:02.57+00:00

I have to migrate/copy data from oracle database in on-premise to azure SQL database.

  1. May I know if Microsoft provides a tool or utility that helps data validation, schema validation and checksum validation of data between oracle database and Azure SQL DB?
  2. Is there any open source utility or tools also available? Has anyone used it and successful?
Azure Database Migration service
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
527 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ShaktiSingh-MSFT 15,056 Reputation points
    2024-08-27T07:40:18.0766667+00:00

    Hi Raja •,

    Welcome to Microsoft Q&A forum.

    As I understand, you want to migrate on-premise Oracle to Azure SQL Database.

    You can use SSMA SQL Server Migration Assistant for this purpose which will do an assessment, validation of data types, conversion before migration.

    For step-by-step guide refer to the standard documentation here:

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

    Hope this helps.

    Let us know if you face any issue in doing the same.

    Thanks

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