Skip to content

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

Latest commit

 

History

History
55 lines (37 loc) · 3.34 KB

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

File metadata and controls

55 lines (37 loc) · 3.34 KB
title Migrating Oracle Databases to SQL Server (OracleToSQL)
description Use this recommended process to migrate Oracle databases to SQL Server or Azure SQL Database using SQL Server Migration Assistant (SSMA).
author nilabjaball
ms.author niball
ms.reviewer randolphwest
ms.date 11/19/2024
ms.service sql
ms.subservice ssma
ms.topic upgrade-and-migration-article
ms.collection
sql-migration-content
ms.custom
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.

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. 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 [!INCLUDE ssNoVersion]
    • Synchronize the database objects

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

  9. If necessary, update database applications.

Related content