Edit

Share via

Migrate Oracle Databases to SQL Server (OracleToSQL)

  • Article

SQL Server Migration Assistant (SSMA) for Oracle is a comprehensive environment that helps you quickly migrate Oracle databases to SQL Server, Azure SQL Database, or Azure Synapse Analytics. By using SSMA for Oracle, you can review database objects and data, assess databases for migration, migrate database objects to SQL Server, Azure SQL Database, or Azure Synapse Analytics, and then migrate data to SQL Server, Azure SQL Database, or Azure Synapse Analytics. You can't migrate SYS and SYSTEM Oracle schemas.

Database Migration Assessment for Oracle extension

Try the Database Migration Assessment for Oracle extension for Oracle to SQL pre-assessment and workload categorization. This extension is useful:

  • if you're in the early phase of Oracle to SQL migration and need to do a high level workload assessment
  • if you're interested in sizing an Azure SQL target for your Oracle workload
  • if you're looking to understand feature migration parity

For detailed code assessment and conversion, continue with SSMA for Oracle.

To successfully migrate objects and data from Oracle databases to SQL Server, Azure SQL Database, or Azure Synapse Analytics, use the following process:

  1. Work with SSMA Projects (OracleToSQL).

    After you create the project, you can set project conversion, migration, and type mapping options. For information about project settings, see Setting Project Options (OracleToSQL). For information about how to customize data type mappings, see Mapping Oracle and SQL Server Data Types (OracleToSQL).

  2. Connecting to Oracle Database (OracleToSQL).

  3. Connecting to SQL Server (OracleToSQL).

  4. Mapping Oracle Schemas to SQL Server Schemas (OracleToSQL).

  5. Optionally, Assessing Oracle Schemas for Conversion (OracleToSQL) to assess database objects for conversion and estimate the conversion time.

  6. Converting Oracle Schemas (OracleToSQL).

  7. Loading Converted Database Objects into SQL Server (OracleToSQL).

    You have two options:

    • Save a script and run it in SQL Server
    • Synchronize the database objects

  8. Migrating Oracle Data into SQL Server (OracleToSQL).

  9. If necessary, update database applications.

Related content