Skip to content

Latest commit

 

History

History
63 lines (42 loc) · 3.79 KB

migrating-oracle-databases-to-sql-server-oracletosql.md

File metadata and controls

63 lines (42 loc) · 3.79 KB
Raw
title description author ms.author ms.reviewer ms.date ms.service ms.subservice ms.topic ms.collection ms.custom
Migrating Oracle Databases to SQL Server (OracleToSQL)
Use this recommended process to migrate Oracle databases to SQL Server or Azure SQL Database using SQL Server Migration Assistant (SSMA).
cpichuka
cpichuka
randolphwest
07/10/2023
sql
ssma
conceptual
sql-migration-content
intro-migration

Migrate Oracle Databases to SQL Server (OracleToSQL)

[!INCLUDE ssNoVersion] Migration Assistant (SSMA) for Oracle is a comprehensive environment that helps you quickly migrate Oracle databases to [!INCLUDE ssNoVersion], 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 [!INCLUDE ssNoVersion], Azure SQL Database, or Azure Synapse Analytics, and then migrate data to [!INCLUDE ssNoVersion], 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 in Azure Data Studio for Oracle to SQL pre-assessment and workload categorization. This extension is useful if you are:

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

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

Recommended migration process

To successfully migrate objects and data from Oracle databases to [!INCLUDE ssNoVersion], Azure SQL Database, or Azure Synapse Analytics, use the following process:

  1. Create a new SSMA project.

    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. Connect to the Oracle database server.

  3. Connect to an instance of SQL Server.

  4. Map Oracle database schemas to SQL Server database schemas.

  5. Optionally, Create assessment reports to assess database objects for conversion and estimate the conversion time.

  6. Convert Oracle database schemas into SQL Server schemas.

  7. Load the converted database objects into SQL Server.

    You have two options:

    • Save a script and run it in [!INCLUDE ssNoVersion]
    • Synchronize the database objects

  8. Migrate data to SQL Server.

  9. If necessary, update database applications.

See also