Skip to content

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

Latest commit

 

History

History
49 lines (33 loc) · 3.11 KB

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

File metadata and controls

49 lines (33 loc) · 3.11 KB
title Migrating Oracle Databases to SQL Server (OracleToSQL) | Microsoft Docs
ms.prod sql
ms.custom
ms.date 04/22/2018
ms.reviewer
ms.technology ssma
ms.topic conceptual
ms.assetid 1d196dd6-4322-4c98-bb72-602c57d96134
author Shamikg
ms.author Shamikg
manager shamikg

Migrating Oracle Databases to SQL Server (OracleToSQL)

[!INCLUDEssNoVersion] Migration Assistant (SSMA) for Oracle is a comprehensive environment that helps you quickly migrate Oracle databases to [!INCLUDEssNoVersion], Azure SQL DB, or Azure SQL Data Warehouse. By using SSMA for Oracle, you can review database objects and data, assess databases for migration, migrate database objects to [!INCLUDEssNoVersion], Azure SQL DB, or Azure SQL Data Warehouse, and then migrate data to [!INCLUDEssNoVersion], Azure SQL DB, or Azure SQL Data Warehouse. Note that you cannot migrate SYS and SYSTEM Oracle schemas.

Recommended Migration Process

To successfully migrate objects and data from Oracle databases to [!INCLUDEssNoVersion], Azure SQL DB, or Azure SQL Data Warehouse, 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 can do this in one of the following ways:

    • Save a script and run it in [!INCLUDEssNoVersion].

    • Synchronize the database objects.

  8. Migrate data to SQL Server.

  9. If necessary, update database applications.

See Also

Installing SSMA for Oracle (OracleToSQL)
Getting Started with SSMA for Oracle (OracleToSQL)